XF 1.5 mysqld = 100% cpu

[Обжигающий Иней]

Здравствуйте. Появилась проблема. Мускул загружен на 100% спу. Такая проблема раз в пол года появляется, обычно сама проходит или перезагрузкой вебсервера. Сейчас не то не другое не помогает.
На форуме в течении полу года наверное ничего не ставилось, плагины правки и т.д. не происходили.
Канал по трафику не забит, значит не ддос.

Лог мускула:

2020-04-06T17:02:52.094863Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2020-04-06T17:02:52.095434Z 0 [Warning] Changed limits: table_open_cache: 407 (requested 2000)
2020-04-06T17:02:52.407703Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-04-06T17:02:52.556453Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.16.04.1) starting as process 1290 ...
2020-04-06T17:02:52.970622Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-04-06T17:02:52.970668Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-06T17:02:52.970691Z 0 [Note] InnoDB: Uses event mutexes
2020-04-06T17:02:52.970710Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-06T17:02:52.970722Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-04-06T17:02:52.970733Z 0 [Note] InnoDB: Using Linux native AIO
2020-04-06T17:02:52.977099Z 0 [Note] InnoDB: Number of pools: 1
2020-04-06T17:02:53.072060Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-04-06T17:02:53.084256Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-04-06T17:02:53.140191Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-06T17:02:53.145473Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-04-06T17:02:53.208816Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-06T17:02:54.592614Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-06T17:02:54.592719Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-06T17:02:54.725176Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-04-06T17:02:54.726701Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-04-06T17:02:54.726722Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-04-06T17:02:54.727533Z 0 [Note] InnoDB: Waiting for purge to start
2020-04-06T17:02:54.777837Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 112815446959
2020-04-06T17:02:54.778301Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-04-06T17:02:54.778536Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-04-06T17:02:55.205882Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-04-06T17:02:55.205934Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-04-06T17:02:55.237494Z 0 [Warning] CA certificate ca.pem is self signed.
2020-04-06T17:02:55.237574Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-04-06T17:02:55.244432Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-04-06T17:02:55.244468Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-04-06T17:02:55.244510Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-04-06T17:02:55.893219Z 0 [Note] Event Scheduler: Loaded 0 events
2020-04-06T17:02:55.893642Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.29-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-04-06T17:02:56.252400Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-04-06T17:03:06.129886Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200406 20:03:06

 

[Smalesh]

mysql > SHOW PROCESSLIST;

 

[Обжигающий Иней]

mysql > SHOW PROCESSLIST;

mysql> SHOW PROCESSLIST;
+------+------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id   | User | Host      | db                 | Command | Time | State        | Info                                                                                                 |
+------+------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 4569 | root | localhost | forum_site_ru | Execute |   11 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
         |
| 4571 | root | localhost | forum_site_ru | Execute |   10 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
         |
| 4574 | root | localhost | forum_site_ru | Execute |    9 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
         |
| 4580 | root | localhost | forum_site_ru | Execute |    6 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
         |
| 4581 | root | localhost | forum_site_ru | Execute |    6 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
         |
| 4582 | root | localhost | forum_site_ru | Execute |    5 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
         |
| 4583 | root | localhost | NULL               | Query   |    0 | starting     | SHOW PROCESSLIST                                                                                     |
| 4584 | root | localhost | forum_site_ru | Execute |    1 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
         |
| 4587 | root | localhost | forum_site_ru | Execute |    0 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
         |
+------+------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
9 rows in set (0,00 sec)

mysql>

 

[Smalesh]

Блин.

SHOW FULL PROCESSLIST;

 

[Обжигающий Иней]

Блин.

SHOW FULL PROCESSLIST;

mysql> SHOW FULL PROCESSLIST;
+------+------+-----------+------+---------+------+----------+-----------------------+
| Id   | User | Host      | db   | Command | Time | State    | Info                  |
+------+------+-----------+------+---------+------+----------+-----------------------+
| 4583 | root | localhost | NULL | Sleep   |  484 |          | NULL                  |
| 6238 | root | localhost | NULL | Query   |    0 | starting | SHOW FULL PROCESSLIST |
+------+------+-----------+------+---------+------+----------+-----------------------+
2 rows in set (0,00 sec)

mysql>

 

[Smalesh]

