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

XMLWordPrintable

    • Type: Incident report
    • Resolution: Duplicate
    • Priority: Critical
    • None
    • Affects Version/s: 2.2.4
    • Component/s: Server (S)
    • None
    • Environment:
      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

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

              Created:
              Updated:
              Resolved: