High MySQLd load

RackSystems

Verified User
Joined
Oct 4, 2004
Messages
50
Location
Deventer, The Netherlands
Hello,

a web server with directadmin runs 160 mysqld procs. I think one user is pushing mysql to its limit's. How can i find out which database is using this huge load?

Thnx
 
Hello,

Connect to phpMyAdmin as root and click on Show processes link.

In the next page, you see a table with all the processes of mysqld.
In this table, you can see the user name (and the database) for each process. You can easily find the "bad guy" ;)
 
Back
Top