New to the community? Start here

One user crashing MySQL?

Hi –

I have one user whose posts are crashing mySQL. This is happening on a shared hosting environment, and MySQL stops working for every other site as well. I have also noticed that when people read some posts or comment on some of her posts, MySQL crashes too! It doesn’t exactly crash. The processes are running, but nobody can use it. I have to kill MySQL and start it back up again.

When I look in the mysql logs, it’s always her editing or posting just before the trouble begins!

We’re on version WPMU 2.7.

Wed, 18 Feb 2009 21:00:43
  • drmike
    • DEV MAN’s Mascot

    Five bucks says the content is a copy and paste out of Word and Word has added in hundreds of unnecessary lines that are nothing but opening and closing span font tags.

    You can’t provide a link to the post, can you? Gotta admit that I’m curious as well.

  • andrea_r
    • The Incredible Code Injector

    Is she writing a lot of pages or editing them a lot? We recently discovered an issue where as many as 11 rewrite rules are added to pages with attachments. This adds far to much overhead on some setups (or, well, at all) and can easily run up MySQL.

    You may also want to tweak your revisions. If shes a heavy editor, that’ll do it, or if she uses a lot of custom fields.

    Yes, pasting from Word does all kinds of fun stuff, but it mostly messes up the layout – not drive the server nuts. I;ve got a setup where I have a lot of Word-pasters. :smiley:

  • uncobeth
    • WPMU DEV Initiate

    Yes, as a matter of fact, her posts are all done in Word first. Then she copies and pastes. I’ve asked her not to do that from now on.

    It’s http://margaret.healthblogs.org/

    I’m looking at the log from when it crashed again a few minutes ago, and there were other queries being run this time. Nothing to do with her blog

    I wonder if MySQL just needs to be tuned (and I’m SO not someone who could do that)?

    Here’s some server info:

    CPU0: Intel(R) Pentium(R) 4 CPU 2.40GHz stepping 09

    CPU1: Intel(R) Pentium(R) 4 CPU 2.40GHz stepping 09

    free

    total used free shared buffers cached

    Mem: 3895232 1756972 2138260 0 210284 1264116

    -/+ buffers/cache: 282572 3612660

    Swap: 524280 0 524280

    15% of a 300 gig drive in use.

  • Ovidiu
    • Code Wrangler

    @andrea:

    only partially related, but as you mentioned revisions I jsut wodnered if these codes inside wp-config.php can be applied to wpmu too? I know they work with wp.

    /** disable Revisions */
    
define('WP_POST_REVISIONS',false);
    

    
/** extend the Autosave timing */
    
define('AUTOSAVE_INTERVAL',300);