I've been frantically working with my host to help resolve this issue I've been having. My hosted is continually overloading. The support claims this is the main query causing the issue:
I've disabled all plugins.
Here's some problematic queries...
| 521 | jav1317103072546 | localhost | jav1317103072546 | Query | 17 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 525 | jav1317103072546 | localhost | jav1317103072546 | Query | 16 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 532 | jav1317103072546 | localhost | jav1317103072546 | Query | 13 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 536 | jav1317103072546 | localhost | jav1317103072546 | Query | 12 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 538 | jav1317103072546 | localhost | jav1317103072546 | Query | 11 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 541 | jav1317103072546 | localhost | jav1317103072546 | Query | 11 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
Seems post meta table has this many rows:
106,915
the whole site goes down sending mysql into a spin/cpu peak.Please help !:facepalm: .Wordpress version 3.9.1, Theme : keremiyaV4
__________________
Added after 14 Hours 45 minutes:
please let know, if someone needs more information to help me
I've disabled all plugins.
Here's some problematic queries...
| 521 | jav1317103072546 | localhost | jav1317103072546 | Query | 17 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 525 | jav1317103072546 | localhost | jav1317103072546 | Query | 16 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 532 | jav1317103072546 | localhost | jav1317103072546 | Query | 13 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 536 | jav1317103072546 | localhost | jav1317103072546 | Query | 12 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 538 | jav1317103072546 | localhost | jav1317103072546 | Query | 11 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 541 | jav1317103072546 | localhost | jav1317103072546 | Query | 11 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
Seems post meta table has this many rows:
106,915
the whole site goes down sending mysql into a spin/cpu peak.Please help !:facepalm: .Wordpress version 3.9.1, Theme : keremiyaV4
__________________
Added after 14 Hours 45 minutes:
please let know, if someone needs more information to help me
Last edited: