MariaDB [(none)]> show full processlist \G *************************** 1. row *************************** Id: 34 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43414 db: zabbix Command: Sleep Time: 0 State: Info: NULL Progress: 0.000 *************************** 2. row *************************** Id: 43 User: zbx_monitor Host: localhost db: NULL Command: Sleep Time: 2 State: Info: NULL Progress: 0.000 *************************** 3. row *************************** Id: 48 User: root Host: localhost db: zabbix Command: Sleep Time: 2 State: Info: NULL Progress: 0.000 *************************** 4. row *************************** Id: 343 User: root Host: localhost db: zabbix Command: Query Time: 370 State: Sending data Info: select distinct d.triggerid_down,d.triggerid_up from trigger_depends d,triggers t,hosts h,items i,functions f where t.triggerid=d.triggerid_down and t.flags<>2 and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=d.triggerid_down and h.status in (0,1) Progress: 0.000 *************************** 5. row *************************** Id: 422 User: zabbixdb Host: przabbix-jc02.vm.douglas.co.us:36200 db: zabbix Command: Query Time: 590 State: Sending data Info: select distinct d.triggerid_down,d.triggerid_up from trigger_depends d,triggers t,hosts h,items i,functions f where t.triggerid=d.triggerid_down and t.flags<>2 and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=d.triggerid_down and h.status in (0,1) Progress: 0.000 *************************** 6. row *************************** Id: 513 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43458 db: zabbix Command: Query Time: 302 State: Sending data Info: select distinct d.triggerid_down,d.triggerid_up from trigger_depends d,triggers t,hosts h,items i,functions f where t.triggerid=d.triggerid_down and t.flags<>2 and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=d.triggerid_down and h.status in (0,1) Progress: 0.000 *************************** 7. row *************************** Id: 514 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43460 db: zabbix Command: Sleep Time: 9 State: Info: NULL Progress: 0.000 *************************** 8. row *************************** Id: 523 User: zabbixdb Host: przabbix-jc02.vm.douglas.co.us:36920 db: zabbix Command: Sleep Time: 1 State: Info: NULL Progress: 0.000 *************************** 9. row *************************** Id: 603 User: zabbixdb Host: przabbix-mb01.vm.douglas.co.us:35790 db: zabbix Command: Query Time: 47 State: Sending data Info: SELECT DISTINCT p.eventid,p.r_eventid,p.objectid,p.clock,p.ns,p.name,p.acknowledged,p.severity FROM problem p,functions f,items i,hosts_groups hg WHERE p.source='0' AND p.object='0' AND p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hg.hostid AND hg.groupid IN (2,4,19,20,21,23,25) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND p.r_eventid IS NULL ORDER BY p.eventid DESC Progress: 0.000 *************************** 10. row *************************** Id: 612 User: zabbixdb Host: przabbix-mb01.vm.douglas.co.us:35810 db: zabbix Command: Query Time: 18 State: Sending data Info: SELECT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p WHERE p.source='0' AND p.object='0' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=13 WHERE p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND p.r_eventid IS NULL ORDER BY p.eventid DESC LIMIT 1001 Progress: 0.000 *************************** 11. row *************************** Id: 613 User: zabbixdb Host: przabbix-mb01.vm.douglas.co.us:35812 db: zabbix Command: Query Time: 18 State: Sending data Info: SELECT DISTINCT p.eventid,p.r_eventid,p.objectid,p.clock,p.ns,p.name,p.acknowledged,p.severity FROM problem p,functions f,items i,hosts_groups hg WHERE p.source='0' AND p.object='0' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=13 WHERE p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hg.hostid AND hg.groupid IN (2,4,19,20,21,23,25) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND p.r_eventid IS NULL ORDER BY p.eventid DESC Progress: 0.000 *************************** 12. row *************************** Id: 615 User: root Host: localhost db: NULL Command: Query Time: 0 State: starting Info: show full processlist Progress: 0.000 *************************** 13. row *************************** Id: 618 User: zabbixdb Host: przabbix-mb01.vm.douglas.co.us:35822 db: zabbix Command: Sleep Time: 2 State: Info: NULL Progress: 0.000 13 rows in set (0.000 sec) MariaDB [(none)]> use zabbix; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [zabbix]> show create table triggers; +----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | triggers | CREATE TABLE `triggers` ( `triggerid` bigint(20) unsigned NOT NULL, `expression` varchar(2048) COLLATE utf8mb4_bin NOT NULL DEFAULT '', `description` text COLLATE utf8mb4_bin NOT NULL, `url` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '', `status` int(11) NOT NULL DEFAULT 0, `value` int(11) NOT NULL DEFAULT 0, `priority` int(11) NOT NULL DEFAULT 0, `lastchange` int(11) NOT NULL DEFAULT 0, `comments` text COLLATE utf8mb4_bin NOT NULL, `error` varchar(2048) COLLATE utf8mb4_bin NOT NULL DEFAULT '', `templateid` bigint(20) unsigned DEFAULT NULL, `type` int(11) NOT NULL DEFAULT 0, `state` int(11) NOT NULL DEFAULT 0, `flags` int(11) NOT NULL DEFAULT 0, `recovery_mode` int(11) NOT NULL DEFAULT 0, `recovery_expression` varchar(2048) COLLATE utf8mb4_bin NOT NULL DEFAULT '', `correlation_mode` int(11) NOT NULL DEFAULT 0, `correlation_tag` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '', `manual_close` int(11) NOT NULL DEFAULT 0, `opdata` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '', `discover` int(11) NOT NULL DEFAULT 0, `event_name` varchar(2048) COLLATE utf8mb4_bin NOT NULL DEFAULT '', `uuid` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '', PRIMARY KEY (`triggerid`), KEY `triggers_1` (`status`), KEY `triggers_2` (`value`,`lastchange`), KEY `triggers_3` (`templateid`), CONSTRAINT `c_triggers_1` FOREIGN KEY (`templateid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin | +----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [zabbix]> MariaDB [zabbix]> MariaDB [zabbix]> MariaDB [zabbix]> MariaDB [zabbix]> MariaDB [zabbix]> MariaDB [zabbix]> show full processlist \G *************************** 1. row *************************** Id: 34 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43414 db: zabbix Command: Sleep Time: 2 State: Info: NULL Progress: 0.000 *************************** 2. row *************************** Id: 43 User: zbx_monitor Host: localhost db: NULL Command: Sleep Time: 23 State: Info: NULL Progress: 0.000 *************************** 3. row *************************** Id: 48 User: root Host: localhost db: zabbix Command: Sleep Time: 265 State: Info: NULL Progress: 0.000 *************************** 4. row *************************** Id: 343 User: root Host: localhost db: zabbix Command: Sleep Time: 71 State: Info: NULL Progress: 0.000 *************************** 5. row *************************** Id: 514 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43460 db: zabbix Command: Sleep Time: 6 State: Info: NULL Progress: 0.000 *************************** 6. row *************************** Id: 523 User: zabbixdb Host: przabbix-jc02.vm.douglas.co.us:36920 db: zabbix Command: Sleep Time: 4 State: Info: NULL Progress: 0.000 *************************** 7. row *************************** Id: 612 User: zabbixdb Host: przabbix-mb01.vm.douglas.co.us:35810 db: zabbix Command: Query Time: 285 State: Sending data Info: SELECT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p WHERE p.source='0' AND p.object='0' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=13 WHERE p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND p.r_eventid IS NULL ORDER BY p.eventid DESC LIMIT 1001 Progress: 0.000 *************************** 8. row *************************** Id: 613 User: zabbixdb Host: przabbix-mb01.vm.douglas.co.us:35812 db: zabbix Command: Query Time: 285 State: Sending data Info: SELECT DISTINCT p.eventid,p.r_eventid,p.objectid,p.clock,p.ns,p.name,p.acknowledged,p.severity FROM problem p,functions f,items i,hosts_groups hg WHERE p.source='0' AND p.object='0' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=13 WHERE p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hg.hostid AND hg.groupid IN (2,4,19,20,21,23,25) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND p.r_eventid IS NULL ORDER BY p.eventid DESC Progress: 0.000 *************************** 9. row *************************** Id: 615 User: root Host: localhost db: zabbix Command: Query Time: 0 State: starting Info: show full processlist Progress: 0.000 *************************** 10. row *************************** Id: 653 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43462 db: zabbix Command: Sleep Time: 41 State: Info: NULL Progress: 0.000 *************************** 11. row *************************** Id: 657 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43468 db: zabbix Command: Sleep Time: 32 State: Info: NULL Progress: 0.000 *************************** 12. row *************************** Id: 659 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43472 db: zabbix Command: Sleep Time: 1 State: Info: NULL Progress: 0.000 *************************** 13. row *************************** Id: 658 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43470 db: zabbix Command: Query Time: 49 State: Sending data Info: select distinct g.graphid,g.name,g.width,g.height,g.yaxismin,g.yaxismax,g.show_work_period,g.show_triggers,g.graphtype,g.show_legend,g.show_3d,g.percent_left,g.percent_right,g.ymin_type,g.ymin_itemid,g.ymax_type,g.ymax_itemid,g.discover from graphs g,graphs_items gi,items i,item_discovery id where g.graphid=gi.graphid and gi.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=122918 Progress: 0.000 *************************** 14. row *************************** Id: 660 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43474 db: zabbix Command: Sleep Time: 46 State: Info: NULL Progress: 0.000 *************************** 15. row *************************** Id: 661 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43478 db: zabbix Command: Sleep Time: 4 State: Info: NULL Progress: 0.000 *************************** 16. row *************************** Id: 662 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43476 db: zabbix Command: Sleep Time: 3 State: Info: NULL Progress: 0.000 *************************** 17. row *************************** Id: 665 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43484 db: zabbix Command: Sleep Time: 2 State: Info: NULL Progress: 0.000 *************************** 18. row *************************** Id: 663 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43480 db: zabbix Command: Sleep Time: 0 State: Info: NULL Progress: 0.000 *************************** 19. row *************************** Id: 664 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43482 db: zabbix Command: Sleep Time: 0 State: Info: NULL Progress: 0.000 *************************** 20. row *************************** Id: 667 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43492 db: zabbix Command: Sleep Time: 106 State: Info: NULL Progress: 0.000 *************************** 21. row *************************** Id: 666 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43486 db: zabbix Command: Sleep Time: 1 State: Info: NULL Progress: 0.000 *************************** 22. row *************************** Id: 668 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43494 db: zabbix Command: Sleep Time: 55 State: Info: NULL Progress: 0.000 *************************** 23. row *************************** Id: 669 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43496 db: zabbix Command: Sleep Time: 10 State: Info: NULL Progress: 0.000 *************************** 24. row *************************** Id: 671 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43500 db: zabbix Command: Sleep Time: 105 State: Info: NULL Progress: 0.000 *************************** 25. row *************************** Id: 673 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43504 db: zabbix Command: Sleep Time: 0 State: Info: NULL Progress: 0.000 *************************** 26. row *************************** Id: 670 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43498 db: zabbix Command: Sleep Time: 13 State: Info: NULL Progress: 0.000 *************************** 27. row *************************** Id: 674 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43506 db: zabbix Command: Sleep Time: 46 State: Info: NULL Progress: 0.000 *************************** 28. row *************************** Id: 672 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43502 db: zabbix Command: Sleep Time: 105 State: Info: NULL Progress: 0.000 *************************** 29. row *************************** Id: 675 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43508 db: zabbix Command: Sleep Time: 81 State: Info: NULL Progress: 0.000 *************************** 30. row *************************** Id: 676 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43510 db: zabbix Command: Sleep Time: 21 State: Info: NULL Progress: 0.000 *************************** 31. row *************************** Id: 677 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43512 db: zabbix Command: Sleep Time: 3 State: Info: NULL Progress: 0.000 *************************** 32. row *************************** Id: 678 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43514 db: zabbix Command: Sleep Time: 6 State: Info: NULL Progress: 0.000 *************************** 33. row *************************** Id: 680 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43518 db: zabbix Command: Sleep Time: 5 State: Info: NULL Progress: 0.000 *************************** 34. row *************************** Id: 679 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43516 db: zabbix Command: Sleep Time: 0 State: Info: NULL Progress: 0.000 *************************** 35. row *************************** Id: 681 User: zabbixdb Host: przabbix-mb02.vm.douglas.co.us:43520 db: zabbix Command: Query Time: 49 State: Sending data Info: select distinct g.graphid,g.name,g.width,g.height,g.yaxismin,g.yaxismax,g.show_work_period,g.show_triggers,g.graphtype,g.show_legend,g.show_3d,g.percent_left,g.percent_right,g.ymin_type,g.ymin_itemid,g.ymax_type,g.ymax_itemid,g.discover from graphs g,graphs_items gi,items i,item_discovery id where g.graphid=gi.graphid and gi.itemid=i.itemid and i.itemid=id.itemid and id.parent_itemid=122973 Progress: 0.000 *************************** 36. row *************************** Id: 689 User: zbx_monitor Host: localhost db: NULL Command: Sleep Time: 21 State: Info: NULL Progress: 0.000 *************************** 37. row *************************** Id: 722 User: zabbixdb Host: przabbix-mb01.vm.douglas.co.us:36024 db: zabbix Command: Query Time: 11 State: Sending data Info: SELECT DISTINCT p.eventid,p.r_eventid,p.objectid,p.clock,p.ns,p.name,p.acknowledged,p.severity FROM problem p,functions f,items i,hosts_groups hg WHERE p.source='0' AND p.object='0' AND p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hg.hostid AND hg.groupid IN (2,4,19,20,21,23,25) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND p.r_eventid IS NULL ORDER BY p.eventid DESC Progress: 0.000 37 rows in set (0.000 sec)