Теперь искать вчерашний день? Это нужно было в момент нагрузки, в первую очередь. Смотреть чем занят мускул в этот момент и что за запрос там прилетел.

 

[Обжигающий Иней]

Теперь искать вчерашний день? Это нужно было в момент нагрузки, в первую очередь. Смотреть чем занят мускул в этот момент и что за запрос там прилетел.

В момент загрузки:

mysql> SHOW FULL PROCESSLIST;
+----+------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host      | db                 | Command | Time | State        | Info                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
+----+------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 62 | root | localhost | forum_site_ru | Execute |   11 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 63 | root | localhost | forum_site_ru | Execute |   10 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 67 | root | localhost | NULL               | Query   |    0 | starting     | SHOW FULL PROCESSLIST                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| 70 | root | localhost | forum_site_ru | Execute |    7 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 73 | root | localhost | forum_site_ru | Execute |    7 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 79 | root | localhost | forum_site_ru | Execute |    6 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 81 | root | localhost | forum_site_ru | Execute |    1 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 85 | root | localhost | forum_site_ru | Execute |    1 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
+----+------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
8 rows in set (0,00 sec)

 

[Обжигающий Иней]

Вот уже при работе мускул:
Но я не понимаю что нужно смотреть.

mysql> SHOW FULL PROCESSLIST;
+------+------+-----------+--------------------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id   | User | Host      | db                 | Command | Time | State        | Info                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
+------+------+-----------+--------------------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|   67 | root | localhost | NULL               | Sleep   |  556 |              | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
|  576 | root | localhost | NULL               | Sleep   |  409 |              | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| 1847 | root | localhost | NULL               | Query   |    0 | starting     | SHOW FULL PROCESSLIST                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| 1851 | root | localhost | forum_site_ru | Execute |   13 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 1852 | root | localhost | forum_site_ru | Execute |   11 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 1855 | root | localhost | forum_site_ru | Execute |    9 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 1857 | root | localhost | forum_site_ru | Execute |    7 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 1858 | root | localhost | forum_site_ru | Execute |    7 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 202, 126, 161, 6, 287, 288, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 1864 | root | localhost | forum_site_ru | Execute |    4 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 1865 | root | localhost | forum_site_ru | Execute |    3 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
| 1869 | root | localhost | forum_site_ru | Execute |    2 | Sending data | SELECT thread.thread_id, post.post_id
                        FROM xf_post AS post
                        INNER JOIN xf_thread AS thread ON
                                (post.thread_id = thread.thread_id AND thread.node_id IN (60, 285, 252, 247, 333, 361, 248, 249, 250, 251, 356, 230, 257, 318, 97, 279, 55, 337, 57, 362, 109, 154, 153, 100, 357, 317, 103, 108, 228, 118, 274, 275, 310, 334, 276, 363, 277, 278, 306, 350, 5, 299, 301, 352, 360, 305, 41, 351, 123, 293, 289, 291, 292, 6, 294, 316, 45, 304, 71, 11, 243, 42, 263, 184, 326, 217, 264, 137, 138, 136, 336, 127, 130, 128, 129, 132, 280, 281, 283, 111, 212, 102, 134, 141, 140, 119, 125, 162, 163, 124, 145, 146, 206, 148, 155, 156, 159, 339, 158, 224, 226, 227, 233, 225, 254, 255, 256, 344, 345, 347, 348, 297, 358, 211, 218, 164, 267, 151, 143, 189, 150, 160, 245, 74, 92, 93, 94, 122, 76, 81, 82, 83, 84, 312, 85, 86, 87, 88, 89, 90, 244, 91, 75, 25, 95, 96, 104, 78, 77, 79, 80, 101, 290, 300, 220, 32, 325, 313, 338, 321, 314, 234, 268, 236, 239, 240, 262, 178, 213, 214, 204, 205, 216, 171, 192, 266, 172, 215, 173, 193, 174, 265, 194, 195, 169, 180, 181, 183, 182, 203, 190, 196, 197, 200, 201, 327, 328, 329, 273, 269, 179, 166, 167, 191, 73))
                        INNER JOIN xf_forum AS forum ON
                                (forum.node_id = thread.node_id AND forum.find_new = 1)
                        LEFT JOIN xf_thread_read AS thread_read ON
                                (thread_read.thread_id = thread.thread_id AND thread_read.user_id = ?)
                        LEFT JOIN xf_forum_read AS forum_read ON
                                (forum_read.node_id = thread.node_id AND forum_read.user_id = ?)
                        WHERE post.post_date > ?
                        AND post.message_state = 'visible'
                        AND thread.discussion_state = 'visible'
                        AND post.post_date > GREATEST(
                                IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date),
                                IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date)
                        ) |
