Wordpress high cpu and sql usages?
 

Ok, how can I compensate for Wordpress basically killing our servers with high traffic?

I was looking into WP-Cache but it's not making much of a difference and still killing cpu.


Anyone have any ideas, tips or plugins to help? Anything would be very much appreciated.

What do you consider high traffic? I had a site survive a day on digg using wordpress and wp-cache. That was on a server with dual xeons and only 2GB of ram.

Well considering each of our sites does about 200-500 a day and we have tons of blogs, this one spiked to about 5k yesterday and it's killing the sql and cpu :(

WP consumes a lot of server resources, that's not a secret.

Well obviously I've got this figured out already...thanks for your worthless input.

5k a day shouldn't cause any trouble at all. Assuming this is a dedicated server that isn't overcrowded I would think that apache might need a little tweaking. If you were using wp-cache then mysql shouldn't be the cause of the problem.

We had the same problem. The solution we have come to is to write our own blog script. We explored other options and this was the best.

Also, are you sure wp-cache was working? Sometimes I have to enable/disable it a couple of times before I see the wp-cache comment tag at the bottom of the index page (it's just a comment in the HTML, it's not visible on the page itself). I always check for that comment to verify wp-cache is working.

post your Mysql version and http server.

I'd love to do this but simply do not have the time right now. :(

That's what I am thinking. 5k Isn't much of anything for traffic but it seems to be lagging the shit out of our server. Now, mind you - the server does have quite a few sites on it now and that can't be helping the situation. Right now, the cache *looks* to be working but the CPU is still high.

I'm pretty sure. I'm going to toy with it some more, the boss was messing with it last night trying to get it to work.





Server version: Apache/1.3.33 (Unix)
Server built: Feb 9 2005 19:43:59
mysql Ver 12.22 Distrib 4.0.20

:1orglaugh

Well I guess I figured out why my host is always bitching, I am running a ton of blogs on my server. I will keep an eye on this thread hopefully someone has a solution :thumbsup

Sound advice. Wordpress is poorly engineered.

I can't see any server hardware specs here.Perhaps it's some rusty IBM XT or something like that.

P.S. We have a way more intensive traffic our main WP blog - no problems so far.

Posting your server specs would have helped too... ie: if your server has 512MB of RAM, that may well be a bottleneck (I upgraded my main blog server last month because of that).

Are you talking about http://www.nubilesblog.com? :)

Trying to find out the CPU speed but we know it's running with 2gigs of ram

Why are you asking?
What are you planning to do?:(

Lace, pls icq me, i think i might be able to help.
5262689

I had the same problem on a virtual server :(

dedicated - smooth sailing with over 20 blogs and traffic...

Nothing at all. I curious why it says: <meta name="generator" content="WordPress 2.2.2" /> :)

you gave people 10 minutes to answer before you called them worthless.

you are an idiot.


~Ray

Yeah, and your response was that much more informative.

If people could learn to read, they would see that the reason I was originally posting this was because WP was taking up a ton of system resources - there's no need to repeat my original post. DUH

So save your breath, idiot.

a wordpress of a client on one of my virtual plans :

But the box is a dual Xeon 3.0 Ghz, 3 gigs ram, SCSI drives ...

With just 5000 views a day, you should not have a problem unless your box is way outdated.

.. and maybe post the info of a TOP command, to see the usage of ressources.:2 cents:

Ive been watching the top command now...dropped down to about 3.7-4 for the passed 30 mins

That is relatively high for such low traffic...

Here is my top on that box ( about 70 accounts on it ):

Lace: sorry don't have an answer for you, hope you won't mind a bump with a question :)

I was looking to build a network of about 20 WP blogs covering unsaturated topic hence likeliness of them becoming fairly busy is probably. Do you think I should explore a different avenue to avoid overkill of my server?

I'd do a max of say 10 per host...personally. Although I obviously don't know all I should, I wouldn't keep all my eggs in one basket.

Also be aware of what cron jobs are running and exactly how your plugins work before you install to make sure you're not going to overload your CPU & Memory.

