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

MySQL & InnoDB: Zabbix server executes queries that sit in "Creating sort index" state for several hours

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 2.2.4
    • Server (S)
    • None
    • Ubuntu Linux (precise) x86_64, Percona Server 5.6, Zabbix server 2.2.4.

      Unique MySQL options:
      innodb_file_per_table
      innodb_flush_method=O_DIRECT
      innodb_log_file_size=4G
      innodb_buffer_pool_size=16G

      Like title.

      my.cnf: http://pastie.org/9375234
      processlist of Percona Server 5.6: http://pastie.org/pastes/9375240/text
      zabbix_server.conf: http://pastie.org/9375266

      It should also be noted that when Zabbix server is running, Percona Server experiences an extremely high disk load, which makes the rest of the server extremely slow with default options (except the larger cache as detailed in the environment). Here's iotop when the queries are sitting at "Creating sort index": http://pastie.org/9375243

            Unassigned Unassigned
            synthead Synthead
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: