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!