hi all,
i want to monitor mysql processes/threads/queries with respect to cpu usage.how can i do it?
show processlist is of no use as no information abt cpu usage is given.
plz help
Which version of unix do you have?
Have you tried the tool, mysqltop (also known as mtop, as I recall)?
i am using sun solaris unix version10.
regarding mtop is it external tool?
You can easily run a Google search for these tools, can't you?
hi Neo,
i dont want to use any external tool .i want to do it using unix and mysql commands if possible
Mytop is a tool written in Perl.
remember the magic tool "grep" if you combine this with mysql queries you can get all the info you want