Нагрузка на MySQL и CP
-
Возникла проблема с нагрузкой на MySQL и CP. Превышает более чем на 200%. Хостинг просит устранить проблему и рекомендует плагин Heartbeat Control by WP Rocket. Плагин установлен и настроен (установлено максимальное значение в 300 секунд), но ситуация не меняется. Хостинг грозит блокировкой. Как можно снизить нагрузку?
Также, хостинг сообщает, что: «Некоторые плагины могут чрезмерно использовать
admin-ajax.phpдля выполнения своих задач, таких как опросы, уведомления или аналитика. Попробуйте, пожалуйста, произвести оптимизацию плагинов, которые создают больше всего обращений». Подскажите какие плагины могут создавать нагрузку? Как определить?логи долгих запросов к базе за 2025-02-27:
Logs in /home/n/nayda70o/.beget/tmp/logs/mysql-slow/2025-02-28_055919
Ниже статистика по нагрузке за вчерашний деньTop 6 of 6 domains: ------------------------------------------- 66322 96.30% kinosait24.ru 1850 2.69% maminblog24.ru 621 0.90% edavruki.ru 45 0.07% www.maminblog24.ru 21 0.03% www.edavruki.ru 13 0.02% www.kinosait24.ru Top 20 of 9651 IPs: ------------------------------------------- 3445 5.00% 45.130.41.126 - UNKNOWN 331 0.48% 193.232.150.81 - Russian Federation 322 0.47% 193.232.148.59 - Russian Federation 279 0.41% 13.212.141.108 - United States, Norwalk 278 0.40% 194.5.82.109 - UNKNOWN 270 0.39% 194.5.82.123 - UNKNOWN 266 0.39% 194.5.82.121 - UNKNOWN 236 0.34% 136.144.33.132 - China: LeaseWeb Netherlands B.V. 223 0.32% 62.16.53.90 - Russian Federation, Perm 195 0.28% 88.218.62.29 - Spain, Madrid 126 0.18% 102.129.223.92 - UNKNOWN 106 0.15% 66.249.66.204 - United States: Google Inc. 105 0.15% 85.192.11.141 - Russian Federation, Moscow 105 0.15% 85.192.11.199 - Russian Federation, Moscow 87 0.13% 66.249.66.192 - United States: Google Inc. 82 0.12% 213.180.203.25 - Russian Federation: YANDEX LLC 80 0.12% 77.43.189.220 - Russian Federation, Perm 77 0.11% 85.192.11.7 - Russian Federation, Moscow 74 0.11% 37.230.131.97 - Netherlands, Amsterdam 68 0.10% 85.192.11.118 - Russian Federation, Moscow Top 20 of 4118 User-Agents: ------------------------------------------- 4707 6.83% Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36 3347 4.86% Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 YaBrowser/25.2.0.0 Safari/537.36 3085 4.48% Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.3 Mobile/15E148 Safari/604.1 1948 2.83% WordPress/6.7.2; https://kinosait24.ru 1791 2.60% Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) 1401 2.03% Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.0 YaBrowser/25.2.4.492.10 SA/3 Mobile/15E148 Safari/604.1 1279 1.86% Mozilla/5.0 (iPhone; CPU iPhone OS 18_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Mobile/15E148 Safari/604.1 1183 1.72% Mozilla/5.0 (iPhone; CPU iPhone OS 17_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Mobile/15E148 Safari/604.1 1154 1.68% WP Fastest Cache Preload Bot 1085 1.58% Go-http-client/2.0 1077 1.56% Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36 989 1.44% Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 YaBrowser/25.2.4.493.10 YaApp_iOS/2502.4 YaApp_iOS_Browser/2502.4 Safari/604.1 SA/3 753 1.09% Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 YaBrowser/24.10.0.0 Safari/537.36 682 0.99% Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36 Edg/133.0.0.0 655 0.95% Mozilla/5.0 (iPhone; CPU iPhone OS 18_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 YaBrowser/25.2.4.493.10 YaApp_iOS/2502.4 YaApp_iOS_Browser/2502.4 Safari/604.1 SA/3 653 0.95% GetIntent Crawler (http://getintent.com/bot.html) 632 0.92% Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1 625 0.91% Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/27.0 Chrome/125.0.0.0 Mobile Safari/537.36 552 0.80% Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko); compatible; ChatGPT-User/1.0; +https://openai.com/bot 529 0.77% Mozilla/5.0 (iPhone; CPU iPhone OS 18_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.0 YaBrowser/25.2.4.492.10 SA/3 Mobile/15E148 Safari/604.1 Top 3 of 3 METHODs: ------------------------------------------- 52424 76.12% GET 16433 23.86% POST 15 0.02% OPTIONS Top 20 of 8507 Requests: ------------------------------------------- 13979 20.30% POST kinosait24.ru/wp-admin/admin-ajax.php 5967 8.66% GET kinosait24.ru/wp-content/plugins/wp-reactions-lite/assets/emojis/json/4.json?v=wpra_lite_options/data.json 5950 8.64% GET kinosait24.ru/wp-content/plugins/wp-reactions-lite/assets/emojis/json/5.json?v=wpra_lite_options/data.json 5945 8.63% GET kinosait24.ru/wp-content/plugins/wp-reactions-lite/assets/emojis/json/6.json?v=wpra_lite_options/data.json 5926 8.60% GET kinosait24.ru/wp-content/plugins/wp-reactions-lite/assets/emojis/json/7.json?v=wpra_lite_options/data.json 5922 8.60% GET kinosait24.ru/wp-content/plugins/wp-reactions-lite/assets/emojis/json/1.json?v=wpra_lite_options/data.json 736 1.07% GET kinosait24.ru/abidin-i-ferit-mirjatsja-i-korhany-vozvr/ 707 1.03% GET kinosait24.ru/kljukvennyj-shherbet-3-sezon-opisani/ 562 0.82% GET kinosait24.ru/ 562 0.82% GET kinosait24.ru/kogda-vyjdet-182-serija-seriala-osnovani/ 550 0.80% GET kinosait24.ru/lejla-podrobnoe-opisanie-serij-tu/ 406 0.59% GET kinosait24.ru/osnovanie-osman-opisanie-vseh-se/ 384 0.56% GET kinosait24.ru/favicon.ico 346 0.50% GET kinosait24.ru/dalekij-gorod-opisanie-vseh-serij-t/ 315 0.46% GET kinosait24.ru/v-ozhidanii-solncza-soderzhanie-serij-tureczkogo-seriala-na-russkom-yazyke/ 295 0.43% GET kinosait24.ru/postuchis-v-moyu-dver-podrobnoe-opisanie-vseh-serij-sezon-1/ 272 0.39% GET kinosait24.ru/tureckij-serial-zimorodok-3-sezon-op/ 271 0.39% GET kinosait24.ru/kljukvennyj-shherbet-2-sezon-opisanie-s/ 255 0.37% GET kinosait24.ru/kogda-vyjdet-16-serija-seriala-dalekij-g/ 245 0.36% GET kinosait24.ru/osnovanie-osman-opisanie-serij-5-go-sezona/ Top CPers: (216.128 total) ------------------------------------------- 134.751 kinosait24.ru/wp-admin/admin-ajax.php 17.725 kinosait24.ru/wp-cron.php 3.555 kinosait24.ru/favicon.ico 0.848 kinosait24.ru/apple-touch-icon.png 0.573 kinosait24.ru/lejla-podrobnoe-opisanie-serij-tu/ 0.519 kinosait24.ru/abidin-i-ferit-mirjatsja-i-korhany-vozvr/ 0.483 maminblog24.ru/wp-cron.php 0.456 kinosait24.ru/kljukvennyj-shherbet-3-sezon-opisani/ 0.417 kinosait24.ru/ 0.412 kinosait24.ru/%D0%BA%D0%BE%D0%B3%D0%B4%D0%B0-%D0%B2%D1%8B%D0%B9%D0%B4%D0%B5%D1%82-16-%D1%81%D0%B5%D1%80%D0%B8%D1%8F-%D1%81%D0%B5%D1%80%D0%B8%D0%B0%D0%BB%D0%B0-%D0%B4%D0%B0%D0%BB%D0%B5%D0%BA%D0%B8%D0%B9-%D0%B3/ 0.371 kinosait24.ru/kljukvennyj-shherbet-2-sezon-opisanie-s/ 0.352 kinosait24.ru/apple-touch-icon-precomposed.png 0.345 kinosait24.ru/postuchis-v-moyu-dver-podrobnoe-opisanie-vseh-serij-sezon-1/ 0.332 kinosait24.ru/apple-touch-icon-120x120-precomposed.png 0.289 kinosait24.ru/apple-touch-icon-120x120.png 0.277 kinosait24.ru/v-ozhidanii-solncza-soderzhanie-serij-tureczkogo-seriala-na-russkom-yazyke/ 0.268 maminblog24.ru/author/admin/feed/ 0.261 maminblog24.ru/feed/ 0.261 kinosait24.ru/serial-zhestokij-stambul-2019-2020-soderzha/ 0.260 kinosait24.ru/osnovanie-osman-opisanie-vseh-se/
Просмотр 8 ответов — с 1 по 8 (всего 8)
-
# 1.4s user time, 210ms system time, 37.87M rss, 45.06M vsz
# Current date: Fri Feb 28 05:59:17 2025
# Hostname: logstorage3
# Files: /dev/fd/63
# Overall: 2 total, 2 unique, 0.00 QPS, 0.00x concurrency ________________
# Time range: 2025-02-27T03:20:15 to 2025-02-27T10:30:14
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 4s 2s 2s 2s 2s 620us 2s
# Lock time 2ms 138us 2ms 843us 2ms 997us 843us
# Rows sent 4.34k 5 4.33k 2.17k 4.33k 3.06k 2.17k
# Rows examine 13.21k 6 13.20k 6.60k 13.20k 9.33k 6.60k
# Rows affecte 0 0 0 0 0 0 0
# Bytes sent 59.04k 303 58.75k 29.52k 58.75k 41.33k 29.52k
# Query size 2.41k 187 2.23k 1.20k 2.23k 1.44k 1.20k
# Profile
# Rank Query ID Response time Calls R/Call V/M
# ==== ================================== ============= ===== ====== =====
# 1 0x67B51156BC0303D702249949DDD81C23 2.0423 50.0% 1 2.0423 0.00 SELECT wp_terms wp_term_taxonomy wp_term_relationships
# 2 0x902203DC5A18200C6DBD56584B7B7FC5 2.0414 50.0% 1 2.0414 0.00 SELECT wp_actionscheduler_actions wp_actionscheduler_groups
# Query 1: 0 QPS, 0x concurrency, ID 0x67B51156BC0303D702249949DDD81C23 at byte 1401051
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2025-02-27T03:20:15
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 50 1
# Exec time 50 2s 2s 2s 2s 2s 0 2s
# Lock time 91 2ms 2ms 2ms 2ms 2ms 0 2ms
# Rows sent 99 4.33k 4.33k 4.33k 4.33k 4.33k 0 4.33k
# Rows examine 99 13.20k 13.20k 13.20k 13.20k 13.20k 0 13.20k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 99 58.75k 58.75k 58.75k 58.75k 58.75k 0 58.75k
# Query size 92 2.23k 2.23k 2.23k 2.23k 2.23k 0 2.23k
# String:
# Databases nayda70o_kinos06
# Hosts localhost
# Last errno 0
# Users nayda70o_kinos06
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROMnayda70o_kinos06LIKE 'wp_terms'\G
# SHOW CREATE TABLEnayda70o_kinos06.wp_terms\G
# SHOW TABLE STATUS FROMnayda70o_kinos06LIKE 'wp_term_taxonomy'\G
# SHOW CREATE TABLEnayda70o_kinos06.wp_term_taxonomy\G
# SHOW TABLE STATUS FROMnayda70o_kinos06LIKE 'wp_term_relationships'\G
# SHOW CREATE TABLEnayda70o_kinos06.wp_term_relationships\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT t.term_id, tr.object_id
FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (20860, 20858, 20849, 20845, 20841, 20832, 20827, 20820, 20815, 20808, 20800, 20797, 20792, 20786, 20250, 20772, 20745, 20734, 20727, 20718, 20710, 20703, 20700, 20695, 20690, 20685, 20683, 20675, 20673, 20665, 20663, 20656, 20653, 20649, 20642, 20635, 20626, 20623, 20615, 20610, 20606, 20598, 20592, 20586, 20584, 20576, 20574, 20561, 20542, 20534, 20520, 20507, 20508, 20500, 20495, 20491, 20487, 20482, 20478, 20473, 20467, 20463, 20461, 20459, 20457, 20451, 20445, 20442, 20437, 20430, 20422, 20420, 20414, 20410, 20407, 20403, 20391, 20386, 20378, 20375, 20370, 20359, 20342, 20340, 20334, 20326, 20322, 20301, 20312, 20302, 20294, 20285, 20275, 20267, 20258, 20245, 20213, 20224, 20222, 20217, 20206, 20199, 20195, 20190, 20187, 20185, 20181, 20177, 20173, 20171, 20157, 20149, 20140, 20127, 20119, 20110, 20109, 20107, 20094, 20078, 20076, 20065, 20063, 20059, 20053, 20040, 20031, 20030, 20028, 20021, 20015, 20004, 20003, 19997, 19989, 19981, 19971, 19922, 19960, 19923, 19946, 19924, 19921, 19920, 19919, 19915, 19911, 19901, 19897, 19886, 19530, 19879, 19869, 19859, 19853, 19846, 19844, 19832, 19823, 19818, 19814, 19811, 19800, 19795, 19786, 19770, 19769, 19757, 19758, 19755, 19750, 19744, 19735, 19729, 19717, 19716, 19718, 19714, 19705, 19695, 19689, 19681, 19677, 19666, 19656, 19642, 19633, 19626, 19621, 19606, 19607, 19603, 19581, 19579, 19566, 19543, 19542, 19535, 19522, 19523, 19515, 19512, 19505, 19501, 19497, 19482, 19483, 19468, 19456, 19451, 19447, 19443, 19438, 19431, 19418, 19404, 19399, 19384, 19386, 19387, 19373, 19381, 19368, 19357, 19339, 19341, 19337, 19333, 19323, 19315, 19313, 19311, 19295, 19122, 19258, 19246, 19244, 19221, 19220, 19219, 19218, 19201, 19200, 19199, 19177, 19176, 19175, 19106, 19090, 19091, 19048, 19073, 19029, 19026, 19025, 19017, 19007, 19008, 18998, 18980, 18978, 18965, 18958, 18945, 18929, 18928, 18919, 18912, 18902, 18901, 18892, 18875, 18876, 18869, 18827, 18815, 18778, 18783, 18714, 18868, 1
ORDER BY t.name ASC\G
# Query 2: 0 QPS, 0x concurrency, ID 0x902203DC5A18200C6DBD56584B7B7FC5 at byte 2937689
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2025-02-27T10:30:14
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 50 1
# Exec time 49 2s 2s 2s 2s 2s 0 2s
# Lock time 8 138us 138us 138us 138us 138us 0 138us
# Rows sent 0 5 5 5 5 5 0 5
# Rows examine 0 6 6 6 6 6 0 6
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 303 303 303 303 303 0 303
# Query size 7 187 187 187 187 187 0 187
# String:
# Databases nayda70o_kinos06
# Hosts localhost
# Last errno 0
# Users nayda70o_kinos06
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROMnayda70o_kinos06LIKE 'wp_actionscheduler_actions'\G
# SHOW CREATE TABLEnayda70o_kinos06.wp_actionscheduler_actions\G
# SHOW TABLE STATUS FROMnayda70o_kinos06LIKE 'wp_actionscheduler_groups'\G
# SHOW CREATE TABLEnayda70o_kinos06.wp_actionscheduler_groups\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT a.hook FROM wp_actionscheduler_actions a
JOIN wp_actionscheduler_groups g ON g.group_id = a.group_id
WHERE g.slug = 'wpforms' AND a.status IN ( 'in-progress', 'pending' )\G
Просмотр 8 ответов — с 1 по 8 (всего 8)
Тема «Нагрузка на MySQL и CP» закрыта для новых ответов.