diff options
Diffstat (limited to 'templates/db/mysql_agent2/template_db_mysql_agent2.yaml')
| -rw-r--r-- | templates/db/mysql_agent2/template_db_mysql_agent2.yaml | 89 |
1 files changed, 88 insertions, 1 deletions
diff --git a/templates/db/mysql_agent2/template_db_mysql_agent2.yaml b/templates/db/mysql_agent2/template_db_mysql_agent2.yaml index 6ffab354f91..ebb6f9c1c9d 100644 --- a/templates/db/mysql_agent2/template_db_mysql_agent2.yaml +++ b/templates/db/mysql_agent2/template_db_mysql_agent2.yaml @@ -1,11 +1,13 @@ zabbix_export: version: '5.4' - date: '2021-05-09T00:00:00Z' + date: '2021-05-10T19:42:04Z' groups: - + uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases templates: - + uuid: 4904f84303c74c5e955b7849730c3155 template: 'MySQL by Zabbix agent 2' name: 'MySQL by Zabbix agent 2' description: | @@ -30,6 +32,7 @@ zabbix_export: name: Templates/Databases items: - + uuid: 8a7b77d4e96a4a2d93f63eb8ca3c979b name: 'MySQL: Aborted clients per second' type: DEPENDENT key: mysql.aborted_clients.rate @@ -53,6 +56,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 77a407bb911f4b938c32de289da83383 name: 'MySQL: Aborted connections per second' type: DEPENDENT key: mysql.aborted_connects.rate @@ -77,6 +81,7 @@ zabbix_export: value: MySQL triggers: - + uuid: 7013811fd49542c89e1a13e426f168c2 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 @@ -86,6 +91,7 @@ zabbix_export: name: 'MySQL: Refused connections (max_connections limit reached)' expression: 'last(/MySQL by Zabbix agent 2/mysql.connection_errors_max_connections.rate)>0' - + uuid: 06338fe53a014be095f3807d58b9ed5b name: 'MySQL: Binlog cache disk use' type: DEPENDENT key: mysql.binlog_cache_disk_use @@ -109,6 +115,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: e222b97642d04128af8c1ec20e463152 name: 'MySQL: Buffer pool efficiency' type: CALCULATED key: mysql.buffer_pool_efficiency @@ -126,6 +133,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 70a1642e80114fd3a129c5774acc4f50 name: 'MySQL: Buffer pool utilization' type: CALCULATED key: mysql.buffer_pool_utilization @@ -145,11 +153,13 @@ zabbix_export: value: MySQL triggers: - + uuid: 1108f4da441e43748bf81cbb24661247 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.' - + uuid: 1501b3b4d2b143378d162bd88ab70504 name: 'MySQL: Bytes received' type: DEPENDENT key: mysql.bytes_received.rate @@ -174,6 +184,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 0af5a1b506ef4f348a11757cea440a05 name: 'MySQL: Bytes sent' type: DEPENDENT key: mysql.bytes_sent.rate @@ -198,6 +209,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 0ebaced7ea3a4d9d9091128a8b0f6c49 name: 'MySQL: Command Delete per second' type: DEPENDENT key: mysql.com_delete.rate @@ -221,6 +233,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: cc5aeff5d46c43259b7a8d0ca3296e8a name: 'MySQL: Command Insert per second' type: DEPENDENT key: mysql.com_insert.rate @@ -244,6 +257,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: e50d21a5d6764626a1eb3eb9f15dbc61 name: 'MySQL: Command Select per second' type: DEPENDENT key: mysql.com_select.rate @@ -267,6 +281,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 6ce28af307b54a75817536105a14d80b name: 'MySQL: Command Update per second' type: DEPENDENT key: mysql.com_update.rate @@ -290,6 +305,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: aeb1cc1b7c1d47acb8788e3751bd0e6f name: 'MySQL: Connections per second' type: DEPENDENT key: mysql.connections.rate @@ -313,6 +329,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: dd9a33e71dd8468a9e4f2e25d3028a88 name: 'MySQL: Connection errors accept per second' type: DEPENDENT key: mysql.connection_errors_accept.rate @@ -336,6 +353,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 12627c45088c4ed6a69c743ddf12e42e name: 'MySQL: Connection errors internal per second' type: DEPENDENT key: mysql.connection_errors_internal.rate @@ -359,6 +377,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 1ad00e1a8a984254bec89c75a2d57ea0 name: 'MySQL: Connection errors max connections per second' type: DEPENDENT key: mysql.connection_errors_max_connections.rate @@ -383,11 +402,13 @@ zabbix_export: value: MySQL 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.' - + uuid: fbabb9b53f754cf6be0f657e90897bd9 name: 'MySQL: Connection errors peer address per second' type: DEPENDENT key: mysql.connection_errors_peer_address.rate @@ -411,6 +432,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 48a2a6533ca4412d86e9f85fd748ad3b name: 'MySQL: Connection errors select per second' type: DEPENDENT key: mysql.connection_errors_select.rate @@ -434,6 +456,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 6a32e65b2e1a43bbaf718a0962271efe name: 'MySQL: Connection errors tcpwrap per second' type: DEPENDENT key: mysql.connection_errors_tcpwrap.rate @@ -457,6 +480,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: aaf0c77bf1b647e09633db28480ddfd7 name: 'MySQL: Created tmp tables on disk per second' type: DEPENDENT key: mysql.created_tmp_disk_tables.rate @@ -481,11 +505,13 @@ zabbix_export: value: MySQL triggers: - + uuid: 7bad2fb31fc746dc995f3098eebfe979 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.' - + uuid: 970c9a50e7304c4eb81c46f4456c3350 name: 'MySQL: Created tmp files on disk per second' type: DEPENDENT key: mysql.created_tmp_files.rate @@ -510,11 +536,13 @@ zabbix_export: value: MySQL triggers: - + uuid: f7a927874bc04c5bae21ce694e96c634 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.' - + uuid: fef23a9c80e84d87803f3540277ade1e name: 'MySQL: Created tmp tables on memory per second' type: DEPENDENT key: mysql.created_tmp_tables.rate @@ -539,11 +567,13 @@ zabbix_export: value: MySQL triggers: - + uuid: 41625c1f507d432ab92ba4e8dd24e10b 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.' - + uuid: a18b1092c42a4560abac7af42b14f007 name: 'MySQL: Get status variables' key: 'mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]' history: '0' @@ -555,6 +585,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: 51ab15a1c63348e48e6a75ed4e0ab5e3 name: 'MySQL: InnoDB buffer pool pages free' type: DEPENDENT key: mysql.innodb_buffer_pool_pages_free @@ -573,6 +604,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 14a8ea7cda164240bc7360454b4cd690 name: 'MySQL: InnoDB buffer pool pages total' type: DEPENDENT key: mysql.innodb_buffer_pool_pages_total @@ -595,6 +627,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 2b017cf20cb5412fa4e39dc9b4469930 name: 'MySQL: InnoDB buffer pool reads' type: DEPENDENT key: mysql.innodb_buffer_pool_reads @@ -613,6 +646,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: 0f2b813c8d6740d783504055dcd9a9dc name: 'MySQL: InnoDB buffer pool reads per second' type: DEPENDENT key: mysql.innodb_buffer_pool_reads.rate @@ -636,6 +670,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: ab450aaa081d4a8d9db5dfd327d3b439 name: 'MySQL: InnoDB buffer pool read requests' type: DEPENDENT key: mysql.innodb_buffer_pool_read_requests @@ -654,6 +689,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: dbf5bd4d705744bcb185e5044ff219e9 name: 'MySQL: InnoDB buffer pool read requests per second' type: DEPENDENT key: mysql.innodb_buffer_pool_read_requests.rate @@ -677,6 +713,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 3ab113998cec43da9bb702f5894d7b24 name: 'MySQL: Innodb buffer pool wait free' type: DEPENDENT key: mysql.innodb_buffer_pool_wait_free @@ -700,6 +737,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: e35cf67b6d2f44ffae908296faccfa50 name: 'MySQL: Calculated value of innodb_log_file_size' type: CALCULATED key: mysql.innodb_log_file_size @@ -717,6 +755,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 2c1cba2399ab4b349e9751252c000b95 name: 'MySQL: Innodb number open files' type: DEPENDENT key: mysql.innodb_num_open_files @@ -740,6 +779,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 6a4c63c40fb042868d2f23c86a0601a5 name: 'MySQL: Innodb log written' type: DEPENDENT key: mysql.innodb_os_log_written @@ -764,6 +804,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 60cbafe89a294f6fb24e3b9efe241bf5 name: 'MySQL: InnoDB row lock time' type: DEPENDENT key: mysql.innodb_row_lock_time @@ -792,6 +833,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 3827ee01c4434ff09555b4dba63bac47 name: 'MySQL: InnoDB row lock time max' type: DEPENDENT key: mysql.innodb_row_lock_time_max @@ -820,6 +862,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 4a849f57a32847ffb41a0e8a7e7735ce name: 'MySQL: InnoDB row lock waits' type: DEPENDENT key: mysql.innodb_row_lock_waits @@ -838,6 +881,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: afd9c494cc584ddd833298820d7beace name: 'MySQL: Max used connections' type: DEPENDENT key: mysql.max_used_connections @@ -860,6 +904,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: e766adca92fa47299b79e75d263437cc name: 'MySQL: Open tables' type: DEPENDENT key: mysql.open_tables @@ -883,6 +928,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 26f839251a444e9abf83d4710718962a name: 'MySQL: Open table definitions' type: DEPENDENT key: mysql.open_table_definitions @@ -906,6 +952,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 8ca25701d88a4d33899a515d8e25dd5b name: 'MySQL: Status' key: 'mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]' history: 7d @@ -922,10 +969,12 @@ zabbix_export: value: MySQL 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 - + uuid: 345b2dd64d4041c7849aafc82cc63580 name: 'MySQL: Queries per second' type: DEPENDENT key: mysql.queries.rate @@ -949,6 +998,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 73bc839df32e4d598f589a4a5440925e name: 'MySQL: Questions per second' type: DEPENDENT key: mysql.questions.rate @@ -972,6 +1022,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 0492b7b8c8464d0596c24dc877ba41e0 name: 'MySQL: Slow queries per second' type: DEPENDENT key: mysql.slow_queries.rate @@ -996,11 +1047,13 @@ zabbix_export: value: MySQL triggers: - + uuid: b5cd3920a6434c27a92096ccb10dd486 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.' - + uuid: de0edc0ab52b488681a597ba6bda3e9e name: 'MySQL: Threads cached' type: DEPENDENT key: mysql.threads_cached @@ -1019,6 +1072,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 6cd93969a80b4f738cd734764011b324 name: 'MySQL: Threads connected' type: DEPENDENT key: mysql.threads_connected @@ -1037,6 +1091,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: eaab0b45e023459fa5c1e8b76e860431 name: 'MySQL: Threads created per second' type: DEPENDENT key: mysql.threads_created.rate @@ -1060,6 +1115,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: c4258eb3d8db4f30bc29dc531c5276a2 name: 'MySQL: Threads running' type: DEPENDENT key: mysql.threads_running @@ -1078,6 +1134,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 1f3a71e74d8e42a1b539d67b4fc18531 name: 'MySQL: Uptime' type: DEPENDENT key: mysql.uptime @@ -1098,6 +1155,7 @@ zabbix_export: value: MySQL triggers: - + uuid: 313acb34fd0d46888d0be0930752d427 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 @@ -1107,11 +1165,13 @@ zabbix_export: name: 'MySQL: Service is down' expression: 'last(/MySQL by Zabbix agent 2/mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"])=0' - + 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.' - + uuid: 8058b068b90748fea464443058103fc8 name: 'MySQL: Version' key: 'mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]' delay: 15m @@ -1129,6 +1189,7 @@ zabbix_export: value: MySQL triggers: - + uuid: e13a6138e0c241c8a24cdb6d01d25e41 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))=1 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 @@ -1136,6 +1197,7 @@ zabbix_export: manual_close: 'YES' discovery_rules: - + uuid: 49cbb331980040908673ceb2706d9542 name: 'Database discovery' key: 'mysql.db.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]' delay: 1h @@ -1149,6 +1211,7 @@ zabbix_export: 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 @@ -1173,6 +1236,7 @@ zabbix_export: parameters: - 1d - + uuid: 15035186d4d54962bc6b82ebbaea8784 name: 'MariaDB discovery' type: DEPENDENT key: mysql.extra_metric.discovery @@ -1180,6 +1244,7 @@ zabbix_export: description: 'Additional metrics if MariaDB is used.' item_prototypes: - + uuid: c7ff129277134d86923dfb10e6d67928 name: 'MySQL: Binlog commits' type: DEPENDENT key: 'mysql.binlog_commits[{#SINGLETON}]' @@ -1199,6 +1264,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 07b27817a20244d68f2609c43aea1dea name: 'MySQL: Binlog group commits' type: DEPENDENT key: 'mysql.binlog_group_commits[{#SINGLETON}]' @@ -1218,6 +1284,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 152c4219a8d14812a813a250c6f17071 name: 'MySQL: Master GTID wait count' type: DEPENDENT key: 'mysql.master_gtid_wait_count[{#SINGLETON}]' @@ -1241,6 +1308,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 3f13ee12a3db4933804c103ebfb170c9 name: 'MySQL: Master GTID wait timeouts' type: DEPENDENT key: 'mysql.master_gtid_wait_timeouts[{#SINGLETON}]' @@ -1264,6 +1332,7 @@ zabbix_export: tag: Application value: MySQL - + uuid: 6ed43548a190425a83fce15b84b3ec87 name: 'MySQL: Master GTID wait time' type: DEPENDENT key: 'mysql.master_gtid_wait_time[{#SINGLETON}]' @@ -1294,12 +1363,14 @@ zabbix_export: 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' @@ -1311,6 +1382,7 @@ zabbix_export: tag: Application value: 'Zabbix raw items' - + uuid: bdbd657020b24a14a771a29a8a945a2b name: 'MySQL: Replication Seconds Behind Master {#MASTER_HOST}' type: DEPENDENT key: 'mysql.replication.seconds_behind_master["{#MASTER_HOST}"]' @@ -1344,10 +1416,12 @@ zabbix_export: value: MySQL trigger_prototypes: - + uuid: b2c7559322704815a5876948c56bb046 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 - + uuid: 2a5eb9d62cd046138d7564aa22b9ca33 name: 'MySQL: Replication Slave IO Running {#MASTER_HOST}' type: DEPENDENT key: 'mysql.replication.slave_io_running["{#MASTER_HOST}"]' @@ -1376,6 +1450,7 @@ zabbix_export: value: MySQL trigger_prototypes: - + uuid: 43cffac6ca324272b0ab46f21b8c48f8 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 @@ -1384,11 +1459,13 @@ zabbix_export: 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' - + uuid: e206383a4e554df3b2c553882a02a31b 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.' - + uuid: 4fbb3cb164064694b37924dfcbaf2271 name: 'MySQL: Replication Slave SQL Running {#MASTER_HOST}' type: DEPENDENT key: 'mysql.replication.slave_sql_running["{#MASTER_HOST}"]' @@ -1416,6 +1493,7 @@ zabbix_export: value: MySQL trigger_prototypes: - + uuid: 64f63ef0704647b9b8a7e11c4811783f 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 @@ -1425,6 +1503,7 @@ zabbix_export: 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' - + uuid: bb79eaa9fc0d45e7b323a34d0c3f03cf name: 'MySQL: Replication Slave SQL Running State {#MASTER_HOST}' type: DEPENDENT key: 'mysql.replication.slave_sql_running_state["{#MASTER_HOST}"]' @@ -1502,6 +1581,7 @@ zabbix_export: description: 'MySQL user name.' dashboards: - + uuid: ca5006123e0f4eb8bc0155027e663d2c name: 'MySQL performance' pages: - @@ -1605,6 +1685,7 @@ zabbix_export: host: 'MySQL by Zabbix agent 2' valuemaps: - + uuid: f2e8233fcf0a4dd2b53a82ca48436a88 name: 'Service state' mappings: - @@ -1615,6 +1696,7 @@ zabbix_export: newvalue: Up graphs: - + uuid: b744bfe679fc48afbad8fe219fe88bb5 name: 'MySQL: Bandwidth' graph_items: - @@ -1631,6 +1713,7 @@ zabbix_export: host: 'MySQL by Zabbix agent 2' key: mysql.bytes_sent.rate - + uuid: 5fea4f7834644e0a80562c92b61c68d2 name: 'MySQL: Connections' graph_items: - @@ -1657,6 +1740,7 @@ zabbix_export: host: 'MySQL by Zabbix agent 2' key: mysql.max_used_connections - + uuid: d54d16a2b4d54bbd9a2a6669631ef96d name: 'MySQL: InnoDB buffer pool' graph_items: - @@ -1683,6 +1767,7 @@ zabbix_export: host: 'MySQL by Zabbix agent 2' key: mysql.innodb_buffer_pool_reads.rate - + uuid: 2e962ad1647d4ccfb6db420a4c196d23 name: 'MySQL: Operations' graph_items: - @@ -1709,6 +1794,7 @@ zabbix_export: host: 'MySQL by Zabbix agent 2' key: mysql.com_update.rate - + uuid: 04e6ec47b0de4476b5c7a65ae012ca23 name: 'MySQL: Queries' graph_items: - @@ -1729,6 +1815,7 @@ zabbix_export: host: 'MySQL by Zabbix agent 2' key: mysql.slow_queries.rate - + uuid: 974ac20701394b60823abbb84420d166 name: 'MySQL: Threads' graph_items: - |