Throttle issue because of script problem

Hello, my hosting company said that they are throttling my account (making it really slow) because there is a script that is using a lot of resources. The hosting company does not offer assistance with scripting issues. Any idea which plugin can be creating it from the following....The tmp>mysql_slow_queries log shows:

# Query_time: 2.161687 Lock_time: 0.808914 Rows_sent: 23 Rows_examined: 46
use database_wrd3;
SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY wp_posts.post_title ASC

# Query_time: 2.898903 Lock_time: 0.001571 Rows_sent: 13 Rows_examined: 13
use database_wrd2;
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 20

# Query_time: 2.015536 Lock_time: 0.480902 Rows_sent: 381 Rows_examined: 442
use database_wrd2;
SELECT option_name, option_value FROM wp_6_options WHERE autoload = 'yes'

# Query_time: 4.102446 Lock_time: 0.001591 Rows_sent: 461 Rows_examined: 547
use database_wrd2;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'

# Query_time: 5.195694 Lock_time: 0.000223 Rows_sent: 1 Rows_examined: 1
use database_wrd2;
SELECT option_value FROM wp_67_options WHERE option_name = 'wp_67_user_roles' LIMIT 1

  • Timothy Bowers

    Hey Atlanta.

    To break this down for you:

    SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY wp_posts.post_title ASC

    This is selecting everything that is a page and is also published. Thats coming from the wp_posts table.

    Could be ya theme maybe? Or a filter searching for all which is published? Maybe a menu?

    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 20

    Look for all posts (blogs) and limiting it to 10. Could be the theme again.

    SELECT option_name, option_value FROM wp_6_options WHERE autoload = 'yes'

    Thats getting your sites options where autoload is set to yes.

    SELECT option_value FROM wp_67_options WHERE option_name = 'wp_67_user_roles' LIMIT 1

    Same again getting info from the option table.

    Nothing really looks all that odd to me.

    Shared hosts are often like this. WordPress when using to many themes and plugins can become a real resource hog as well. Also with few plugins and users issues can crop up depending on the host.

    Take care.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.