MySQL Slow on certain queries

[Acieke]

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

[jalal]

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.

[cpanelnick]

Here is a good article about optimizing mysql tables:

http://www.databasejournal.com/featu...le.php/1382791

You might always want to check your

iostat

as mysql may not be the issue