Database maxing : Physical Memory Usage 511 / 512 MB

[kdaica]

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