host suspended site for slow queries

  • Hi our host has suspended a site I work on because a query is impacting the performance of the sql server the query is listed as

    SELECT option_name, option_value FROM wph2_options WHERE autoload = 'yes' | 0.000 |

    Can any one explain in laymens terms what this means and what i might do to relieve this issue

    thanks

    • This topic was modified 2 years, 4 months ago by stevebrett.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    That’s a pretty straightforward query and the autoload field should be indexed, so just as a matter of interest, can you go into PHPMYADMIN, click on the wph2_options table, click on the SQL tab, and type in

    EXPLAIN SELECT option_name, option_value FROM wph2_options WHERE autoload = 'yes';

    How many rows does it return? How many rows are in the wph2_options table, in total?

    Thread Starter stevebrett

    (@stevebrett)

    thanks, the query returns 5391 and there are 5609 total rows

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    That’s a big number of autoloads, but not absurd. Are you on some sort of limited hosting plan?

    You might try to optimize that table via PHPMYADMIN.

    Thread Starter stevebrett

    (@stevebrett)

    Thanks Steve yes the site is on a shared hosting plan- i optimized the table (thanks for that) and the query now returns a bigger number 5460

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Now you need to ask your host if things are OK, and, if not, get specific info on the problem .

    Thread Starter stevebrett

    (@stevebrett)

    Thanks again for your help here- host has unsuspended us…

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘host suspended site for slow queries’ is closed to new replies.