What, exactly did you guys do to "fix" this? Was it just indexing the taxonomy table?
I'm getting killed right now on http://www.bluehost.com. CPU exceeded errors and SQL queries in the 100+ CPU seconds range.
MySQL Slow query problem (32 posts)
-
powderboy
Posted 3 years ago # -
rwl4
Posted 3 years ago #I am having this exact problem right now. Any help would be MUCH appreciated.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('3', '74', '11', '7', '8', '9', '10', '14', '4', '5', '80', '69', '15', '13', '12', '77', '78', '76', '75', '79', '43', '44', '42', '41', '91', '51', '52', '50', '49', '92', '55', '56', '54', '53', '93', '59', '60', '58', '57', '94', '63', '64', '62', '61', '95', '25', '28', '26', '24', '86', '18', '19', '17', '16', '96', '21', '23', '22', '20', '97', '83', '84', '82', '81', '85', '72', '73', '71', '70', '87', '36', '35', '34', '33', '89', '31', '32', '30', '29', '88', '39', '40', '38', '37', '90') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') LIMIT 0, 4;
We have been in the process of moving a site with 40k posts from custom software to WordPress and this is really causing a problem.
Topic Closed
This topic has been closed to new replies.
