Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-11187

Performance issue: "event_tag.eventtagid" and "problem_tag.problemtagid" are not cached on server side

    XMLWordPrintable

    Details

      Description

      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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            sasha Alexander Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: