MySQL high load
-
I see queries like this which require a lot of time to be executed and during this time the CPU load is high and the blog not accessible. I am almost sure that these queries related to “related posts”. Any idea how to fix the problem?
| 11871 | user_blog | localhost | dentnews_blog | Query | 2 | Copying to tmp table | SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘??? ??? ??? |
| 11878 | user_blog | localhost | dentnews_blog | Query | 34 | Copying to tmp table | SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘??? ??? ??? |
| 11920 | user_blog | localhost | dentnews_blog | Query | 7 | Copying to tmp table | SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (‘??? ??? ??? |
- The topic ‘MySQL high load’ is closed to new replies.