1：我所使用zabbix监控的主机实例量级应该是全球规模最大的，目前已知。在更新模板中的监控项或是触发器时，对应的主机上的监控项和触发器都要做变更，zabbix页面执行变更时，体现到数据库层面是执行每个主机实例来更新的，不是批量一次性执行，这样在监控量级较大的时候，更新模板的监控项会时间很长，页面出现超时，甚至更新不成功。建议你们合并更新模板时应用到每个主机实例上时的SQL，一次性一条SQL更新完成，这样效率会高很多，页面相应也很快。目前我这边的量级，这个功能基本上是不可用的。我的zabbix版本是3.0.10，我想其他的版本应该也是一样。

2：SQL的索引问题：

SELECT   i.itemid,i.key_,i.hostid,i.status,i.value_type FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND (i.hostid BETWEEN '124608' AND '124622' OR i.hostid BETWEEN '125527' AND '125550' OR i.hostid BETWEEN '125879' AND '125886' OR i.hostid IN ('124846','124847','124863','124864','124865','125525','125566','125573','125580','125581','125587','125589','125596','125600','125604','125606','125609','125613','125618','125619','125621','125626','125627','125629','125632','125637','125638','125639','125640','125644','125651','125653','125662','125672','125673','125674','125675','125680','125681','125686','125689','125697','125714','125719','125720','125725','125729','125801','125808','125810','125814','125856','125860')) AND (i.key_ IN ('net.if.in[eth0]','net.if.out[eth0]','system.cpu.util[,idle]','system.cpu.load[,avg1]','vm.memory.size[pavailable]','system.swap.size[,pfree]'));

这条SQL走的索引不对，需要使用强制索引才可以，希望你们优化一下这个SQL：

SELECT   i.itemid,i.key_,i.hostid,i.status,i.value_type FROM items i force index(idx_hid_key_flag_type) WHERE i.type<>9 AND i.flags IN (0,4) AND (i.hostid BETWEEN '124608' AND '124622' OR i.hostid BETWEEN '125527' AND '125550' OR i.hostid BETWEEN '125879' AND '125886' OR i.hostid IN ('124846','124847','124863','124864','124865','125525','125566','125573','125580','125581','125587','125589','125596','125600','125604','125606','125609','125613','125618','125619','125621','125626','125627','125629','125632','125637','125638','125639','125640','125644','125651','125653','125662','125672','125673','125674','125675','125680','125681','125686','125689','125697','125714','125719','125720','125725','125729','125801','125808','125810','125814','125856','125860')) AND (i.key_ IN ('net.if.in[eth0]','net.if.out[eth0]','system.cpu.util[,idle]','system.cpu.load[,avg1]','vm.memory.size[pavailable]','system.swap.size[,pfree]'));

对应的php文件：/var/www/zbxweb/include/classes/api/services/CItem.php

行数：第68行

源码：'from' => ['items' => 'items i'],

改为：'from' => ['items' => 'items i *force index(items_1)* '],