mysql> show processlist; #data was displayed, idle +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873287 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 39 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 53 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 43 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 46 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 41 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 41 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 40 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 53 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 28 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 26 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 2 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087240 | zabbix | localhost | zabbix | Query | 2 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 32 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873293 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 45 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 59 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 49 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 52 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 47 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 47 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 46 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 34 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 4 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 8 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087240 | zabbix | localhost | zabbix | Query | 2 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 3 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087268 | zabbix | localhost | zabbix | Query | 3 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087285 | zabbix | localhost | zabbix | Query | 0 | executing | SELECT itemid,COUNT(*) AS count,AVG(value) AS avg,MIN(value) AS min,MAX(value) AS max,MAX(clock) AS | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 35 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873297 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 49 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 14 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 53 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 56 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 12 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 51 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 51 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 50 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 38 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 8 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 12 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087240 | zabbix | localhost | zabbix | Query | 6 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 7 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087268 | zabbix | localhost | zabbix | Query | 0 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087312 | zabbix | localhost | zabbix | Query | 0 | executing | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 35 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873301 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 53 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 18 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 57 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 60 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 55 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 55 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 54 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 9 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 42 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 12 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 16 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 11 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087268 | zabbix | localhost | zabbix | Query | 4 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087322 | zabbix | localhost | zabbix | Query | 3 | executing | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 34 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873305 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 9 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 61 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 14 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 59 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 58 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 13 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 46 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 16 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 20 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 15 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 1 | executing | SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity,p.cause_eventid FROM problem p,f | | 3087419 | zabbix | localhost | zabbix | Query | 1 | executing | SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity,p.cause_eventid FROM problem p,f | | 3087420 | zabbix | localhost | zabbix | Query | 1 | executing | SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity,p.cause_eventid FROM problem p,f | | 3087421 | zabbix | localhost | zabbix | Query | 1 | executing | SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity,p.cause_eventid FROM problem p,f | | 3087422 | zabbix | localhost | zabbix | Query | 1 | executing | SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity,p.cause_eventid FROM problem p,f | | 3087423 | zabbix | localhost | zabbix | Query | 0 | executing | SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity,p.cause_eventid FROM problem p,f | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 38 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873307 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 12 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 63 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 16 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 15 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 48 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 18 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 22 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 17 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 2 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087421 | zabbix | localhost | zabbix | Query | 2 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087423 | zabbix | localhost | zabbix | Query | 2 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087425 | zabbix | localhost | zabbix | Query | 2 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087437 | zabbix | localhost | zabbix | Query | 0 | executing | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE | | 3087441 | zabbix | localhost | zabbix | Query | 0 | executing | SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity,p.cause_eventid FROM problem p,f | | 3087442 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 3087443 | zabbix | localhost | zabbix | Query | 0 | Opening tables | SELECT r.roleid,r.name,r.type FROM role r WHERE r.roleid='3' | | 3087444 | zabbix | localhost | zabbix | Query | 0 | starting | NULL | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 41 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873310 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 15 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 66 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 11 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 19 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 9 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 18 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 51 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 21 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 25 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 20 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 5 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087421 | zabbix | localhost | zabbix | Query | 5 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087423 | zabbix | localhost | zabbix | Query | 5 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087425 | zabbix | localhost | zabbix | Query | 5 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087437 | zabbix | localhost | zabbix | Query | 3 | executing | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 37 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873314 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 11 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 19 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 23 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 12 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 22 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 55 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 25 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 29 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 24 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 9 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087421 | zabbix | localhost | zabbix | Query | 1 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087423 | zabbix | localhost | zabbix | Query | 9 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087425 | zabbix | localhost | zabbix | Query | 9 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087437 | zabbix | localhost | zabbix | Query | 7 | executing | SELECT COUNT(*) AS rowscount,a.eventid FROM alerts a WHERE EXISTS (SELECT NULL FROM actions aa WHERE | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 37 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873320 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 16 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 25 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 29 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 14 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 13 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 28 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 31 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 3 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 30 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 15 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087421 | zabbix | localhost | zabbix | Query | 7 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087423 | zabbix | localhost | zabbix | Query | 5 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087425 | zabbix | localhost | zabbix | Query | 15 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 36 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873325 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 30 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 34 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 9 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 19 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 18 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 33 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087086 | zabbix | localhost | zabbix | Query | 36 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087239 | zabbix | localhost | zabbix | Query | 8 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 1 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 20 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087425 | zabbix | localhost | zabbix | Query | 4 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 34 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873329 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 34 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 38 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 23 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 22 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 37 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087239 | zabbix | localhost | zabbix | Query | 12 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 5 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 24 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087425 | zabbix | localhost | zabbix | Query | 8 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087539 | zabbix | localhost | zabbix | Query | 2 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 34 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873333 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 38 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 42 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 27 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 26 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 41 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 14 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 11 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087239 | zabbix | localhost | zabbix | Query | 16 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 9 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 28 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087539 | zabbix | localhost | zabbix | Query | 6 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 33 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873339 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 44 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 9 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 48 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 33 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 32 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 47 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 20 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087239 | zabbix | localhost | zabbix | Query | 22 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 15 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 34 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087539 | zabbix | localhost | zabbix | Query | 12 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087576 | zabbix | localhost | zabbix | Query | 1 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087581 | zabbix | localhost | zabbix | Query | 3 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 35 rows in set, 1 warning (0,00 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873345 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 50 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 39 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 38 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 53 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 26 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087239 | zabbix | localhost | zabbix | Query | 28 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087267 | zabbix | localhost | zabbix | Query | 21 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 40 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087539 | zabbix | localhost | zabbix | Query | 18 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087581 | zabbix | localhost | zabbix | Query | 2 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 34 rows in set, 1 warning (0,01 sec) mysql> show processlist; #during the problem +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873348 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 10 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 53 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 9 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 6 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 42 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 41 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 56 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 29 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087267 | zabbix | localhost | zabbix | Query | 24 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 43 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087539 | zabbix | localhost | zabbix | Query | 21 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087581 | zabbix | localhost | zabbix | Query | 5 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 33 rows in set, 1 warning (0,00 sec) mysql> show processlist; #data was displayed, idle +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 873350 | Waiting on empty queue | NULL | | 9 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 20 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 25 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 26 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 27 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 28 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 29 | zabbix | localhost | zabbix | Sleep | 2 | | NULL | | 31 | zabbix | localhost | zabbix | Sleep | 4 | | NULL | | 34 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 43 | zabbix | localhost | zabbix | Sleep | 55 | | NULL | | 45 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 46 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 47 | zabbix | localhost | zabbix | Sleep | 5 | | NULL | | 63 | zabbix | localhost | zabbix | Sleep | 0 | | NULL | | 64 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 68 | zabbix | localhost | zabbix | Sleep | 11 | | NULL | | 69 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 70 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 73 | zabbix | localhost | zabbix | Sleep | 3 | | NULL | | 74 | zabbix | localhost | zabbix | Sleep | 8 | | NULL | | 76 | zabbix | localhost | zabbix | Sleep | 1 | | NULL | | 79 | zabbix | localhost | zabbix | Sleep | 44 | | NULL | | 81 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 90 | zabbix | localhost | zabbix | Sleep | 43 | | NULL | | 100 | zabbix | localhost | zabbix | Sleep | 58 | | NULL | | 102 | zabbix | localhost | zabbix | Sleep | 31 | | NULL | | 108 | zabbix | localhost | zabbix | Sleep | 7 | | NULL | | 3085594 | root | localhost | NULL | Query | 0 | init | show processlist | | 3087267 | zabbix | localhost | zabbix | Query | 26 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087417 | zabbix | localhost | zabbix | Query | 45 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087539 | zabbix | localhost | zabbix | Query | 23 | executing | SELECT COUNT(DISTINCT a.alertid) AS rowscount,a.eventid FROM events e,alerts a,functions f,items i,h | | 3087685 | zabbix | localhost | zabbix | Query | 0 | closing tables | SELECT role_ruleid,roleid,type,name,value_int,value_str,value_moduleid,value_serviceid FROM role_rul | +---------+-----------------+-----------+--------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+ 33 rows in set, 1 warning (0,00 sec)