Load too high.

Portal Home > Knowledgebase > Articles Database > Load too high.

Posted by chupaqueedeuva, 10-23-2010, 08:08 PM
Hello everybody my current server for the past two days, helped increase the load by 200%. I come here asking for help to locate what might be the cause. Currently I use the following settings. i7 920 + 12GB DDR3 + HD 300GB + 1gbit Apache+Nginx+Cpanel Image load: http://i56.tinypic.com/28at7v7.png I thank you to everyone who can help.
Posted by gamepro127, 10-23-2010, 08:10 PM
Looks like MySQL is killing your server. What kind of sites are you hosting?
Posted by chupaqueedeuva, 10-23-2010, 08:17 PM
7 Blog Wordpress
Posted by lostmind, 10-23-2010, 08:22 PM
Do you use: http://wordpress.org/extend/plugins/w3-total-cache/ or http://wordpress.org/extend/plugins/hyper-cache/ If not, you should give them a try.
Posted by gamepro127, 10-23-2010, 08:26 PM
Your server shouldn't suffer from just 7 wordpress blogs, unless they're very, very popular wordpress blogs.
Posted by chupaqueedeuva, 10-23-2010, 08:33 PM
3 Blogs 5K day 2 Blogs 10K day 1 Blog 17k day 1 Blog 70k day All blogs use caching plugin (already tested both (hyper and w3) Image MysqlTunner: http://i54.tinypic.com/16llmk5.png
Posted by inspiron, 10-23-2010, 08:33 PM
Well, I think optimizing the mysql might solve the problem.
Posted by chupaqueedeuva, 10-23-2010, 08:48 PM
Could you help me now use the following settings. nano /etc/my.cnf
Posted by max_, 10-24-2010, 03:07 AM
You could also try disabling plug-ins one by one starting from cache. Some WP plug-ins and themes are known to cause high CPU loads. Complex permalink structures could cause problems too. This article has some good info: http://www.cravingtech.com/reduce-wo...eral-tips.html
Posted by Zahnzi, 10-24-2010, 03:21 AM
On screen you posted you are using 787.5% of 800% CPU usage. First you should optimize your MySQL and your WP because your server simply cannot handle 10 requests at same time
Posted by Johnburk, 10-24-2010, 10:50 AM
I also have 2 servers running wordpress sites and wordpress is really a load problem maker. Specially when using plugins. you are now only having 81 connections, 500 is not needed Also add a cron for Why do you need a 24G swap file? Also if you have themes that use timthumb or simular php resizing tools, that is also going to cause cpu load. Last edited by Johnburk; 10-24-2010 at 10:59 AM.
Posted by chupaqueedeuva, 10-24-2010, 11:30 AM
personnel is happening now something very strange. my clients are editing your files, but they are not updating.
Posted by Echizen, 10-24-2010, 11:37 AM
Do you use AGC (auto generated content) plugin? I recommend you to install w3c total cache, and then enable page cache, database cache, object cache on the plugin setting page and then see it is make some change to your cpu loads Last edited by Echizen; 10-24-2010 at 11:42 AM.
Posted by chupaqueedeuva, 10-24-2010, 11:44 AM
I've tested all of the Cache plugins you can imagine, I'm currently using w3 total cache. but even with disabled cache files are not being updated.
Posted by mellow-h, 10-24-2010, 08:14 PM
Query cache can massively improve your server performance. You are wasting a lot of CPU resources by not using Query cache on such a busy server.
Posted by akasharya, 10-25-2010, 12:45 AM
download and run mysqltuner.pl script on your server, it will suggest if anything value need to be changed.
Posted by GGWH-James, 10-25-2010, 01:21 AM
139MB free of 12GB and a 24GB swap? Last edited by GGWH-James; 10-25-2010 at 01:24 AM.
Posted by Johnburk, 10-25-2010, 03:44 AM
I have not idea what you are talking about. Did you run the optimizer, edit the my.cnf and restart mysql?
Posted by speckl, 10-25-2010, 09:25 AM
What type of php optimization are you running? ie memcache, apc...
Posted by chupaqueedeuva, 10-25-2010, 09:53 AM
I contacted a firm of management 'assistantz' and advises that the same problem and with a database domain which causes high load. Then deleted the db, and yet continued high load.
Posted by Johnburk, 10-25-2010, 09:58 AM
So to fix the problem they deleted the db!!!! Did you actually apply any of the advise WHT users gave?
Posted by drspliff, 10-25-2010, 10:53 AM
BWAHAHAHA. I'd love to hear more about this, it seems utterly incompetent, but there must be more to it.
Posted by chupaqueedeuva, 10-25-2010, 06:17 PM
I did everything that was said. however, that nothing worked, then deleted the db. but it still does not change anything, it will be any problem domain?
Posted by drspliff, 10-26-2010, 04:35 PM
Did you think of using a profiler like Xdebug to find out where your app-side hotspots are? Or to turn on query logging and see which queries are actually causing the load?