I am looking for some experienced coder with MySQL and PHP knowledge to find and fix what is causing really high server load. Sometimes Load Averages go to: 15.07 15.46 ... This has been happening for last two weeks I an have no clue what is causing this. Dedicated server stats: Intel® Core™ i7-920 Quadcore RAM 8 GB DDR3 RAM ... I am prepared to pay up to 15USD to Paypal.
Can you give more information? Which distribution/version. What's running? How much traffic? What's in Mysql? Is load always high, or just occasional? What does 'top' say is causing the high load. I'm happy to take a look at if - PM me if you haven't already found someone to help out
It's running on WHM. Load is not always high but traffic is pretty much the same. About 170 visitors online, across all the sites. Here is screeenshot taken few minutes ago. You can see server load is currently fine, but might go insane anytime soon.
Try running "show status" in a mysql prompt when the server is experiencing both high and low load. Do you have awstats, or some other web traffic monitoring?
I have disabled awstats few days ago, because I thought of this as well. I tried to run show status via SSH, but command didn't work. I presume I would need to do it somewhere else. Anyhow, her is screen of sql processes. Thank you for helping me!
this isn't a Linux command, you need to type it into mysql. After you ssh to your box, type "mysql -p", you will be promoted for your password. Then you can type "show status;" This will give you a whole bunch of information regarding connections, queries, open tables, service uptime and loads more. For awstats, I was thinking taking a look at stats. I once had high load caused by mysql, which resulted in nagios (monitoring tool) raising an alert. After looking at awstats I saw that there were a couple of IPs with many hists on specific PHP pages. This resulted in the same queries being run which raised the load. Not sure if you've got the same problem, but it wouldn't hurt taking a look.
Thank you for guiding me, here is the output of show status: http://hidetxt.com/hidden/75063873.png Amrox, would you be interested in taking this 'job', since it seems you know a lot about this...
Go into the php.ini file and set the maximum execution time up from 30 seconds to something higher, as needed. It is also not a bad idea to double the RAM allowed per script to 16MB instead of 8MB.