WordPress.org

Forums

CPU hitting 90% when I add/update a page (2 posts)

  1. granulr
    Member
    Posted 5 years ago #

    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?

  2. granulr
    Member
    Posted 5 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.