naydanova

# 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 FROM nayda70o_kinos06 LIKE 'wp_terms'\G
#    SHOW CREATE TABLE nayda70o_kinos06.wp_terms\G
#    SHOW TABLE STATUS FROM nayda70o_kinos06 LIKE 'wp_term_taxonomy'\G
#    SHOW CREATE TABLE nayda70o_kinos06.wp_term_taxonomy\G
#    SHOW TABLE STATUS FROM nayda70o_kinos06 LIKE 'wp_term_relationships'\G
#    SHOW CREATE TABLE nayda70o_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 FROM nayda70o_kinos06 LIKE 'wp_actionscheduler_actions'\G
#    SHOW CREATE TABLE nayda70o_kinos06.wp_actionscheduler_actions\G
#    SHOW TABLE STATUS FROM nayda70o_kinos06 LIKE 'wp_actionscheduler_groups'\G
#    SHOW CREATE TABLE nayda70o_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

• Ответ изменён 10 месяцев, 3 недели назад пользователем naydanova.

Вот что мне хостинг отправил про лог долгих:

Logs in /home/n/nayda70o/.beget/tmp/logs/mysql-slow/2025-02-28_055919

• Ответ изменён 10 месяцев, 3 недели назад пользователем naydanova.
• Ответ изменён 10 месяцев, 3 недели назад пользователем naydanova.

типа Wordfence?

В хостинге отправили к разработчику сайта. 1700 неплохо, если они реальные. У меня с их появлением ИКС упал и РСЯ скоро рекламу отключит.

Страны и боты отключить на сервере, это где? (я чайник).

Накрутка просмотров. Каждый день по 1700 просмотров на одной записи. Такого быть не может.