SELECT DISTINCT t.triggerid,t.description,t.flags,t.expression,h.name as host FROM  triggers t,hosts h WHERE  EXISTS (SELECT ff.triggerid FROM functions ff,items ii WHERE ff.triggerid=t.templateid AND ii.itemid=ff.itemid AND ii.hostid='13856') AND t.flags IN ('0','1')

root@db:/ramdisk# ll
-rw-rw---- 1 mysql mysql  9837510656 	??? 29 11:48 #sql_985_0.MAD
-rw-rw---- 1 mysql mysql   902660096 	??? 29 11:48 #sql_985_0.MAI

mysqli_query(): MySQL server has gone away [templates.php:393 ? CAPIObject->delete() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CTemplate->delete() ? CHostGeneral->unlink() ? DBselect() ? mysqli_query() in /nmc/httpd/zabbix/include/db.inc.php:379]
mysqli_query(): Error reading result set's header [templates.php:393 ? CAPIObject->delete() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CTemplate->delete() ? CHostGeneral->unlink() ? DBselect() ? mysqli_query() in /nmc/httpd/zabbix/include/db.inc.php:379]
Error in query [SELECT DISTINCT t.triggerid,t.description,t.flags,t.expression,h.name as host FROM  triggers t,hosts h WHERE  EXISTS (SELECT ff.triggerid FROM functions ff,items ii WHERE ff.triggerid=t.templateid AND ii.itemid=ff.itemid AND ii.hostid='13856') AND t.flags IN ('0','1')] [MySQL server has gone away]
Error in query [SELECT DISTINCT i1.itemid,i1.flags,i1.name,i1.hostid,h.name as host FROM  items i1,items i2,hosts h WHERE  i2.itemid=i1.templateid AND i2.hostid='13856' AND i1.flags IN ('0','1') AND h.hostid=i1.hostid] [MySQL server has gone away]
Error in query [SELECT DISTINCT g.graphid,g.name,g.flags,h.name as host FROM  graphs g,hosts h WHERE  EXISTS (SELECT ggi.graphid FROM graphs_items ggi,items ii WHERE ggi.graphid=g.templateid AND ii.itemid=ggi.itemid AND ii.hostid='13856') AND g.flags IN ('0','1')] [MySQL server has gone away]
Error in query [SELECT DISTINCT ht1.httptestid,ht1.name,h.name as host FROM httptest ht1 INNER JOIN httptest ht2 ON ht2.httptestid=ht1.templateid INNER JOIN hosts h ON h.hostid=ht1.hostid WHERE ht2.hostid='13856'] [MySQL server has gone away]
Error in query [SELECT at.application_templateid,at.applicationid,h.name,h.host,h.hostid FROM applications a1,application_template at,applications a2,hosts h WHERE a1.applicationid=at.applicationid AND at.templateid=a2.applicationid AND a2.hostid='13856' AND a1.hostid=h.hostid] [MySQL server has gone away]
Error in query [DELETE FROM hosts_templates WHERE templateid='13856'] [MySQL server has gone away]
SQL statement execution has failed "DELETE FROM hosts_templates WHERE templateid='13856'"
Error in query [ROLLBACK] [MySQL server has gone away]

MariaDB [zabbix]> select count(*) from triggers;
329966

MariaDB [zabbix]> select count(*) from hosts;
5506