A lot of Slow MySql queries

  • # Tue Mar  8 13:01:59 2011
# Query_time: 1.354127  Lock_time: 0.000154 Rows_sent: 41  Rows_examined: 41
use wrd4;
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4935,4617,4532,4484,4407,4336,4305,4223,4071,3620)

    seeing a lot of this type of queries on my log. but dont know what is causing this.
    facing more than 23 hours of cpu throttling due to these slow queries.
    any body know what is this? how to resolve this problem?

    thanks in advance.

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

  • Have you tried:

    – deactivating all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – switching to the Twenty Ten theme to rule out any theme-specific problems.

    Thread Starter aftab1003

    (@aftab1003)

    hi Esmi

    thanks for your reply.

    i tried all things like… disable all plugins, default theme, block all traffic through htaccess etc. but no clue.

    then i tried to clean wp option table with plugin…. and the cpu coooooooooool down… but only for few hours. and today, again throttling is on 65000 sec.

    these are the top 3 pages loaded, i checked via awstat...
/	hits=120169	17.26 KB
/2011/03/	2745	15.16 KB
/wp-cron.php	1967	277 Bytes

    any guide?

    again slow queries for today…

    # Thu Mar 10 01:57:07 2011
# Query_time: 2.494964  Lock_time: 1.474245 Rows_sent: 214  Rows_examined: 246
use *****_pricespk;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'

# Thu Mar 10 01:57:19 2011
# Query_time: 2.754424  Lock_time: 0.247515 Rows_sent: 1  Rows_examined: 2
use *****_pricespk;
SELECT * FROM wp_comments  WHERE comment_approved = '1' AND comment_post_ID = 191 ORDER BY comment_date_gmt ASC
# Thu Mar 10 01:55:27 2011
# Query_time: 4.934643  Lock_time: 2.004149 Rows_sent: 0  Rows_examined: 233
use *****_prwp;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND (((wp_posts.post_title LIKE '%PakistaniNudegirls%') OR (wp_posts.post_content LIKE '%PakistaniNudegirls%')))  AND (wp_posts.post_password = '')  AND wp_posts.post_type IN ('post', 'page', 'attachment') AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 10
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘A lot of Slow MySql queries’ is closed to new replies.