MySQL Slow on certain queries

Acieke

Member
Nov 13, 2004
13
0
151
Hello,

Since a few days I'm experiencing some strange mysql problems:
On certain queries, that cpanel runs for example to list user's db, mysql is VERY slow or just doesn't respond; on other queries it runs normally.

By running mtop, I get the following queries to be slow:
Mostly, the query "SELECT user,db from Db WHERE IN ('ace2\_testdb')", which is run when you click "MySQL Databases" in cPanel, is problematic.

When I manually run a SELECT User,DB FROM DB, it gives no problem.
This morning I ran mtop again, and saw a few of the above queries that were hung, and also some 5 "FLUSH PRIVILEGES" that were hung.

I ran myisamchk and mysqlcheck --repair on all the mysql db tables, doesn't help. I did a upcp, as a newer version was available, no help. Also mysqlup --force didn't help.

For any advice on this I would be very grateful!

Thanks
Fréderic
 
Last edited:

jalal

Active Member
Jun 15, 2005
33
0
156
Same here

I've got the same problem here. Queries that used to take about 10secs take between 10-12 minutes.

I've run all cPanel updates and checked the tables, but can't find anything wrong yet.

:(