Zabbix eats up MySQL server connections

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Major
    • 1.8.7, 1.9.6 (beta)
    • Affects Version/s: 1.8.2
    • Component/s: Server (S)
    • None
    • Environment:
      Hardware: Centos 5.3 (x86_64)
      Zabbix: 1.8.2
      MySQL: 5.0.45, innodb engine
      Apache: 2.2.3

      Almost once a day, the MySQL database stops accepting connections, which causes zabbix-server to stop. A 'show processlist' indicates most connection threads are attempting to update:

      UPDATE ids SET nextid=nextid+1 WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid'

      Doubling max_connections on MySQL doesn't help. The problem seems to occur more frequently when more users are viewing the webUI dashboard.

            Assignee:
            Unassigned
            Reporter:
            troy dias
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: