Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : mysql usage: high CPU %, how do i find out who's using what?

[chamelion]

title says it all

just noticed mysql cpu usage has shot up from its usual 5-10% cpu to 30%+. domains are as normal and no extraordinary php processes.

any way i can tell what users are most heavily running mysql? (as in number queries / slow queries etc?) i know mysqladmin processlist but that only gives me a snapshot, whereas i want to see over 24 hours, who used mysql the most...

any help appreciated
thanks!

[ub3r]

look at your mysql processlist.

[chamelion]

quote from my original post:

i know mysqladmin processlist but that only gives me a snapshot, whereas i want to see over 24 hours, who used mysql the most...

[Thomas]

Check MySQL log file /usr/local/mysql/var

[xbox360]

I'm sure mytop is very handy in this case.

[RBBOT]

The only way to get detailed per-user stats other than logging every query is compile in the patches Google have made to mysql.

[ISPserver]

Usually if database index crashed mysql use a lot of CPU. Try to fix index with myisamchk see to

http://dev.mysql.com/doc/refman/5.0/en/check.html

It work only if your use MyISAM tables.