Multisite installation placing huge load on MySQL

  • Hi WPMS community:

    I’m running a website for a local publication that experiences a fair number of hits — roughly 2-3000 a day. We transitioned from a different CMS last summer to WordPress (or, to be precise, WPMU and then upgrading to WP 3.0 when it came out).

    It’s been great working with WordPress. Thankfully, everything seems to be working. However, we recently started to experience dramatic slowdowns and extremely long load times for pages on our site. Running top on ssh show mysqld consistently using 95% or greater resources. We have WP-Supercache enabled and it appears to be working.

    Our posts database contains roughly 11,000 articles and a further 7-8,000 entries for photo information and pages. Right now we are only running this single site, but once this load issue is resolved we plan to have smaller daughter-sites running, hence multisite.

    So, I’m trying to trace the high mysql usage. Any ideas?

Viewing 4 replies - 1 through 4 (of 4 total)

  • Start reading logs. ??

    Clarification: you;re only running ONE blog?

    Also, you have a load of hits. Confirm the caching is actually working. Consider eaccelerator, optimize the database.

    How much RAM do you have?

    I’m having the same problem but aside from the main blog, I’m running around 15 blogs under the same installation. We have around 15k hits and 20 new posts per day. I already optimized the theme, running wp total cache and nothing seems to be working. I’m on Dreamhost PS with 800MB of RAM and they just told me they increased temporarily to 1000MB but they would like me to optimize more and I don’t know what else to do.

    I wonder if I took the 15 blogs out everything would be better.

    15 K hits a day? Yeah, you definitely need a dedicated box where you can tweak things, with more than 1 gig of RAM. you may need to do some more caching, some server-side tweaks (eacclerator for instance) and start looking at some plugins & things. There *could* be something ramping that up, hard to say.

    I just read about eAccelerator and I will give it a try this weekend. Hopefully this will help.

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Multisite installation placing huge load on MySQL’ is closed to new replies.