Доброго времени суток! Сайт на Wordpress .
Есть проблема: постоянная нагрузка от базы данных. Процессы которые сейчас выполняются в ней:
| 1354 | admin_new | localhost | admin_wp611 | Query | 1 | Copying to tmp t able | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_post meta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (
wp_posts.post_date > '1990-09-08 09:28:22'
) AND wp_posts.ID NOT IN (22552) AND (
wp_postmeta.meta_key = 'post_views_count'
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP B Y wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 15 | 0.000 |
| 1355 | admin_new | localhost | admin_wp611 | Query | 1 | Copying to tmp t able | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_post meta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (
wp_posts.post_date > '1990-09-08 09:28:22'
) AND wp_posts.ID NOT IN (13572) AND (
wp_postmeta.meta_key = 'post_views_count'
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP B Y wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 15 | 0.000 |
| 1357 | admin_new | localhost | admin_wp611 | Query | 1 | Copying to tmp t able | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_post meta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (
wp_postmeta.meta_key = 'post_views_count'
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP B Y wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC LIMIT 0, 9
Итог:снизить нагрузку на хостинг.
Опубликован 25.01.2018 в 21:00