MySQL Automated process killers

[yamaharr1]

Can anyone recommend an MySQL Automated process killer?

I am looking for ways to limit the resources per user account, at this time MySQL is starting to become an issue so any information would be very helpfil, thank you.

 

[chirpy]

You should really search for some good MySQL performance tutorials on how to optimise it for your particular needs. A good starting point would be the MySQL site itself:
MySQL :: MySQL 5.0 Reference Manual :: 7.5 Optimizing the MySQL Server

 

[activa]

look at the script Named: watchmysql


cPlicensing: cPanel Scripts

 

[yamaharr1]

look at the script Named: watchmysql


cPlicensing: cPanel Scripts

Where is this located?

Edit

never mind I see the link now. Thank you.

 

[david510]

You can install mytop on the server and view the mysql usage.