path: root/templates/db/mysql_agent2/template_db_mysql_agent2.yaml

zabbix_export:
  version: '6.0'
  date: '2022-01-26T10:38:48Z'
  groups:
    -
      uuid: 748ad4d098d447d492bb935c907f652f
      name: Templates/Databases
  templates:
    -
      uuid: 4904f84303c74c5e955b7849730c3155
      template: 'MySQL by Zabbix agent 2'
      name: 'MySQL by Zabbix agent 2'
      description: |
        Requirements for template operation:
        1. Create MySQL user for monitoring. For example:
        CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '<password>';
        GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'zbx_monitor'@'%';
        For more information please read the MySQL documentation https://dev.mysql.com/doc/refman/8.0/en/grant.html.
        2. Set in the {$MYSQL.DSN} macro the data source name of the MySQL instance either session name from Zabbix agent 2 configuration file or URI.
        Examples: MySQL1, tcp://localhost:3306, tcp://172.16.0.10, unix:/var/run/mysql.sock
        For more information about MySQL Unix socket file please read the MySQL documentation https://dev.mysql.com/doc/refman/8.0/en/problems-with-mysql-sock.html.
        3. If you had set URI in the {$MYSQL.DSN}, please define the user name and password in host macros ({$MYSQL.USER} and {$MYSQL.PASSWORD}).
        Leave macros {$MYSQL.USER} and {$MYSQL.PASSWORD} empty if you use a session name. Set the user name and password in the Plugins.Mysql.<...> section of your Zabbix agent 2 configuration file.
        For more information about configuring the Zabbix MySQL plugin please read the documentation https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/src/go/plugins/mysql/README.md.
        
        
        You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/384189-discussion-thread-for-official-zabbix-template-db-mysql
        
        Template tooling version used: 0.41
      groups:
        -
          name: Templates/Databases
      items:
        -
          uuid: 8a7b77d4e96a4a2d93f63eb8ca3c979b
          name: 'MySQL: Aborted clients per second'
          type: DEPENDENT
          key: mysql.aborted_clients.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of connections that were aborted because the client died without closing the connection properly.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Aborted_clients
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
        -
          uuid: 77a407bb911f4b938c32de289da83383
          name: 'MySQL: Aborted connections per second'
          type: DEPENDENT
          key: mysql.aborted_connects.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of failed attempts to connect to the MySQL server.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Aborted_connects
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
          triggers:
            -
              uuid: 0f984c4458ae4a7f9388b1edb42090bf
              expression: 'min(/MySQL by Zabbix agent 2/mysql.aborted_connects.rate,5m)>{$MYSQL.ABORTED_CONN.MAX.WARN}'
              name: 'MySQL: Server has aborted connections (over {$MYSQL.ABORTED_CONN.MAX.WARN} for 5m)'
              priority: AVERAGE
              description: 'The number of failed attempts to connect to the MySQL server is more than {$MYSQL.ABORTED_CONN.MAX.WARN} in the last 5 minutes.'
              dependencies:
                -
                  name: 'MySQL: Refused connections (max_connections limit reached)'
                  expression: 'last(/MySQL by Zabbix agent 2/mysql.connection_errors_max_connections.rate)>0'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: 06338fe53a014be095f3807d58b9ed5b
          name: 'MySQL: Binlog cache disk use'
          type: DEPENDENT
          key: mysql.binlog_cache_disk_use
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of transactions that used a temporary disk cache because they could not fit in the regular binary log cache, being larger than binlog_cache_size.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Binlog_cache_disk_use
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: cache
        -
          uuid: e222b97642d04128af8c1ec20e463152
          name: 'MySQL: Buffer pool efficiency'
          type: CALCULATED
          key: mysql.buffer_pool_efficiency
          history: 7d
          value_type: FLOAT
          units: '%'
          params: |
            last(//mysql.innodb_buffer_pool_reads) / 
            ( last(//mysql.innodb_buffer_pool_read_requests) + 
            ( last(//mysql.innodb_buffer_pool_read_requests) = 0 ) ) * 100 * 
            ( last(//mysql.innodb_buffer_pool_read_requests) > 0 )
          description: 'The item shows how effectively the buffer pool is serving reads.'
          tags:
            -
              tag: component
              value: memory
        -
          uuid: 70a1642e80114fd3a129c5774acc4f50
          name: 'MySQL: Buffer pool utilization'
          type: CALCULATED
          key: mysql.buffer_pool_utilization
          history: 7d
          value_type: FLOAT
          units: '%'
          params: |
            ( last(//mysql.innodb_buffer_pool_pages_total) - 
            last(//mysql.innodb_buffer_pool_pages_free) ) / 
            ( last(//mysql.innodb_buffer_pool_pages_total) + 
            ( last(//mysql.innodb_buffer_pool_pages_total) = 0 ) ) * 100 * 
            ( last(//mysql.innodb_buffer_pool_pages_total) > 0 )
          description: 'Ratio of used to total pages in the buffer pool.'
          tags:
            -
              tag: component
              value: memory
          triggers:
            -
              uuid: d785a37fe8d7484d9998e47e0e1d741f
              expression: 'max(/MySQL by Zabbix agent 2/mysql.buffer_pool_utilization,5m)<{$MYSQL.BUFF_UTIL.MIN.WARN}'
              name: 'MySQL: Buffer pool utilization is too low (less than {$MYSQL.BUFF_UTIL.MIN.WARN}% for 5m)'
              priority: WARNING
              description: 'The buffer pool utilization is less than {$MYSQL.BUFF_UTIL.MIN.WARN}% in the last 5 minutes. This means that there is a lot of unused RAM allocated for the buffer pool, which you can easily reallocate at the moment.'
              tags:
                -
                  tag: scope
                  value: notice
        -
          uuid: 1501b3b4d2b143378d162bd88ab70504
          name: 'MySQL: Bytes received'
          type: DEPENDENT
          key: mysql.bytes_received.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Number of bytes received from all clients.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Bytes_received
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: network
        -
          uuid: 0af5a1b506ef4f348a11757cea440a05
          name: 'MySQL: Bytes sent'
          type: DEPENDENT
          key: mysql.bytes_sent.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Number of bytes sent to all clients.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Bytes_sent
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: network
        -
          uuid: 0ebaced7ea3a4d9d9091128a8b0f6c49
          name: 'MySQL: Command Delete per second'
          type: DEPENDENT
          key: mysql.com_delete.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The Com_delete counter variable indicates the number of times the delete statement has been executed.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Com_delete
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: operations
        -
          uuid: cc5aeff5d46c43259b7a8d0ca3296e8a
          name: 'MySQL: Command Insert per second'
          type: DEPENDENT
          key: mysql.com_insert.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The Com_insert counter variable indicates the number of times the insert statement has been executed.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Com_insert
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: operations
        -
          uuid: e50d21a5d6764626a1eb3eb9f15dbc61
          name: 'MySQL: Command Select per second'
          type: DEPENDENT
          key: mysql.com_select.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The Com_select counter variable indicates the number of times the select statement has been executed.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Com_select
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: operations
        -
          uuid: 6ce28af307b54a75817536105a14d80b
          name: 'MySQL: Command Update per second'
          type: DEPENDENT
          key: mysql.com_update.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The Com_update counter variable indicates the number of times the update statement has been executed.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Com_update
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: operations
        -
          uuid: aeb1cc1b7c1d47acb8788e3751bd0e6f
          name: 'MySQL: Connections per second'
          type: DEPENDENT
          key: mysql.connections.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of connection attempts (successful or not) to the MySQL server.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Connections
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
        -
          uuid: dd9a33e71dd8468a9e4f2e25d3028a88
          name: 'MySQL: Connection errors accept per second'
          type: DEPENDENT
          key: mysql.connection_errors_accept.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of errors that occurred during calls to accept() on the listening port.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Connection_errors_accept
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
        -
          uuid: 12627c45088c4ed6a69c743ddf12e42e
          name: 'MySQL: Connection errors internal per second'
          type: DEPENDENT
          key: mysql.connection_errors_internal.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of refused connections due to internal server errors, for example, out of memory errors, or failed thread starts.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Connection_errors_internal
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
        -
          uuid: 1ad00e1a8a984254bec89c75a2d57ea0
          name: 'MySQL: Connection errors max connections per second'
          type: DEPENDENT
          key: mysql.connection_errors_max_connections.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of refused connections due to the max_connections limit being reached.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Connection_errors_max_connections
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
          triggers:
            -
              uuid: 15cd0177e955459ba0862425755583a0
              expression: 'last(/MySQL by Zabbix agent 2/mysql.connection_errors_max_connections.rate)>0'
              name: 'MySQL: Refused connections (max_connections limit reached)'
              priority: AVERAGE
              description: 'Number of refused connections due to the max_connections limit being reached.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: fbabb9b53f754cf6be0f657e90897bd9
          name: 'MySQL: Connection errors peer address per second'
          type: DEPENDENT
          key: mysql.connection_errors_peer_address.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of errors while searching for the connecting client IP address.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Connection_errors_peer_address
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
        -
          uuid: 48a2a6533ca4412d86e9f85fd748ad3b
          name: 'MySQL: Connection errors select per second'
          type: DEPENDENT
          key: mysql.connection_errors_select.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of errors during calls to select() or poll() on the listening port. The client would not necessarily have been rejected in these cases.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Connection_errors_select
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
        -
          uuid: 6a32e65b2e1a43bbaf718a0962271efe
          name: 'MySQL: Connection errors tcpwrap per second'
          type: DEPENDENT
          key: mysql.connection_errors_tcpwrap.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of connections the libwrap library has refused.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Connection_errors_tcpwrap
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
        -
          uuid: aaf0c77bf1b647e09633db28480ddfd7
          name: 'MySQL: Created tmp tables on disk per second'
          type: DEPENDENT
          key: mysql.created_tmp_disk_tables.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of internal on-disk temporary tables created by the server while executing statements.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Created_tmp_disk_tables
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: storage
            -
              tag: component
              value: tables
          triggers:
            -
              uuid: 8c4e0c429c8241e28b930bfce7e29be8
              expression: 'min(/MySQL by Zabbix agent 2/mysql.created_tmp_disk_tables.rate,5m)>{$MYSQL.CREATED_TMP_DISK_TABLES.MAX.WARN}'
              name: 'MySQL: Number of on-disk temporary tables created per second is high (over {$MYSQL.CREATED_TMP_DISK_TABLES.MAX.WARN} for 5m)'
              priority: WARNING
              description: 'Possibly the application using the database is in need of query optimization.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: 970c9a50e7304c4eb81c46f4456c3350
          name: 'MySQL: Created tmp files on disk per second'
          type: DEPENDENT
          key: mysql.created_tmp_files.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'How many temporary files mysqld has created.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Created_tmp_files
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: storage
          triggers:
            -
              uuid: 322b61acd92e46f787e96486d2553886
              expression: 'min(/MySQL by Zabbix agent 2/mysql.created_tmp_files.rate,5m)>{$MYSQL.CREATED_TMP_FILES.MAX.WARN}'
              name: 'MySQL: Number of temporary files created per second is high (over {$MYSQL.CREATED_TMP_FILES.MAX.WARN} for 5m)'
              priority: WARNING
              description: 'Possibly the application using the database is in need of query optimization.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: fef23a9c80e84d87803f3540277ade1e
          name: 'MySQL: Created tmp tables on memory per second'
          type: DEPENDENT
          key: mysql.created_tmp_tables.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of internal temporary tables created by the server while executing statements.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Created_tmp_tables
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: memory
            -
              tag: component
              value: tables
          triggers:
            -
              uuid: 86ed19d4ddc84f0da4a77c1dcbdf8c60
              expression: 'min(/MySQL by Zabbix agent 2/mysql.created_tmp_tables.rate,5m)>{$MYSQL.CREATED_TMP_TABLES.MAX.WARN}'
              name: 'MySQL: Number of internal temporary tables created per second is high (over {$MYSQL.CREATED_TMP_TABLES.MAX.WARN} for 5m)'
              priority: WARNING
              description: 'Possibly the application using the database is in need of query optimization.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: a18b1092c42a4560abac7af42b14f007
          name: 'MySQL: Get status variables'
          key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          history: '0'
          trends: '0'
          value_type: TEXT
          description: 'The item gets server global status information.'
          tags:
            -
              tag: component
              value: raw
        -
          uuid: 51ab15a1c63348e48e6a75ed4e0ab5e3
          name: 'MySQL: InnoDB buffer pool pages free'
          type: DEPENDENT
          key: mysql.innodb_buffer_pool_pages_free
          delay: '0'
          history: 7d
          description: 'The total size of the InnoDB buffer pool, in pages.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_buffer_pool_pages_free
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: memory
        -
          uuid: 14a8ea7cda164240bc7360454b4cd690
          name: 'MySQL: InnoDB buffer pool pages total'
          type: DEPENDENT
          key: mysql.innodb_buffer_pool_pages_total
          delay: '0'
          history: 7d
          description: 'The total size of the InnoDB buffer pool, in pages.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_buffer_pool_pages_total
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: memory
        -
          uuid: 2b017cf20cb5412fa4e39dc9b4469930
          name: 'MySQL: InnoDB buffer pool reads'
          type: DEPENDENT
          key: mysql.innodb_buffer_pool_reads
          delay: '0'
          history: 7d
          description: 'Number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from the disk.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_buffer_pool_reads
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: memory
        -
          uuid: 0f2b813c8d6740d783504055dcd9a9dc
          name: 'MySQL: InnoDB buffer pool reads per second'
          type: DEPENDENT
          key: mysql.innodb_buffer_pool_reads.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of logical reads per second that InnoDB could not satisfy from the buffer pool, and had to read directly from the disk.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_buffer_pool_reads
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: memory
        -
          uuid: ab450aaa081d4a8d9db5dfd327d3b439
          name: 'MySQL: InnoDB buffer pool read requests'
          type: DEPENDENT
          key: mysql.innodb_buffer_pool_read_requests
          delay: '0'
          history: 7d
          description: 'Number of logical read requests.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_buffer_pool_read_requests
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: memory
        -
          uuid: dbf5bd4d705744bcb185e5044ff219e9
          name: 'MySQL: InnoDB buffer pool read requests per second'
          type: DEPENDENT
          key: mysql.innodb_buffer_pool_read_requests.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of logical read requests per second.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_buffer_pool_read_requests
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: memory
        -
          uuid: 3ab113998cec43da9bb702f5894d7b24
          name: 'MySQL: Innodb buffer pool wait free'
          type: DEPENDENT
          key: mysql.innodb_buffer_pool_wait_free
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of times InnoDB waited for a free page before reading or creating a page. Normally, writes to the InnoDB buffer pool happen in the background. When no clean pages are available, dirty pages are flushed first in order to free some up. This counts the numbers of wait for this operation to finish. If this value is not small, look at the increasing innodb_buffer_pool_size.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_buffer_pool_wait_free
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: memory
        -
          uuid: e35cf67b6d2f44ffae908296faccfa50
          name: 'MySQL: Calculated value of innodb_log_file_size'
          type: CALCULATED
          key: mysql.innodb_log_file_size
          history: 7d
          value_type: FLOAT
          params: '(last(//mysql.innodb_os_log_written) - first(//mysql.innodb_os_log_written,1h)) / {$MYSQL.INNODB_LOG_FILES}'
          description: 'Calculated by (innodb_os_log_written-innodb_os_log_written(time shift -1h))/{$MYSQL.INNODB_LOG_FILES} value of the innodb_log_file_size. Innodb_log_file_size is the size in bytes of the each InnoDB redo log file in the log group. The combined size can be no more than 512GB. Larger values mean less disk I/O due to less flushing checkpoint activity, but also slower recovery from a crash.'
          preprocessing:
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          tags:
            -
              tag: component
              value: system
        -
          uuid: 2c1cba2399ab4b349e9751252c000b95
          name: 'MySQL: Innodb number open files'
          type: DEPENDENT
          key: mysql.innodb_num_open_files
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of open files held by InnoDB. InnoDB only.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_num_open_files
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: system
        -
          uuid: 6a4c63c40fb042868d2f23c86a0601a5
          name: 'MySQL: Innodb log written'
          type: DEPENDENT
          key: mysql.innodb_os_log_written
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Number of bytes written to the InnoDB log.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_os_log_written
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: system
        -
          uuid: 60cbafe89a294f6fb24e3b9efe241bf5
          name: 'MySQL: InnoDB row lock time'
          type: DEPENDENT
          key: mysql.innodb_row_lock_time
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: s
          description: 'The total time spent in acquiring row locks for InnoDB tables, in milliseconds.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_row_lock_time
            -
              type: MULTIPLIER
              parameters:
                - '0.001'
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: tables
        -
          uuid: 3827ee01c4434ff09555b4dba63bac47
          name: 'MySQL: InnoDB row lock time max'
          type: DEPENDENT
          key: mysql.innodb_row_lock_time_max
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: s
          description: 'The maximum time to acquire a row lock for InnoDB tables, in milliseconds.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_row_lock_time_max
            -
              type: MULTIPLIER
              parameters:
                - '0.001'
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: tables
        -
          uuid: 4a849f57a32847ffb41a0e8a7e7735ce
          name: 'MySQL: InnoDB row lock waits'
          type: DEPENDENT
          key: mysql.innodb_row_lock_waits
          delay: '0'
          history: 7d
          description: 'Number of times operations on InnoDB tables had to wait for a row lock.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Innodb_row_lock_waits
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: innodb
            -
              tag: component
              value: tables
        -
          uuid: afd9c494cc584ddd833298820d7beace
          name: 'MySQL: Max used connections'
          type: DEPENDENT
          key: mysql.max_used_connections
          delay: '0'
          history: 7d
          description: 'The maximum number of connections that have been in use simultaneously since the server start.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Max_used_connections
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: connections
        -
          uuid: e766adca92fa47299b79e75d263437cc
          name: 'MySQL: Open tables'
          type: DEPENDENT
          key: mysql.open_tables
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of tables that are open.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Open_tables
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: tables
        -
          uuid: 26f839251a444e9abf83d4710718962a
          name: 'MySQL: Open table definitions'
          type: DEPENDENT
          key: mysql.open_table_definitions
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of cached table definitions.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Open_table_definitions
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: tables
        -
          uuid: 8ca25701d88a4d33899a515d8e25dd5b
          name: 'MySQL: Status'
          key: 'mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          history: 7d
          valuemap:
            name: 'Service state'
          preprocessing:
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 10m
          tags:
            -
              tag: component
              value: application
            -
              tag: component
              value: health
          triggers:
            -
              uuid: 907a105ecee24eef9dd89598a42b6974
              expression: 'last(/MySQL by Zabbix agent 2/mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"])=0'
              name: 'MySQL: Service is down'
              priority: HIGH
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: 345b2dd64d4041c7849aafc82cc63580
          name: 'MySQL: Queries per second'
          type: DEPENDENT
          key: mysql.queries.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Queries
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: queries
        -
          uuid: 73bc839df32e4d598f589a4a5440925e
          name: 'MySQL: Questions per second'
          type: DEPENDENT
          key: mysql.questions.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the Queries variable.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Questions
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: queries
        -
          uuid: 0492b7b8c8464d0596c24dc877ba41e0
          name: 'MySQL: Slow queries per second'
          type: DEPENDENT
          key: mysql.slow_queries.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of queries that have taken more than long_query_time seconds.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Slow_queries
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: queries
          triggers:
            -
              uuid: 8ffcb17b0a644c5e8a2842b34d5713a8
              expression: 'min(/MySQL by Zabbix agent 2/mysql.slow_queries.rate,5m)>{$MYSQL.SLOW_QUERIES.MAX.WARN}'
              name: 'MySQL: Server has slow queries (over {$MYSQL.SLOW_QUERIES.MAX.WARN} for 5m)'
              priority: WARNING
              description: 'The number of slow queries is more than {$MYSQL.SLOW_QUERIES.MAX.WARN} in the last 5 minutes.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: de0edc0ab52b488681a597ba6bda3e9e
          name: 'MySQL: Threads cached'
          type: DEPENDENT
          key: mysql.threads_cached
          delay: '0'
          history: 7d
          description: 'Number of threads in the thread cache.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Threads_cached
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: threads
        -
          uuid: 6cd93969a80b4f738cd734764011b324
          name: 'MySQL: Threads connected'
          type: DEPENDENT
          key: mysql.threads_connected
          delay: '0'
          history: 7d
          description: 'Number of currently open connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Threads_connected
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: threads
        -
          uuid: eaab0b45e023459fa5c1e8b76e860431
          name: 'MySQL: Threads created per second'
          type: DEPENDENT
          key: mysql.threads_created.rate
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Threads_created
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: threads
        -
          uuid: c4258eb3d8db4f30bc29dc531c5276a2
          name: 'MySQL: Threads running'
          type: DEPENDENT
          key: mysql.threads_running
          delay: '0'
          history: 7d
          description: 'Number of threads which are not sleeping.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Threads_running
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: threads
        -
          uuid: 1f3a71e74d8e42a1b539d67b4fc18531
          name: 'MySQL: Uptime'
          type: DEPENDENT
          key: mysql.uptime
          delay: '0'
          history: 7d
          units: uptime
          description: 'The amount of seconds that the server has been up.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.Uptime
          master_item:
            key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          tags:
            -
              tag: component
              value: application
          triggers:
            -
              uuid: 6f4edf8bfca0477b8b28a8ff811476b3
              expression: 'nodata(/MySQL by Zabbix agent 2/mysql.uptime,30m)=1'
              name: 'MySQL: Failed to fetch info data (or no data for 30m)'
              priority: INFO
              description: 'Zabbix has not received data for items for the last 30 minutes.'
              dependencies:
                -
                  name: 'MySQL: Service is down'
                  expression: 'last(/MySQL by Zabbix agent 2/mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"])=0'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: db5159889cb94f27840e6f4974ee5c0e
              expression: 'last(/MySQL by Zabbix agent 2/mysql.uptime)<10m'
              name: 'MySQL: Service has been restarted (uptime < 10m)'
              priority: INFO
              description: 'MySQL uptime is less than 10 minutes.'
              tags:
                -
                  tag: scope
                  value: notice
        -
          uuid: 8058b068b90748fea464443058103fc8
          name: 'MySQL: Version'
          key: 'mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          delay: 15m
          history: 7d
          trends: '0'
          value_type: CHAR
          preprocessing:
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          tags:
            -
              tag: component
              value: application
          triggers:
            -
              uuid: e22c2e2213d74df98d344a95c8a96b6d
              expression: 'last(/MySQL by Zabbix agent 2/mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"],#1)<>last(/MySQL by Zabbix agent 2/mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"],#2) and length(last(/MySQL by Zabbix agent 2/mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]))>0'
              name: 'MySQL: Version has changed (new version value received: {ITEM.VALUE})'
              priority: INFO
              description: 'MySQL version has changed. Ack to close.'
              manual_close: 'YES'
              tags:
                -
                  tag: scope
                  value: notice
      discovery_rules:
        -
          uuid: 49cbb331980040908673ceb2706d9542
          name: 'Database discovery'
          key: 'mysql.db.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          delay: 1h
          filter:
            conditions:
              -
                macro: '{#DATABASE}'
                value: information_schema
                operator: NOT_MATCHES_REGEX
                formulaid: A
          description: 'Scanning databases in DBMS.'
          item_prototypes:
            -
              uuid: e3e3c31483e94be2bd24b062bb049027
              name: 'MySQL: Size of database {#DATABASE}'
              key: 'mysql.db.size["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}","{#DATABASE}"]'
              delay: 5m
              history: 7d
              units: B
              preprocessing:
                -
                  type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 1h
              tags:
                -
                  tag: component
                  value: storage
                -
                  tag: database
                  value: '{#DATABASE}'
          lld_macro_paths:
            -
              lld_macro: '{#DATABASE}'
              path: $.Database
          preprocessing:
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1d
        -
          uuid: 15035186d4d54962bc6b82ebbaea8784
          name: 'MariaDB discovery'
          type: DEPENDENT
          key: mysql.extra_metric.discovery
          delay: '0'
          description: 'Additional metrics if MariaDB is used.'
          item_prototypes:
            -
              uuid: c7ff129277134d86923dfb10e6d67928
              name: 'MySQL: Binlog commits'
              type: DEPENDENT
              key: 'mysql.binlog_commits[{#SINGLETON}]'
              delay: '0'
              history: 7d
              value_type: FLOAT
              description: 'Total number of transactions committed to the binary log.'
              preprocessing:
                -
                  type: JSONPATH
                  parameters:
                    - $.Binlog_commits
              master_item:
                key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
              tags:
                -
                  tag: component
                  value: transactions
            -
              uuid: 07b27817a20244d68f2609c43aea1dea
              name: 'MySQL: Binlog group commits'
              type: DEPENDENT
              key: 'mysql.binlog_group_commits[{#SINGLETON}]'
              delay: '0'
              history: 7d
              value_type: FLOAT
              description: 'Total number of group commits done to the binary log.'
              preprocessing:
                -
                  type: JSONPATH
                  parameters:
                    - $.Binlog_group_commits
              master_item:
                key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
              tags:
                -
                  tag: component
                  value: transactions
            -
              uuid: 152c4219a8d14812a813a250c6f17071
              name: 'MySQL: Master GTID wait count'
              type: DEPENDENT
              key: 'mysql.master_gtid_wait_count[{#SINGLETON}]'
              delay: '0'
              history: 7d
              value_type: FLOAT
              description: 'The number of times MASTER_GTID_WAIT called.'
              preprocessing:
                -
                  type: JSONPATH
                  parameters:
                    - $.Master_gtid_wait_count
                -
                  type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 6h
              master_item:
                key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
              tags:
                -
                  tag: component
                  value: transactions
            -
              uuid: 3f13ee12a3db4933804c103ebfb170c9
              name: 'MySQL: Master GTID wait timeouts'
              type: DEPENDENT
              key: 'mysql.master_gtid_wait_timeouts[{#SINGLETON}]'
              delay: '0'
              history: 7d
              value_type: FLOAT
              description: 'Number of timeouts occurring in MASTER_GTID_WAIT.'
              preprocessing:
                -
                  type: JSONPATH
                  parameters:
                    - $.Master_gtid_wait_timeouts
                -
                  type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 6h
              master_item:
                key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
              tags:
                -
                  tag: component
                  value: transactions
            -
              uuid: 6ed43548a190425a83fce15b84b3ec87
              name: 'MySQL: Master GTID wait time'
              type: DEPENDENT
              key: 'mysql.master_gtid_wait_time[{#SINGLETON}]'
              delay: '0'
              history: 7d
              value_type: FLOAT
              description: 'Total number of time spent in MASTER_GTID_WAIT.'
              preprocessing:
                -
                  type: JSONPATH
                  parameters:
                    - $.Master_gtid_wait_time
                -
                  type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 6h
              master_item:
                key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
              tags:
                -
                  tag: component
                  value: transactions
          master_item:
            key: 'mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          preprocessing:
            -
              type: JAVASCRIPT
              parameters:
                - 'return JSON.stringify(value.search(''MariaDB'')>-1 ? [{''{#SINGLETON}'': ''''}] : []);'
        -
          uuid: 59cd0d5f67e441f7ad3627233ab6b595
          name: 'Replication discovery'
          key: 'mysql.replication.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]'
          delay: 1h
          description: 'If "show slave status" returns Master_Host, "Replication: *" items are created.'
          item_prototypes:
            -
              uuid: 130d6421b7864444a083dc7ffb1c03c5
              name: 'MySQL: Replication Slave status {#MASTER_HOST}'
              key: 'mysql.replication.get_slave_status["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}","{#MASTER_HOST}"]'
              history: '0'
              trends: '0'
              value_type: TEXT
              description: 'The item gets status information on the essential parameters of the slave threads.'
              tags:
                -
                  tag: component
                  value: raw
            -
              uuid: bdbd657020b24a14a771a29a8a945a2b
              name: 'MySQL: Replication Seconds Behind Master {#MASTER_HOST}'
              type: DEPENDENT
              key: 'mysql.replication.seconds_behind_master["{#MASTER_HOST}"]'
              delay: '0'
              history: 7d
              units: s
              description: |
                Number of seconds that the slave SQL thread is behind processing the master binary log.
                A high number (or an increasing one) can indicate that the slave is unable to handle events
                from the master in a timely fashion.
              preprocessing:
                -
                  type: JSONPATH
                  parameters:
                    - $.Seconds_Behind_Master
                -
                  type: MATCHES_REGEX
                  parameters:
                    - \d+
                  error_handler: CUSTOM_ERROR
                  error_handler_params: 'Replication is not performed.'
                -
                  type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 1h
              master_item:
                key: 'mysql.replication.get_slave_status["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}","{#MASTER_HOST}"]'
              tags:
                -
                  tag: component
                  value: replication
              trigger_prototypes:
                -
                  uuid: 373e215000a64e05b0379f186141067f
                  expression: 'min(/MySQL by Zabbix agent 2/mysql.replication.seconds_behind_master["{#MASTER_HOST}"],5m)>{$MYSQL.REPL_LAG.MAX.WARN}'
                  name: 'MySQL: Replication lag is too high (over {$MYSQL.REPL_LAG.MAX.WARN} for 5m)'
                  priority: WARNING
                  tags:
                    -
                      tag: scope
                      value: notice
            -
              uuid: 2a5eb9d62cd046138d7564aa22b9ca33
              name: 'MySQL: Replication Slave IO Running {#MASTER_HOST}'
              type: DEPENDENT
              key: 'mysql.replication.slave_io_running["{#MASTER_HOST}"]'
              delay: '0'
              history: 7d
              trends: '0'
              value_type: CHAR
              description: |
                Whether the I/O thread for reading the master's binary log is running.
                Normally, you want this to be Yes unless you have not yet started a replication or have
                explicitly stopped it with STOP SLAVE.
              preprocessing:
                -
                  type: JSONPATH
                  parameters:
                    - $.Slave_IO_Running
                -
                  type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 1h
              master_item:
                key: 'mysql.replication.get_slave_status["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}","{#MASTER_HOST}"]'
              tags:
                -
                  tag: component
                  value: replication
              trigger_prototypes:
                -
                  uuid: efe46a25a1fd48e1a7504a9b06c26aee
                  expression: 'count(/MySQL by Zabbix agent 2/mysql.replication.slave_io_running["{#MASTER_HOST}"],#1,"ne","Yes")=1'
                  name: 'MySQL: The slave I/O thread is not connected to a replication master'
                  priority: WARNING
                  dependencies:
                    -
                      name: 'MySQL: The slave I/O thread is not running'
                      expression: 'count(/MySQL by Zabbix agent 2/mysql.replication.slave_io_running["{#MASTER_HOST}"],#1,"eq","No")=1'
                  tags:
                    -
                      tag: scope
                      value: availability
                -
                  uuid: 369f7ade45cd4ca39f5aa47d638e5e00
                  expression: 'count(/MySQL by Zabbix agent 2/mysql.replication.slave_io_running["{#MASTER_HOST}"],#1,"eq","No")=1'
                  name: 'MySQL: The slave I/O thread is not running'
                  priority: AVERAGE
                  description: 'Whether the I/O thread for reading the master''s binary log is running.'
                  tags:
                    -
                      tag: scope
                      value: notice
            -
              uuid: 4fbb3cb164064694b37924dfcbaf2271
              name: 'MySQL: Replication Slave SQL Running {#MASTER_HOST}'
              type: DEPENDENT
              key: 'mysql.replication.slave_sql_running["{#MASTER_HOST}"]'
              delay: '0'
              history: 7d
              trends: '0'
              value_type: CHAR
              description: |
                Whether the SQL thread for executing events in the relay log is running.
                As with the I/O thread, this should normally be Yes.
              preprocessing:
                -
                  type: JSONPATH
                  parameters:
                    - $.Slave_SQL_Running
                -
                  type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 1h
              master_item:
                key: 'mysql.replication.get_slave_status["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}","{#MASTER_HOST}"]'
              tags:
                -
                  tag: component
                  value: replication
              trigger_prototypes:
                -
                  uuid: 9099f769af4c4008a69098f9e9f63673
                  expression: 'count(/MySQL by Zabbix agent 2/mysql.replication.slave_sql_running["{#MASTER_HOST}"],#1,"eq","No")=1'
                  name: 'MySQL: The SQL thread is not running'
                  priority: WARNING
                  description: 'Whether the SQL thread for executing events in the relay log is running.'
                  dependencies:
                    -
                      name: 'MySQL: The slave I/O thread is not running'
                      expression: 'count(/MySQL by Zabbix agent 2/mysql.replication.slave_io_running["{#MASTER_HOST}"],#1,"eq","No")=1'
                  tags:
                    -
                      tag: scope
                      value: notice
            -
              uuid: bb79eaa9fc0d45e7b323a34d0c3f03cf
              name: 'MySQL: Replication Slave SQL Running State {#MASTER_HOST}'
              type: DEPENDENT
              key: 'mysql.replication.slave_sql_running_state["{#MASTER_HOST}"]'
              delay: '0'
              history: 7d
              trends: '0'
              value_type: TEXT
              description: 'This shows the state of the SQL driver threads.'
              preprocessing:
                -
                  type: JSONPATH
                  parameters:
                    - $.Slave_SQL_Running_State
                -
                  type: DISCARD_UNCHANGED_HEARTBEAT
                  parameters:
                    - 6h
              master_item:
                key: 'mysql.replication.get_slave_status["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}","{#MASTER_HOST}"]'
              tags:
                -
                  tag: component
                  value: replication
          lld_macro_paths:
            -
              lld_macro: '{#MASTER_HOST}'
              path: $.Master_Host
          preprocessing:
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1d
      tags:
        -
          tag: class
          value: database
        -
          tag: target
          value: mysql
      macros:
        -
          macro: '{$MYSQL.ABORTED_CONN.MAX.WARN}'
          value: '3'
          description: 'Number of failed attempts to connect to the MySQL server for trigger expression.'
        -
          macro: '{$MYSQL.BUFF_UTIL.MIN.WARN}'
          value: '50'
          description: 'The minimum buffer pool utilization percentage for trigger expression.'
        -
          macro: '{$MYSQL.CREATED_TMP_DISK_TABLES.MAX.WARN}'
          value: '10'
          description: 'The maximum number of created tmp tables on a disk per second for trigger expressions.'
        -
          macro: '{$MYSQL.CREATED_TMP_FILES.MAX.WARN}'
          value: '10'
          description: 'The maximum number of created tmp files on a disk per second for trigger expressions.'
        -
          macro: '{$MYSQL.CREATED_TMP_TABLES.MAX.WARN}'
          value: '30'
          description: 'The maximum number of created tmp tables in memory per second for trigger expressions.'
        -
          macro: '{$MYSQL.DSN}'
          value: '<Put your DSN>'
          description: 'System data source name such as <tcp://host:port or unix:/path/to/socket)/>.'
        -
          macro: '{$MYSQL.INNODB_LOG_FILES}'
          value: '2'
          description: 'Number of physical files in the InnoDB redo log for calculating innodb_log_file_size.'
        -
          macro: '{$MYSQL.PASSWORD}'
          description: 'MySQL user password.'
        -
          macro: '{$MYSQL.REPL_LAG.MAX.WARN}'
          value: 30m
          description: 'The lag of slave from master for trigger expression.'
        -
          macro: '{$MYSQL.SLOW_QUERIES.MAX.WARN}'
          value: '3'
          description: 'The number of slow queries for trigger expression.'
        -
          macro: '{$MYSQL.USER}'
          description: 'MySQL user name.'
      dashboards:
        -
          uuid: ca5006123e0f4eb8bc0155027e663d2c
          name: 'MySQL performance'
          pages:
            -
              widgets:
                -
                  type: GRAPH_CLASSIC
                  width: '12'
                  height: '5'
                  fields:
                    -
                      type: INTEGER
                      name: source_type
                      value: '0'
                    -
                      type: GRAPH
                      name: graphid
                      value:
                        name: 'MySQL: Operations'
                        host: 'MySQL by Zabbix agent 2'
                -
                  type: GRAPH_CLASSIC
                  x: '12'
                  width: '12'
                  height: '5'
                  fields:
                    -
                      type: INTEGER
                      name: source_type
                      value: '0'
                    -
                      type: GRAPH
                      name: graphid
                      value:
                        name: 'MySQL: Queries'
                        host: 'MySQL by Zabbix agent 2'
                -
                  type: GRAPH_CLASSIC
                  'y': '5'
                  width: '12'
                  height: '5'
                  fields:
                    -
                      type: INTEGER
                      name: source_type
                      value: '0'
                    -
                      type: GRAPH
                      name: graphid
                      value:
                        name: 'MySQL: Connections'
                        host: 'MySQL by Zabbix agent 2'
                -
                  type: GRAPH_CLASSIC
                  x: '12'
                  'y': '5'
                  width: '12'
                  height: '5'
                  fields:
                    -
                      type: INTEGER
                      name: source_type
                      value: '0'
                    -
                      type: GRAPH
                      name: graphid
                      value:
                        name: 'MySQL: Bandwidth'
                        host: 'MySQL by Zabbix agent 2'
                -
                  type: GRAPH_CLASSIC
                  'y': '10'
                  width: '12'
                  height: '5'
                  fields:
                    -
                      type: INTEGER
                      name: source_type
                      value: '0'
                    -
                      type: GRAPH
                      name: graphid
                      value:
                        name: 'MySQL: InnoDB buffer pool'
                        host: 'MySQL by Zabbix agent 2'
                -
                  type: GRAPH_CLASSIC
                  x: '12'
                  'y': '10'
                  width: '12'
                  height: '5'
                  fields:
                    -
                      type: INTEGER
                      name: source_type
                      value: '0'
                    -
                      type: GRAPH
                      name: graphid
                      value:
                        name: 'MySQL: Threads'
                        host: 'MySQL by Zabbix agent 2'
      valuemaps:
        -
          uuid: f2e8233fcf0a4dd2b53a82ca48436a88
          name: 'Service state'
          mappings:
            -
              value: '0'
              newvalue: Down
            -
              value: '1'
              newvalue: Up
  graphs:
    -
      uuid: b744bfe679fc48afbad8fe219fe88bb5
      name: 'MySQL: Bandwidth'
      graph_items:
        -
          drawtype: GRADIENT_LINE
          color: 1A7C11
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.bytes_received.rate
        -
          sortorder: '1'
          drawtype: GRADIENT_LINE
          color: 2774A4
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.bytes_sent.rate
    -
      uuid: 5fea4f7834644e0a80562c92b61c68d2
      name: 'MySQL: Connections'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.aborted_clients.rate
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.aborted_connects.rate
        -
          sortorder: '2'
          color: F63100
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.connections.rate
        -
          sortorder: '3'
          color: A54F10
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.max_used_connections
    -
      uuid: d54d16a2b4d54bbd9a2a6669631ef96d
      name: 'MySQL: InnoDB buffer pool'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.innodb_buffer_pool_pages_free
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.innodb_buffer_pool_pages_total
        -
          sortorder: '2'
          color: F63100
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.innodb_buffer_pool_read_requests.rate
        -
          sortorder: '3'
          color: A54F10
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.innodb_buffer_pool_reads.rate
    -
      uuid: 2e962ad1647d4ccfb6db420a4c196d23
      name: 'MySQL: Operations'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.com_delete.rate
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.com_insert.rate
        -
          sortorder: '2'
          color: F63100
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.com_select.rate
        -
          sortorder: '3'
          color: A54F10
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.com_update.rate
    -
      uuid: 04e6ec47b0de4476b5c7a65ae012ca23
      name: 'MySQL: Queries'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.queries.rate
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.questions.rate
        -
          sortorder: '2'
          color: F63100
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.slow_queries.rate
    -
      uuid: 974ac20701394b60823abbb84420d166
      name: 'MySQL: Threads'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.threads_cached
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.threads_connected
        -
          sortorder: '2'
          color: F63100
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.threads_created.rate
        -
          sortorder: '3'
          color: A54F10
          item:
            host: 'MySQL by Zabbix agent 2'
            key: mysql.threads_running