Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : high MySQL Usage

[rs2host]

hello
on my server
i have 104 accounts
and the MySQL Usage for th cpus is 25.23
like this pic
http://img518.imageshack.us/img518/311/46543674ak2.jpg
is that danger ????
and how can i resolve it ???????

[LoganNZ]

yes it is a cause for concern, what MySQL version are you running?

Also, any accounts thrashing PHP scripts? Something must be chewing away.

Regards,
Logan

[rs2host]

my MYSQL version is 5.0.45-community
how can i resolve this problem

[LoganNZ]

Can you post a TOP command result when load spikes as MySQL hogs everything..

Also, can you post config of MySQL?

Do you have any resource intensive scripts on the box?

Regards,
Logan

[nice-price]

Please run the command/program "mtop". This program shows you, who is running which query.

[rs2host]

tis is the pic
plz allow me to know what is the problem
http://img187.imageshack.us/img187/1...nshot54ek8.png
http://img174.imageshack.us/img174/2...nshot56py0.png
and how to resolve it

[ub3r]

This isn't going to work if it takes you 4 days to run a command. Please hire someone who knows what he or she is doing.