TAJon

Thank you for getting back to me.

I performed your recommendations and configured my my.cnf file as per MySQL Tuner recommendations. However, the problem is still happening so I activated the Slow Query Log.

I found the following results:

# Time: 121226 17:14:26
# User@Host: true_wp1[true_wp1] @ localhost []
# Query_time: 56.503083 Lock_time: 0.000188 Rows_sent: 5 Rows_examined: 23349642
use true_wp1;
SET timestamp=1356567266;
SELECT SQL_CALC_FOUND_ROWS yczrytsxi_posts.ID FROM yczrytsxi_posts INNER JOIN yczrytsxi_postmeta ON (yczrytsxi_posts.ID = yczrytsxi_postmeta.post_id)
INNER JOIN yczrytsxi_postmeta AS mt1 ON (yczrytsxi_posts.ID = mt1.post_id)
INNER JOIN yczrytsxi_postmeta AS mt2 ON (yczrytsxi_posts.ID = mt2.post_id) WHERE 1=1 AND yczrytsxi_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘gab_gallery’) AND (yczrytsxi_posts.post_status = ‘publish’) AND (yczrytsxi_postmeta.meta_key = ‘iframe’
OR mt1.meta_key = ‘video’
OR mt2.meta_key = ‘videoflv’ ) GROUP BY yczrytsxi_posts.ID ORDER BY yczrytsxi_posts.post_date DESC LIMIT 0, 5;

I installed the Debug Queries Plugin which indicates that this query is called from:

Call from: require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/linepress/home.php’), include(‘/themes/linepress/home-primary-bottom.php’), WP_Query->query, WP_Query->get_posts

As I mentioned before I am not a MySQL or WordPress Code expert but it looks like it is my “Theme” making this query which is causing the issue.

I’ve also noticed that it is also only when on the “Home” page where this query is called but not on any other page (As far as I could see)

I am not sure why it is making this query and I am hoping someone can point me in the right direction. Is there a way to improve this query or should I submit a ticket with the people that developed the theme?