Open classification list of articles under the very slow to see the mysql running, are similar to the following statement, takes up a lot of time and resources,

The statement is as follows:
Copying to TMP table | SELECT SQL_CALC_FOUND_ROWS wp_posts. ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. ID=wp_term_relationships. Object_id) WHERE 1=1 AND (
Wp_term_relationships. Term_taxonomy_id IN (749)
='post') AND wp_posts. Post_type AND (wp_posts. Post_status='publish') GROUP BY wp_posts. ID ORDER BY wp_posts. Post_date DESC LIMIT 0, 24 |

This seems to be under the retrieve a classification of the latest articles, but the execution time of up to 103 seconds , is the amount of data is too large, about 6 million articles, it is not so slow?
VPS configuration is not low, 6 nuclear 8 gb of memory, SSD,
Consult everybody!

CodePudding user response:

CodePudding user response:

Look at the execution plan
Explain the SELECT SQL_CALC_FOUND...