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
