-
Incident report
-
Resolution: Fixed
-
Critical
-
3.2.0rc1
Zabbix server produce huge amount of sql requests when using trigger tags:
14717:20160910:103528.917 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value) values (1163940,0,0,14041,1473492532,316392463,1); ] 14717:20160910:103528.918 In DBget_nextid() tablename:'event_tag' 14717:20160910:103528.918 query [txnlev:1] [select nextid from ids where table_name='event_tag' and field_name='eventtagid'] 14717:20160910:103528.918 query [txnlev:1] [update ids set nextid=nextid+3 where table_name='event_tag' and field_name='eventtagid'] 14717:20160910:103528.918 query [txnlev:1] [select nextid from ids where table_name='event_tag' and field_name='eventtagid'] 14717:20160910:103528.919 End of DBget_nextid():6247568 table:'event_tag' recid:'eventtagid' 14717:20160910:103528.919 query [txnlev:1] [insert into event_tag (eventtagid,eventid,tag,value) values (6247568,1163940,'Service','serv_43850'),(6247569,1163940,'Datacenter','FR2'),(6247570,1163940,'Env','Staging'); ] 14717:20160910:103528.920 query [txnlev:1] [insert into problem (eventid,source,object,objectid,clock,ns) values (1163940,0,0,14041,1473492532,316392463); ] 14717:20160910:103528.920 In DBget_nextid() tablename:'problem_tag' 14717:20160910:103528.920 query [txnlev:1] [select nextid from ids where table_name='problem_tag' and field_name='problemtagid'] 14717:20160910:103528.921 query [txnlev:1] [update ids set nextid=nextid+3 where table_name='problem_tag' and field_name='problemtagid'] 14717:20160910:103528.921 query [txnlev:1] [select nextid from ids where table_name='problem_tag' and field_name='problemtagid'] 14717:20160910:103528.921 End of DBget_nextid():1628297 table:'problem_tag' recid:'problemtagid' 14717:20160910:103528.921 query [txnlev:1] [insert into problem_tag (problemtagid,eventid,tag,value) values (1628297,1163940,'Service','serv_43850'),(1628298,1163940,'Datacenter','FR2'),(1628299,1163940,'Env','Staging'); ]
eventtagid and problemtagid can be efficiently cached on server side.