WordPress.org

1. kraciboy
   Member
   Posted 1 year ago #

   Hello,

   We're working with the latest version of WordPress (3.1) and our database got almost 23k of post. When we make a new post on my WordPress site still can't save anything because the server is overloaded, i deceide to use mysql-slow.log to see what happen and know what queries is overloading my site. Here you can see one of the slow-querie in my site (this is one line, but all lines are equal except the ID's)

   # Time: 110314 22:26:58
   # User@Host: user[user] @ localhost []
   # Query_time: 7  Lock_time: 0  Rows_sent: 5  Rows_examined: 154948
   SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND wp_posts.ID NOT IN (308327) AND ( wp_term_relationships.term_taxonomy_id IN (1,8,22,59) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 5;

   Anyone know how to fix this problem? i followed this http://core.trac.wordpress.org/ticket/10964 but we lost pagination and the problem persist, nothing happen, i think maybe does not work on WordPress 3.1

   Thank you
   Greetings!

2. user65
   Member
   Posted 1 year ago #

   I am having the EXACT same issue! Come one wordpress, fix the REAL issues.

   This problem has to do with the post date, something happened and is causing the tmp table to max out when it shouldn't have to.

   not sure if the trac file helped, but I found that my editors can work with posts in the dashboard if I turn on Maintenance Mode. It's a plugin that puts a splash on the front end.

   my post with the exact same issue:
   http://wordpress.org/support/topic/database-maxing-cpu-usage-after-upgrade-to-31

3. fudj
   Member
   Posted 1 year ago #

   check out my post on to see if it helps?

   http://wordpress.org/support/topic/database-maxing-cpu-usage-after-upgrade-to-31?replies=15#post-2082125

Topic Closed

This topic has been closed to new replies.