Sunchaser

Registered
Nov 30, 2012
1
0
1
cPanel Access Level
Website Owner
Hello, i have the server that in the last days is often loaded. I have always the same traffic and i didn't release any new software.

The load increased from 0.5 to 5 or 6. The application is written in php and mysql. How can i know what is the problem, for instance how do i know if i do need to tune mysql or there is another problem?

thanks
 

MilesWeb

Well-Known Member
PartnerNOC
May 23, 2012
173
2
68
India
cPanel Access Level
Root Administrator
Twitter
You will have to analyze the usage on the server with basic commands like below. These will help you in basic troubleshooting. From here you can start in the right direction.

top -d2
watch mysqladmin pr
ps auxfg
 

24x7server

Well-Known Member
Apr 17, 2013
1,911
96
78
India
cPanel Access Level
Root Administrator
Twitter
Hello,

For the MySQL you will have to monitor your mysqlprocess through SSH

Code:
watch mysqladmin pr
Also Try to run MySQLTuner script on your server and update your my.cnf file.