MySQL goes insane after moderating comments

  • Klark

    (@d_kc)


    15 years, 9 months ago

    I get an average 50 new comments every hour during the day. When my users go to moderate, it drives MySQL usage all the up to 150% and it stays there indefinitely until I restart mysqld & httpd. Server load climbs to as high as 60 and the whole website goes bye-bye.

    I’ve disabled all comment related plugins that didn’t help. Then went on to disable all other plugins except WP Super Cache. That didn’t help either. I can’t disable the cache because my site can’t survive without it.

    Anybody experience this?

Viewing 1 replies (of 1 total)
  • Thread Starter Klark

    (@d_kc)

    15 years, 9 months ago

    Also got an alert from my server:

    Drive Critical: /dev/sda6 (/tmp) is 92% full

    related ?

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL goes insane after moderating comments’ is closed to new replies.