Slow MySQL Querry : FROM wp_options WHERE option_name = 'rewrite_rules'

Discussion in 'Databases' started by Khaludi92, Sep 19, 2011.

  1. #1
    Hello guys,

    A couple of days ago I my server was running smooth and great, but all of a sudden the CPU reduced and the server was crashing badly so i asked the technical team and they asked me to check the logs

    I went through the logs that to see what has been putting extra load on my Server's CPU.

    There are many logs created everyday, And all the logs are commonly showing one problem

    
    # Mon Sep 19 17:15:23 2011
    # Query_time: 6.443493  Lock_time: 0.000073 Rows_sent: 0  Rows_examined: 1
    use footbas1_slsnet;
    DELETE FROM wp_options WHERE option_name = 'rewrite_rules'
    Code (markup):
    Query_time in every log is different.

    footbas1_slsnet is my database name

    This thing has caused my Server to be 75% slower at peak times.I asked the technical team of my hosting and they asked me to check the log. They are not providing me any more assistance with the solution of the problem, So i have to find the solution my self.

    I have been "Google"ing for days, but couldn't find a easily understandable solution

    Looking forward to some detailed help :)

    The database is being used on the URL on my footer. I am using wordpress.

    If there is any more information required please let me know :)
     
    Khaludi92, Sep 19, 2011 IP
  2. akumar2

    akumar2 Peon

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    delete query ;) its too high...
    try changing db engine from myislam to innodb ...
     
    akumar2, Sep 20, 2011 IP