+------+------+-----------+--------------------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
11 rows in set (0,00 sec)

mysql>

 

[Smalesh]

Пачка однотипных запросов, сам по себе запрос отпрофилировать не помешает, но запущенные одновременно начинают конкурировать.
Загрузка канала ни о чем не говорит, перековырять access-логи, чтобы исключить парсеры ботов и т.д., т.е. внешнюю составляющую. top (именно top), посмотреть что с /etc/my.cnf и счетчиками. возможно что-то подправить. Исключить проблемные плагины (ибо не должно такое творить при штатном движке). Это направление поиска, а не "я сюда все покопипастю, а вы чините".

 

[Обжигающий Иней]

Smalesh, крайне вам благодарен за помощь. Вы случайно услуги администрирования не предоставляете? Готов предоставить доступ, и оплату.

чтобы исключить парсеры ботов и т.д., т.е. внешнюю составляющую

Я пробовал увеличить до 8 ядер, целый xeon e5645 выделил, не помогло. Процесс забил все ядра. думаю если выдать мильон ядер, забьёт мильон. Думаю баг какой то.

Пачка однотипных запросов, сам по себе запрос отпрофилировать не помешает, но запущенные одновременно начинают конкурировать.
Загрузка канала ни о чем не говорит, перековырять access-логи, чтобы исключить парсеры ботов и т.д., т.е. внешнюю составляющую. top (именно top), посмотреть что с /etc/my.cnf и счетчиками. возможно что-то подправить. Исключить проблемные плагины (ибо не должно такое творить при штатном движке). Это направление поиска, а не "я сюда все покопипастю, а вы чините".

Проблемы та не было никакой. Пол года всё хорошо не лагало. А сейчас выдало, и что самое странное никаких работ по форуму не велось оч. долго. Значит проблема хрен знает где.

Проблема решена. Отключил все плагины и нагрузка ушла. Видимо я криворукий это да, странно всё это Как так работает всё ничего не трогаешь бах и не работает. Буду разбирать дополнения модификации. Ещё раз спасибо всем за помощь.

 

[Smalesh]

Вы случайно услуги администрирования не предоставляете? Готов предоставить доступ, и оплату.

Давно все забито, мне бы свою работу поделать и сдать хоть в какие-то разумные рамки

А сейчас выдало

Это следствие. Причина - сначала нужно исключить http-запросы

перековырять access-логи

Если там все ок, то посмотреть в каком состоянии сам сервер, mysql, счетчики. Если все в рамках допустимого - смотреть что за плагины выделываются

Отключил все плагины и нагрузка ушла

Скорее всего какой-то плагин напрямую с базы дергает, без кеша и прочего. Ну и опять же смотреть остальные пункты выше.

 

[Обжигающий Иней]

Что мешало: Unread Post Count
Грёбанный счётчик ? ))
Я ну ваще хз. Отключил его и всё ок нагрузска с сотки до нуля.

 

[Smalesh]

Отключил его и всё ок нагрузска с сотки до нуля.

В топике по плагину вроде проскакивало решение или костыль. Как и говорил,

Скорее всего какой-то плагин напрямую с базы дергает, без кеша и прочего

 

[Обжигающий Иней]

Smalesh, в роде нашёл Unread Post Count
Но он не помог. Всё равно нагрузка под сотку. Пришлось опять выключить.

 

[Smalesh]

Это уже вопросы в тему плагина. Но учитывая что ветка не поддерживается и слегка издохла, то вряд ли будет какое либо решение кроме как переписать плагин заново.
А первоначальный вопрос самого топика давно исчерпан, алгоритм поиска проблемы и слабые места выше.
Тему можно и закрывать.