WordPress.org

Forums

lots of wp queries right before mysql crashes (1 post)

  1. bennett
    Member
    Posted 8 years ago #

    My peacefire.org website started crashing a lot recently so I added a script that checked every minute to record the list of running processes and the list of running mysql queries, to see later what was running right before the crash.

    After the latest crash, the output of "show processlist" right before the crash, was as below. The peacefire.org wordpress blog is displayed in a sidebar on the front page and it looks like wp queries are overloading the site somehow. Any idea why it only happens on some days and not others (I am not aware that we're being slashdotted or anything on the days that it dies), and how to fix it?

    Id User Host db Command Time State Info
    2706 root localhost peacefire Sleep 125 NULL
    7089 root localhost peacefire Sleep 27 NULL
    7147 root localhost pf_wordpress Sleep 886 NULL
    7179 root localhost pf_wordpress Sleep 954 NULL
    7326 root localhost pf_wordpress Query 8 closing tables SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN(10,9,8) ORDER BY post_id, met
    7327 root localhost pf_wordpress Query 8 preparing SELECT * FROM wp_users WHERE ID = '1' LIMIT 1
    7328 root localhost pf_wordpress Sleep 20 NULL
    7329 root localhost pf_wordpress Query 9 Opening tables SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-11-14 13:55:59' AND (post_sta
    7330 root localhost pf_wordpress Query 9 closing tables SELECT post_id, category_id FROM wp_post2cat WHERE post_id IN (10,9,8)
    7331 root localhost pf_wordpress Query 9 closing tables SELECT post_id, category_id FROM wp_post2cat WHERE post_id IN (10,9,8,7,6,5,4,3)
    7332 root localhost pf_wordpress Query 9 closing tables SELECT option_value FROM wp_options WHERE option_name = 'rewrite_rules' LIMIT 1
    7333 root localhost pf_wordpress Sleep 20 NULL
    7334 root localhost pf_wordpress Sleep 20 NULL
    7335 root localhost pf_wordpress Query 9 Opening tables SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-11-14 13:55:59' AND (post_sta
    7336 root localhost pf_wordpress Query 9 closing tables SELECT option_value FROM wp_options WHERE option_name = 'rewrite_rules' LIMIT 1
    7337 root localhost pf_wordpress Sleep 25 NULL
    7338 root localhost pf_wordpress Sleep 20 NULL
    7339 root localhost pf_wordpress Query 6 Creating tmp table SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-11-14 13:56:59' AND (post_sta
    7340 root localhost pf_wordpress Query 9 closing tables SELECT option_value FROM wp_options WHERE option_name = 'rewrite_rules' LIMIT 1
    7341 root localhost pf_wordpress Query 25 NULL NULL
    7342 root localhost pf_wordpress Query 6 closing tables SELECT option_value FROM wp_options WHERE option_name = 'rewrite_rules' LIMIT 1
    7343 root localhost pf_wordpress Query 9 Creating tmp table SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-11-14 13:55:59' AND (post_sta
    7344 root localhost pf_wordpress Sleep 20 NULL
    7345 root localhost pf_wordpress Query 9 Creating tmp table SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-11-14 13:55:59' AND (post_sta
    7346 root localhost pf_wordpress Sleep 25 NULL
    7347 root localhost pf_wordpress Sleep 20 NULL
    7348 root localhost pf_wordpress Sleep 25 NULL
    7349 root localhost pf_wordpress Query 6 preparing SELECT option_value FROM wp_options WHERE option_name = 'rewrite_rules' LIMIT 1
    7350 root localhost pf_wordpress Query 6 Opening tables SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
    7351 root localhost pf_wordpress Sleep 27 NULL
    7352 root localhost pf_wordpress Query 9 Sending data SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
    7353 root localhost pf_wordpress Query 32 NULL NULL
    7354 root localhost pf_wordpress Sleep 20 NULL
    7355 root localhost pf_wordpress Query 9 Sending data SELECT option_value FROM wp_options WHERE option_name = 'siteurl'
    7356 root localhost pf_wordpress Sleep 20 NULL
    7357 root localhost pf_wordpress Sleep 20 NULL
    7358 root localhost pf_wordpress Sleep 20 NULL
    7359 root localhost pf_wordpress Sleep 20 NULL
    7360 root localhost pf_wordpress Query 9 statistics SELECT option_value FROM wp_options WHERE option_name = 'siteurl'
    7361 root localhost pf_wordpress Query 9 statistics SELECT option_value FROM wp_options WHERE option_name = 'siteurl'
    7362 root localhost pf_wordpress Query 9 statistics SELECT option_value FROM wp_options WHERE option_name = 'siteurl'
    7363 root localhost pf_wordpress Query 4 Opening tables SELECT option_value FROM wp_options WHERE option_name = 'siteurl'
    7364 root localhost pf_wordpress Sleep 5 NULL
    7365 root localhost pf_wordpress Sleep 5 NULL
    7366 root localhost peacefire Sleep 8 NULL
    7367 root localhost peacefire Query 5 NULL show processlist
    7368 root localhost NULL Sleep 4 NULL
    7369 unauthenticated user localhost NULL Connect NULL Reading from net NULL
    7370 unauthenticated user localhost NULL Connect NULL Reading from net NULL
    7371 unauthenticated user localhost NULL Connect NULL Reading from net NULL
    7372 unauthenticated user localhost NULL Connect NULL Reading from net NULL
    7373 unauthenticated user localhost NULL Connect NULL Reading from net NULL
    7374 unauthenticated user localhost NULL Connect NULL login NULL

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags