Wordpress taking too much load

Any one faced any issues with wordpress?. It is creating lot of load issue in the server. I searched the wordpress support and no one has found any solutions yet. Its the recent comments section which is creating the issue. The following are the details about this



| 196 | Query | 2
| Copying to tmp table | SELECT cat_ID, cat_name, category_nicename,
category_description,
COUNT(wp_post2cat.post_id) AS cat_count
FROM wp_categories
INNER JOIN wp_post2cat ON (cat_ID = category_id)
INNER JOIN wp_posts ON (ID = post_id)
WHERE post_status = 'publish'
AND post_date_gmt < '2005-03-18 20:48:04' AND cat_ID <>
1
GROUP BY category_id |
| 197 | Query | 1
| Copying to tmp table | SELECT cat_ID, cat_name, category_nicename,
category_description,
COUNT(wp_post2cat.post_id) AS cat_count
FROM wp_categories
INNER JOIN wp_post2cat ON (cat_ID = category_id)
INNER JOIN wp_posts ON (ID = post_id)
WHERE post_status = 'publish'
AND post_date_gmt < '2005-03-18 20:48:05' AND cat_ID <> 1
GROUP BY category_id |
| 198 | Query | 2
| Copying to tmp table | SELECT cat_ID, cat_name, category_nicename,
category_description,
COUNT(wp_post2cat.post_id) AS cat_count
FROM wp_categories
INNER JOIN wp_post2cat ON (cat_ID = category_id)
INNER JOIN wp_posts ON (ID = post_id)
WHERE post_status = 'publish'
AND post_date_gmt < '2005-03-18 20:48:04' AND cat_ID <> 1
GROUP BY category_id |

Second message:
other possible culprit - "distinct" is also something to be very careful with

| 113 | Query | 0 | Copying to tmp table | SELECT DISTINCT YEAR(post_date) AS year,
MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE
post_date < '2005-03-18 12:56:58' AND post_status = 'publish' GROUP BY
YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC |

| 114 | Query | 1 | Copying to tmp table | SELECT DISTINCT YEAR(post_date) AS year,
MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE
post_date < '2005-03-18 12:56:57' AND post_status = 'publish' GROUP BY
YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC |

| 115 | Query | 0 | Copying to tmp table | SELECT DISTINCT YEAR(post_date) AS year,
MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE
post_date < '2005-03-18 12:56:58' AND post_status = 'publish' GROUP BY
YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC |

| 116 | Query | 0 | Sorting result | SELECT * FROM ibf_topics WHERE forum_id=10 and
approved=1 and (last_post > 1105995418 OR pinned=1) ORDER BY pinned

 

 

 

 

Top