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

upgrade zabbix from mysql 5.1 to 5.7, cpu load too high

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.0.23
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      centos 6.5 /8core/16G mysql and zabbix server location different servert

      Description

      Steps to reproduce:

      1. Due to business requiremets, i upgrade zabbix mysql from 5.1 to mysql-community-server-5.7.17

      Result:
      mysql server cpu load too high, the i check zabbix server log, it have no errors. My Teams DBA found some SQL like blow take up a lot of CPU.

      SELECT clock,ns,VALUE FROM history_uint WHERE itemid=1809973 AND clock>1548387847 AND clock<=1548388147 ORDER BY clock DESC LIMIT 1
      

      But when we do not use "ORDER BY clock DESC LIMIT 1" , it's run fast.  Thanks for your support
      Expected:
      See screenshot....
      See attached patch file...

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Geroge Wang Jian
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: