Server high load issue please help

i get this from the data center and how can i fix it..... its was running fine b4 without any changes



Server's load suddenly got too high due to user vipdesi.

[root@server ~]# mysqladmin processlist
+------+---------------+-----------+---------------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time |
State | Info |
+------+---------------+-----------+---------------------+---------+------+-------+------------------+
| 1556 | eximstats | localhost | eximstats | Sleep | 18 |
| |
| 1697 | vipdesi_romeo | localhost | vipdesi_vipfox | Sleep | 85 |
| |
| 1699 | vipdesi_romeo | localhost | vipdesi_vipfox | Sleep | 85 |
| |
| 1700 | vipdesi_romeo | localhost | vipdesi_vipfox | Sleep | 86 |
| |
| 1701 | vipdesi_romeo | localhost | vipdesi_vipfox | Sleep | 85 |
| |
| 1703 | vipdesi_romeo | localhost | vipdesi_vipfox | Sleep | 85 |
| |
| 1702 | vipdesi_romeo | localhost | vipdesi_vipfox | Sleep | 85 |
| |
| 1704 | vipdesi_rohan | localhost | vipdesi_sharemovies | Sleep | 85 |
| |
| 1705 | vipdesi_rohan | localhost | vipdesi_sharemovies | Sleep | 85 |
| |
| 1706 | vipdesi_romeo | localhost | vipdesi_vipfox | Sleep | 85 |
| |
| 1707 | vipdesi_romeo | localhost | vipdesi_vipfox | Sleep | 85 |
| |
| 1712 | root | localhost | | Query | 0 |
| show processlist |
+------+---------------+-----------+---------------------+---------+------+-------+------------------+

 

find that account and your countrol panel and see what site he is running that has a high load

 

Are you sure its mysql causing the high loads? What does top tell you?

 

i think it the mysql and some 1 has a a big database that making the high load on the server

 

I don't think MySQL causing the problem. The mysql processes show few connections and they are in sleep stats. You will need to find the processes which are causing the problem. Can you paste the output of top command (Make sure you provide output of top when the server load is high)?

Kailash

 

Let we know your Hardware information.
How much users you have and i can let you know if you must upgrade harware or limiting accounting.

 

I would suggest to optimize both of your mysql and apache.

Thanks