Similar problem here... wasn't too big an issue when a 5K blog was the only thing on the box... Now it has about 100 sites doing anything from 300 to 5000 a day each and it is tanking my server.

I have had lesser servers with 150,000 hits a day to TGP's and nothing wrong.

Two words..

Blogs Organizer

edit: never mind, saw your responses to other people. you're a jerk who doesn't deserve help. go clean the sand out of your vagina to improve your attitude.

Lace...

I have a customer with this problem as well. Wordpress is just killing the CPU.
We had to move the database to a dedicated SQL server and leave http on another.
The SQL server is doing alright but the webserver is being killed with load.

For comparison:

WebServer Specs:

Xeon 3.4Ghz
4GB DDR RAM
73GB SCSI 10K


Database Server:

Core2Quad Q6600
2GB DDR2 RAM
250GB SATA2


he IS running wp-cache already and it IS working. While the database is handling the load, it still has rather high load.
http load is high on the webserver.
MySQL traffic between the web server and the db server does about 200Mbps. thats a lot of crappy sql traffic

Wordpress sux :(

So yeah, no real help on getting it solved other than upgrading the CPU on it, or spreading the load out as far as your budget will allow.
We've managed the lower the load a bit by doing some MySQL tweaks but load still sux

i guess it might also be very dependent plugin's you are running with Wordpress

i read an article once about a few lines of code you can change is choice places of the WP source that will really speed things up and lesson load. try a search on google for 'wordpress tuning' and the likes.

i forgot to mention that his site gets about 46,000 page views per day

he's looking at replacing wordpress with movabletype

From my experience this is a very important point! I ran into the same problems with my new Wordpress installation a few days ago. In the end it turned out to be a tiny little plugin that caused the problems. I killed as many plugins as possible and since then Wordpress is working fine for me even though I currently only use 1 GB of RAM and have a total of around 100,000 pageviews/day total on my site (not only Wordpress though but also static gallery pages).

Thanks for all of your help Tidal. I will look into this more next week but I think the server is a couple years to date and could use some updating. Also thinking about moving this site over to another box....Just got to figure out what all we have hosted on our 5+ different free site servers. :Oh crap

Yeah we've been talking about the plugins as well...as they could have a huge impact with server resources. We've been toying with everything we can think of and it's helped a little bit but I guess the main problem is having nearly 100 sites, alot of blogs and php going all at once doesn't help things out.

I agree with the statements about plugins.

Wordpress plugins on your server are the equivalent of shareware software on your PC....most of them are worthless and they fuck shit up.

Use as few plugins as possible and monitor your server load before and after you activate a plugin.
If one uses too much resource-wise, try to find another that does the same thing (there are usually several plugins out there for each task)

The biggest resource hogs for me were stat tracking programs, like firestats or stattraq. Killing them and just using server stats helped alot.

having some similar issues here also and this blog only has around 8k uniques daily. (no its not on a virtual lol)

looking for an alternative to wordpress :disgust

Tried to otpimize the server software (or upgrade hardware)....
Optimize MySQL and install some php caching, get rid of apache addons you're not using... and your loads will drop...
Hit me up for details if needed...

why don't you go with litehttpd? i found out apache with addons is too cpu consumpting.

People try to use wordpress to do basically EVERYTHING you can think of. If you're wanting to run something other than a BLOG use something else. The people who try to run adult video sites using it I can't help but laugh at them... Same with the image gallery's. If you're doing anything other than blogging use a DEDICATED system for it.

Currently the most powerfull youtube type video script is Social Media. My script is several releases behind them but at about 1/10th the price and I know for a fact that my system can handle traffic a LOT better than that system.

Everybody here is simply asking you about your server when the REAL question is what are you trying to do? If you only need a couple fish there's no point in using a 100ft long net ;)

or even better, Zend + lighthttpd + eAccelerator + wp-cache.

how about that? :)

sorry about typos, it's: http://www.lighttpd.net/