Mysql overloading the server

  • woolexs

    (@woolexs)


    16 years, 6 months ago

    Hello,

    my shared hosting said that I have the following bad query in the database:

    id select_type table type possible_keys key key_len ref
    rows Extra
    1 SIMPLE wp_posts ref type_status_date
    type_status_date 44 const,const 23211 Using where

    You will need to repair the query, or make sure that it is not scanning so many rows.

    This query causes the server to fail. it consumes 100% server cpu most of the time.

    Then I moved to a dedicated server and got this message when I upload my database from shared hosting:

    mysql failed @ Tue Sep 29 11:49:26 2009. A restart was attempted automagically.
    Service Check Method: [check command]

    Cmd Service Check Raw Output: mysql has failed

    Is there any possible ways that you guys can help me out with this problem? Or guide me to the right direction for expert helps…

    dylan

    My host cant help me on this matter. Please help me.

Viewing 5 replies - 1 through 5 (of 5 total)
  • polarfoxx

    (@polarfoxx)

    16 years, 6 months ago

    Did you modify any of the queries manually ?

    Thread Starter woolexs

    (@woolexs)

    16 years, 6 months ago

    Nope, everything was automatic from submitting posts, pages, comments from users.

    I did not modify any queries in the database.

    Here is the picture of my database information:

    http://i35.tinypic.com/10pafso.jpg

    polarfoxx

    (@polarfoxx)

    16 years, 6 months ago

    Did you maybe just upgrade the WP recently from an older version ?

    I think there was a vulnerability in a previous version that would allow creation of admin users and thus modification of the SQL queries for whatever purpose.

    Did you check the db for wp usernames you don’t recognize with phpmyadmin ?

    *EDIT* And it’d be nice to see the full SQL query your host claims to be going postal.

    *EDIT2* I did some quick google research and came up with a bug on MySQL and several other MySQL forks. Try googling for “id select_type table type possible_keys key key_len ref rows Extra”
    Check this out .. pretty much describes a bug in MySQL that causes the CPU load to go apesh*t because it scans the whole table all the time: http://bugs.mysql.com/bug.php?id=43371

    I didn’t go in-depth but try asking your Host what Php version they’re running, and if it’s pure MySQL or a fork.

    Thread Starter woolexs

    (@woolexs)

    16 years, 6 months ago

    @ polarfoxx

    This is from godaddy shared wordpress hosting account. I did not upgrade to the latest version of wordpress 2.84.

    I have been using version 2.71 for months already. Just last week, godaddy staff send me that bad query message.

    You can check my database info here:

    http://i35.tinypic.com/10pafso.jpg

    That’s all I know for now =\

    polarfoxx

    (@polarfoxx)

    16 years, 6 months ago

    Took a look at the screenshot and compared it with my wp database layout.

    Appears you have a gazillion plugins installed. I recommend disabling them one by one to see if one of them might cause the high load. IF your host is using an up-2-date MySQL version. I’d check that first.

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

The topic ‘Mysql overloading the server’ is closed to new replies.