Что-то странное с wordpress блогами происходит. Они работают чисто по товарам - там на каждом сайте около 50-100 тыс товаров, а может и больше.
раньше все было хорошо , довольно долго - более 6 месяцев. сегодня обнаружил просто огромную нагрузку ... в чем тут может быть проблема? причем однотипные какие-то запросы идут с разных сайтов - не понимаю что произошло вообще?
привожу примеры запросов (несколько раз скопировал их с веста панели - помогите, в чем тут дело? и возможно ли исправить?
+-----+------------------+-----------+------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------------------+-----------+------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
| 15 | admin_opttols | localhost | admin_opttols | Query | 33 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 135 | admin_labirint | localhost | admin_labirint | Query | 18 | Creating sort index | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 166 | admin_opttols | localhost | admin_opttols | Query | 20 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 190 | admin_svet-shop | localhost | admin_svet-shop | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 196 | admin_svet-shop | localhost | admin_svet-shop | Query | 1 | updating | UPDATE wp_yuzoviews SET views =views+1,last_viewed = '2019-10-03 18:10:34',modified=1570127684 WHER |
| 197 | admin_literatura | localhost | admin_literatura | Query | 2 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 200 | admin_literatura | localhost | admin_literatura | Query | 3 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 214 | admin_zhens_odez | localhost | admin_zhens_odez | Query | 0 | updating | UPDATE wp_yuzoviews SET views =views+1,last_viewed = '2019-10-03 18:10:34',modified=1570127685 WHER |
| 217 | admin_svet-shop | localhost | admin_svet-shop | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 221 | admin_literatura | localhost | admin_literatura | Query | 0 | updating | UPDATE wp_yuzoviews SET views =views+1,last_viewed = '2019-10-03 18:10:34',modified=1570127685 WHER |
| 222 | admin_chasy | localhost | admin_chasy | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 224 | admin_stroy-mat | localhost | admin_stroy-mat | Query | 0 | statistics | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (65913,80245,80278) ORDER BY |
| 225 | admin_default | localhost | admin_default | Sleep | 0 | | |
| 226 | admin_literatura | localhost | admin_literatura | Sleep | 0 | | |
| 228 | root | localhost | | Query | 0 | starting | show processlist |
+-----+------------------+-----------+------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
+----+------------------+-----------+------------------+---------+------+---------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------------------+-----------+------------------+---------+------+---------------------------+------------------------------------------------------------------------------------------------------+
| 2 | admin_literatura | localhost | admin_literatura | Query | 3 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 5 | admin_opttols | localhost | admin_opttols | Query | 24 | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 10 | admin_labirint | localhost | admin_labirint | Query | 4 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 11 | admin_opttols | localhost | admin_opttols | Query | 24 | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 13 | admin_opttols | localhost | admin_opttols | Query | 24 | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 14 | admin_opttols | localhost | admin_opttols | Query | 24 | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 15 | admin_opttols | localhost | admin_opttols | Query | 24 | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 20 | admin_opttols | localhost | admin_opttols | Query | 20 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 22 | admin_opttols | localhost | admin_opttols | Query | 17 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 27 | admin_svet-shop | localhost | admin_svet-shop | Query | 2 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 32 | admin_knigi-shop | localhost | admin_knigi-shop | Query | 2 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 33 | admin_stroy-mat | localhost | admin_stroy-mat | Query | 0 | updating | UPDATE wp_yuzoviews SET views =views+1,last_viewed = '2019-10-03 18:10:37',modified=1570127834 WHER |
| 35 | admin_chasy | localhost | admin_chasy | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 36 | admin_stroy-mat | localhost | admin_stroy-mat | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts. |
| 38 | root | localhost | | Query | 0 | starting | show processlist |
+----+------------------+-----------+------------------+---------+------+---------------------------+------------------------------------------------------------------------------------------------------+
Средний
