High MySQLd load

[RackSystems]

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

 

[tribal-dolphin]

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"

 

[RackSystems]

I have this problem also with httpd, is there a way where i can view the requested url's?

 

[tribal-dolphin]

Yes ............ on the apache logs !!

 

[RackSystems]

No i mean the current sessions my apache log is way to big

 

[l0rdphi1]

Apache does have a server-status mode. You have to enable it in httpd.conf on a specific URL.

See http://httpd.apache.org/docs/mod/mod_status.html for details.