CPU hitting 90% when I add/update a page

  • This is a large wordpress setup with 5000 pages and 30k posts running on a media temple dv.

    When I add/update a page the cpu hits 90% and kills the site.

    Any suggestions?

Viewing 1 replies (of 1 total)
  • Thread Starter granulr

    (@granulr)

    Serious CPU/ timeout issues.

    wp_posts table
    total records
    +———-+
    | count(*) |
    +———-+
    | 36395 |
    +———-+

    wp_posts table
    total pages:
    +———-+
    | count(*) |
    +———-+
    | 6602 |
    +———-+

    wp_posts table
    total posts:
    +———-+
    | count(*) |
    +———-+
    | 29620 |
    +———-+

    Approx. 6000 of the total records were inserted directly into the database
    from CSV files so we could bypass entering those records manually.
    Data inserts went into the following tables:

    wp_posts
    wp_postmeta
    wp_term_relationships

    From wp-admin when clicking either pages or posts the CPU kicks into 90% +
    range and the MySQL logs show a loop is taking place and running thousands
    of queries before apache finally timesout.

    Prior to the CSV inserts word press was working fine.

    Below is a snippet of the MySQL logs.

    Does anyone have a clue as to what is going on??

    Any insight will be greatly helpful.

    Thanks

    ********************************************************************************
    The sql log below begins at line 146 of the log file and continues onto
    line 18044 before apache timed out.

    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘page’
    100112 18:45:49 18 Query SELECT * FROM wp_posts WHERE ID = 37340 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 37340
    18 Query SELECT * FROM wp_posts WHERE ID = 37338 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 37338
    18 Query SELECT * FROM wp_posts WHERE ID = 37272 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 37272
    18 Query SELECT * FROM wp_posts WHERE ID = 37175 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 37175
    18 Query SELECT * FROM wp_posts WHERE ID = 37131 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 37131
    18 Query SELECT * FROM wp_posts WHERE ID = 36887 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 36887
    18 Query SELECT * FROM wp_posts WHERE ID = 36706 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 36706
    18 Query SELECT * FROM wp_posts WHERE ID = 36450 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 36450
    18 Query SELECT * FROM wp_posts WHERE ID = 36237 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 36237
    18 Query SELECT * FROM wp_posts WHERE ID = 36235 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 36235
    18 Query SELECT * FROM wp_posts WHERE ID = 36073 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 36073
    18 Query SELECT * FROM wp_posts WHERE ID = 35892 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 35892
    18 Query SELECT * FROM wp_posts WHERE ID = 35837 LIMIT 1
    18 Query SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = 35837

Viewing 1 replies (of 1 total)
  • The topic ‘CPU hitting 90% when I add/update a page’ is closed to new replies.