WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] WordPress hammering MySQL server (7 posts)

  1. earcos
    Member
    Posted 8 years 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.

  2. ifelse
    Member
    Posted 8 years ago #

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

  3. Denis de Bernardy
    Member
    Posted 8 years ago #

    mine comes with caching built-in:

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

  4. Lorelle
    Member
    Posted 8 years ago #

  5. davidchait
    Member
    Posted 8 years 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

  6. angsuman
    Member
    Posted 8 years ago #

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

  7. earcos
    Member
    Posted 8 years 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!

Topic Closed

This topic has been closed to new replies.

About this Topic