WordPress hammering MySQL server

  • Resolved earcos

    (@earcos)


    18 years, 9 months ago

    Hello. I have a popular weblog powered by WordPress. It’s popularity has been increasing in the lastest months (more than 8,000+ unique users a day for example) and it is serverely hammering the server and afecting other clients on the same machine.

    I’ve been doing a lot of MySQL optimization, activating caches (eaccelerator) and WP-Cache 2.0 and I forward all my RSS subscribers to Feedburner. Still the load is high. I disabled some scripts with not much effect. These are the ones I have installed:

    – bdp-rss-aggregator
    – Brian Lastest Comments
    – Cat 2 tag improveed
    – CJD Nuke Spam
    – Search Hilite
    – Gravatar
    – Image Browser
    – Markdown / Smartypants
    – MW Next/Previous
    – sSend2Friend
    – Subscribe to comments
    – Weighted Categories
    – MT Underlined URLs Fix 2

    Hope someone can help me or give me pointers on this. Thanks a lot 🙂

    Edit: I recently optimized tables on the wp database.

Viewing 6 replies - 1 through 6 (of 6 total)
  • ifelse

    (@ifelse)

    18 years, 9 months ago

    “- brian latest comments”
    Try disabling this plugin. This plugin appears to be responsible for quite a few server hammerings.

    Denis de Bernardy

    (@denis-de-bernardy)

    18 years, 9 months ago

    mine comes with caching built-in:

    http://www.semiologic.com/projects/recent-comments/

    Lorelle

    (@lorelle)

    18 years, 9 months ago

    And try this plugin:

    http://dev.wp-plugins.org/wiki/WP-Cache

    davidchait

    (@davidchait)

    18 years, 9 months ago

    Ummm, if you have WP-Cache installed, you should be seeing near-zero queries (I mean, you might see an initial query per user, but otherwise normal pageviews are static stuff).

    If you don’t provide a site link, we can’t see what things actually look like…

    Also, what dynamic stuff have you coded up to ‘cut through’ WP Cache caching? if anything… if nothing, again, pages should be generally ‘static’, not causing DB queries.

    Are people posting a lot of comments per day? That can cause Cache to get flushed (at least for that post).

    -d

    angsuman

    (@angsuman)

    18 years, 9 months ago

    Wp-cache 2 really helped in my blog. It is better than eaccelerator as it is context-aware.

    Thread Starter earcos

    (@earcos)

    18 years, 9 months ago

    Update:

    Disabling the “brian latest comments” plugin made a HUGE difference, thanks a lot ifelse. I’ve been using WP-Cache almost 3 months, excellent plugin.

    I’ll try the “recent comment” plugin from Denis-de-Bernardy, and I’ll let you all know. Thanks a lot for your help!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WordPress hammering MySQL server’ is closed to new replies.