Available solutions

Template DB MySQL
Template DB MySQL by agent 2
Template DB MySQL by ODBC
3rd party solutions

Source: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mysql_agent

Template DB MySQL by Zabbix agent

Overview

For Zabbix version: 4.4
The template is developed for monitoring DBMS MySQL and its forks.

This template was tested on:

MySQL, version 5.7, 8.0
Percona, version 8.0
MariaDB, version 10.4
Zabbix, version 4.2.1

Setup

Install Zabbix agent and MySQL client. If necessary, add the path to the mysql and mysqladmin utilities to the global environment variable PATH.
Copy template_db_mysql.conf into folder with Zabbix agent configuration (/etc/zabbix/zabbix_agentd.d/ by default). Don't forget to restart zabbix-agent.
Create MySQL user for monitoring (<password> at your discretion):

CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '<password>';
GRANT USAGE,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

Create .my.cnf in home directory of Zabbix agent for Linux (/var/lib/zabbix by default ) or my.cnf in c:\ for Windows. The file must have three strings:

[client]
user=zbx_monitor
password=<password>

Zabbix configuration

No specific Zabbix configuration is required.

Macros used

Name	Description	Default
{$MYSQL.ABORTED_CONN.MAX.WARN}	The number of failed attempts to connect to the MySQL server for trigger expression.	`3`
{$MYSQL.BUFF_UTIL.MIN.WARN}	The minimum buffer pool utilization in percent for trigger expression.	`50`
{$MYSQL.HOST}	Hostname or IP of MySQL host or container.	`localhost`
{$MYSQL.PORT}	MySQL service port.	`3306`
{$MYSQL.REPL_LAG.MAX.WARN}	The lag of slave from master for trigger expression.	`30m`
{$MYSQL.SLOW_QUERIES.MAX.WARN}	The number of slow queries for trigger expression.	`3`

Template links

There are no template links in this template.

Discovery rules

Name Description Type Key and additional info

Databases discovery

Name	Description	Type	Key and additional info
Databases discovery	Scanning databases in DBMS.	ZABBIX_PASSIVE	mysql.db.discovery["{$MYSQL.HOST}","{$MYSQL.PORT}"] Preprocessing: - JAVASCRIPT: `return JSON.stringify(value.split("\n").map(function (name) { return ({"{#DBNAME}": name}); }));` - DISCARD_UNCHANGED_HEARTBEAT: `1d` Filter: AND_OR - A: {#DBNAME} NOT_MATCHES_REGEX `information_schema`
Replication discovery	If "show slave status" returns Master_Host, "Replication: *" items are created.	ZABBIX_PASSIVE	mysql.replication.discovery["{$MYSQL.HOST}","{$MYSQL.PORT}"] Preprocessing: - JAVASCRIPT: `var matches = value.match(/Master_Host.>(.)<.*/); if (matches) { return JSON.stringify([{"{#MASTERHOST}": matches[1]}]); } return '[]';` - DISCARD_UNCHANGED_HEARTBEAT: `1d`

Scanning databases in DBMS.

ZABBIX_PASSIVE

mysql.db.discovery["{$MYSQL.HOST}","{$MYSQL.PORT}"]

Preprocessing:

- JAVASCRIPT: return JSON.stringify(value.split("\n").map(function (name) { return ({"{#DBNAME}": name}); }));

- DISCARD_UNCHANGED_HEARTBEAT: 1d

Filter:

AND_OR

- A: {#DBNAME} NOT_MATCHES_REGEX information_schema

Replication discovery

If "show slave status" returns Master_Host, "Replication: *" items are created.

ZABBIX_PASSIVE

mysql.replication.discovery["{$MYSQL.HOST}","{$MYSQL.PORT}"]

Preprocessing:

- JAVASCRIPT: var matches = value.match(/Master_Host.*>(.*)<.*/); if (matches) { return JSON.stringify([{"{#MASTERHOST}": matches[1]}]); } return '[]';

- DISCARD_UNCHANGED_HEARTBEAT: 1d

Items collected

Group	Name	Description	Type	Key and additional info
MySQL	MySQL: Status		ZABBIX_PASSIVE	mysql.ping["{$MYSQL.HOST}","{$MYSQL.PORT}"] Preprocessing: - JAVASCRIPT: `return value.indexOf('is alive') !== -1 ? 1 : 0;` - DISCARD_UNCHANGED_HEARTBEAT: `10m`
MySQL	MySQL: Version		ZABBIX_PASSIVE	mysql.version["{$MYSQL.HOST}","{$MYSQL.PORT}"] Preprocessing: - REGEX: `(Server version)\s+(.+) \2` - DISCARD_UNCHANGED_HEARTBEAT: `1d`
MySQL	MySQL: Uptime	The number of seconds that the server has been up.	DEPENDENT	mysql.uptime Preprocessing: - XMLPATH: `/resultset/row[field/text()='Uptime']/field[@name='Value']/text()`
MySQL	MySQL: Aborted clients per second	The number of connections that were aborted because the client died without closing the connection properly.	DEPENDENT	mysql.aborted_clients.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Aborted_clients']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Aborted connections per second	The number of failed attempts to connect to the MySQL server.	DEPENDENT	mysql.aborted_connects.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Aborted_connects']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors accept per second	Number of errors that occurred during calls to accept() on the listening port.	DEPENDENT	mysql.connection_errors_accept.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Connection_errors_accept']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors internal per second	Number of refused connections due to internal server errors, for example out of memory errors, or failed thread starts.	DEPENDENT	mysql.connection_errors_internal.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Connection_errors_internal']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors max connections per second	Number of refused connections due to the max_connections limit being reached.	DEPENDENT	mysql.connection_errors_max_connections.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Connection_errors_max_connections']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors peer address per second	Number of errors while searching for the connecting client IP address.	DEPENDENT	mysql.connection_errors_peer_address.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Connection_errors_peer_address']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors select per second	Number of errors during calls to select() or poll() on the listening port. The client would not necessarily have been rejected in these cases.	DEPENDENT	mysql.connection_errors_select.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Connection_errors_select']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors tcpwrap per second	Number of connections the libwrap library refused.	DEPENDENT	mysql.connection_errors_tcpwrap.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Connection_errors_tcpwrap']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Connections per second	The number of connection attempts (successful or not) to the MySQL server.	DEPENDENT	mysql.connections.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Connections']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Max used connections	The maximum number of connections that have been in use simultaneously since the server started.	DEPENDENT	mysql.max_used_connections Preprocessing: - XMLPATH: `/resultset/row[field/text()='Max_used_connections']/field[@name='Value']/text()` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Threads cached	The number of threads in the thread cache.	DEPENDENT	mysql.threads_cached Preprocessing: - XMLPATH: `/resultset/row[field/text()='Threads_cached']/field[@name='Value']/text()`
MySQL	MySQL: Threads connected	The number of currently open connections.	DEPENDENT	mysql.threads_connected Preprocessing: - XMLPATH: `/resultset/row[field/text()='Threads_connected']/field[@name='Value']/text()`
MySQL	MySQL: Threads created	The 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.	DEPENDENT	mysql.threads_created Preprocessing: - XMLPATH: `/resultset/row[field/text()='Threads_created']/field[@name='Value']/text()`
MySQL	MySQL: Threads running	The number of threads that are not sleeping.	DEPENDENT	mysql.threads_running Preprocessing: - XMLPATH: `/resultset/row[field/text()='Threads_running']/field[@name='Value']/text()`
MySQL	MySQL: Buffer pool efficiency	The item shows how effectively the buffer pool is serving reads.	CALCULATED	mysql.buffer_pool_efficiency Expression: `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 )`
MySQL	MySQL: Buffer pool utilization	Ratio of used to total pages in the buffer pool.	CALCULATED	mysql.buffer_pool_utilization Expression: `( 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 )`
MySQL	MySQL: Created tmp files on disk	How many temporary files mysqld has created.	DEPENDENT	mysql.created_tmp_files Preprocessing: - XMLPATH: `/resultset/row[field/text()='Created_tmp_files']/field[@name='Value']/text()`
MySQL	MySQL: Created tmp tables on disk	The number of internal on-disk temporary tables created by the server while executing statements.	DEPENDENT	mysql.created_tmp_disk_tables Preprocessing: - XMLPATH: `/resultset/row[field/text()='Created_tmp_disk_tables']/field[@name='Value']/text()`
MySQL	MySQL: Created tmp tables on memory	The number of internal temporary tables created by the server while executing statements.	DEPENDENT	mysql.created_tmp_tables Preprocessing: - XMLPATH: `/resultset/row[field/text()='Created_tmp_tables']/field[@name='Value']/text()`
MySQL	MySQL: InnoDB buffer pool pages free	The total size of the InnoDB buffer pool, in pages.	DEPENDENT	mysql.innodb_buffer_pool_pages_free Preprocessing: - XMLPATH: `/resultset/row[field/text()='Innodb_buffer_pool_pages_free']/field[@name='Value']/text()`
MySQL	MySQL: InnoDB buffer pool pages total	The total size of the InnoDB buffer pool, in pages.	DEPENDENT	mysql.innodb_buffer_pool_pages_total Preprocessing: - XMLPATH: `/resultset/row[field/text()='Innodb_buffer_pool_pages_total']/field[@name='Value']/text()` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: InnoDB buffer pool read requests per second	The number of logical read requests per second.	DEPENDENT	mysql.innodb_buffer_pool_read_requests.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Innodb_buffer_pool_read_requests']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: InnoDB buffer pool reads per second	The number of logical reads per second that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.	DEPENDENT	mysql.innodb_buffer_pool_reads.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Innodb_buffer_pool_reads']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: InnoDB row lock time	The total time spent in acquiring row locks for InnoDB tables, in milliseconds.	DEPENDENT	mysql.innodb_row_lock_time Preprocessing: - XMLPATH: `/resultset/row[field/text()='Innodb_row_lock_time']/field[@name='Value']/text()` - MULTIPLIER: `0.001` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: InnoDB row lock time max	The maximum time to acquire a row lock for InnoDB tables, in milliseconds.	DEPENDENT	mysql.innodb_row_lock_time_max Preprocessing: - XMLPATH: `/resultset/row[field/text()='Innodb_row_lock_time_max']/field[@name='Value']/text()` - MULTIPLIER: `0.001` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: InnoDB row lock waits	The number of times operations on InnoDB tables had to wait for a row lock.	DEPENDENT	mysql.innodb_row_lock_waits Preprocessing: - XMLPATH: `/resultset/row[field/text()='Innodb_row_lock_waits']/field[@name='Value']/text()`
MySQL	MySQL: Slow queries per second	The number of queries that have taken more than long_query_time seconds.	DEPENDENT	mysql.slow_queries.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Slow_queries']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Bytes received	The number of bytes received from all clients.	DEPENDENT	mysql.bytes_received.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Bytes_received']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Bytes sent	The number of bytes sent to all clients.	DEPENDENT	mysql.bytes_sent.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Bytes_sent']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Command Delete per second	The Com_delete counter variable indicates the number of times the delete statement has been executed.	DEPENDENT	mysql.com_delete.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Com_delete']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Command Insert per second	The Com_insert counter variable indicates the number of times the insert statement has been executed.	DEPENDENT	mysql.com_insert.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Com_insert']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Command Select per second	The Com_select counter variable indicates the number of times the select statement has been executed.	DEPENDENT	mysql.com_select.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Com_select']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Command Update per second	The Com_update counter variable indicates the number of times the update statement has been executed.	DEPENDENT	mysql.com_update.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Com_update']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Queries per second	The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable.	DEPENDENT	mysql.queries.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Queries']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Questions per second	The 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.	DEPENDENT	mysql.questions.rate Preprocessing: - XMLPATH: `/resultset/row[field/text()='Questions']/field[@name='Value']/text()` - CHANGE_PER_SECOND
MySQL	MySQL: Size of database {#DBNAME}	-	ZABBIX_PASSIVE	mysql.dbsize["{$MYSQL.HOST}","{$MYSQL.PORT}","{#DBNAME}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Replication Seconds Behind Master {#MASTERHOST}	The 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.	DEPENDENT	mysql.seconds_behind_master["{#MASTERHOST}"] Preprocessing: - XMLPATH: `/resultset/row/field[@name='Seconds_Behind_Master']/text()` - DISCARD_UNCHANGED_HEARTBEAT: `1h` - NOT_MATCHES_REGEX: `null` ⛔️ON_FAIL: `CUSTOM_ERROR -> Replication is not performed.`
MySQL	MySQL: Replication Slave IO Running {#MASTERHOST}	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 replication or have explicitly stopped it with STOP SLAVE.	DEPENDENT	mysql.slave_io_running["{#MASTERHOST}"] Preprocessing: - XMLPATH: `/resultset/row/field[@name='Slave_IO_Running']/text()` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Replication Slave SQL Running {#MASTERHOST}	Whether the SQL thread for executing events in the relay log is running. As with the I/O thread, this should normally be Yes.	DEPENDENT	mysql.slave_sql_running["{#MASTERHOST}"] Preprocessing: - XMLPATH: `/resultset/row/field[@name='Slave_SQL_Running']/text()` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
Zabbix_raw_items	MySQL: Get status variables	The item gets server global status information.	ZABBIX_PASSIVE	mysql.get_status_variables["{$MYSQL.HOST}","{$MYSQL.PORT}"]
Zabbix_raw_items	MySQL: InnoDB buffer pool read requests	The number of logical read requests.	DEPENDENT	mysql.innodb_buffer_pool_read_requests Preprocessing: - XMLPATH: `/resultset/row[field/text()='Innodb_buffer_pool_read_requests']/field[@name='Value']/text()`
Zabbix_raw_items	MySQL: InnoDB buffer pool reads	The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.	DEPENDENT	mysql.innodb_buffer_pool_reads Preprocessing: - XMLPATH: `/resultset/row[field/text()='Innodb_buffer_pool_reads']/field[@name='Value']/text()`
Zabbix_raw_items	MySQL: Replication Slave status {#MASTERHOST}	The item gets status information on essential parameters of the slave threads.	ZABBIX_PASSIVE	mysql.slave_status["{$MYSQL.HOST}","{$MYSQL.PORT}","{#MASTERHOST}"]

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
MySQL: Service is down		`{TEMPLATE_NAME:mysql.ping["{$MYSQL.HOST}","{$MYSQL.PORT}"].last()}=0`	HIGH
MySQL: Version has changed (new version value received: {ITEM.VALUE})	MySQL version has changed. Ack to close.	`{TEMPLATE_NAME:mysql.version["{$MYSQL.HOST}","{$MYSQL.PORT}"].diff()}=1 and {TEMPLATE_NAME:mysql.version["{$MYSQL.HOST}","{$MYSQL.PORT}"].strlen()}>0`	INFO	Manual close: YES
MySQL: Service has been restarted (uptime < 10m)	MySQL uptime is less than 10 minutes.	`{TEMPLATE_NAME:mysql.uptime.last()}<10m`	INFO
MySQL: Server has aborted connections (over {$MYSQL.ABORTED_CONN.MAX.WARN} for 5m)	The number of failed attempts to connect to the MySQL server is more than {$MYSQL.ABORTED_CONN.MAX.WARN} in the last 5 minutes.	`{TEMPLATE_NAME:mysql.aborted_connects.rate.min(5m)}>{$MYSQL.ABORTED_CONN.MAX.WARN}`	AVERAGE	Depends on: - MySQL: Refused connections (max_connections limit reached)
MySQL: Refused connections (max_connections limit reached)	Number of refused connections due to the max_connections limit being reached.	`{TEMPLATE_NAME:mysql.connection_errors_max_connections.rate.last()}>0`	AVERAGE
MySQL: Buffer pool utilization is too low (less {$MYSQL.BUFF_UTIL.MIN.WARN}% for 5m)	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.	`{TEMPLATE_NAME:mysql.buffer_pool_utilization.max(5m)}<{$MYSQL.BUFF_UTIL.MIN.WARN}`	WARNING
MySQL: Server has slow queries (over {$MYSQL.SLOW_QUERIES.MAX.WARN} for 5m)	The number of slow queries is more than {$MYSQL.SLOW_QUERIES.MAX.WARN} in the last 5 minutes.	`{TEMPLATE_NAME:mysql.slow_queries.rate.min(5m)}>{$MYSQL.SLOW_QUERIES.MAX.WARN}`	WARNING
MySQL: Replication lag is too high (over {$MYSQL.REPL_LAG.MAX.WARN} for 5m)	-	`{TEMPLATE_NAME:mysql.seconds_behind_master["{#MASTERHOST}"].min(5m)}>{$MYSQL.REPL_LAG.MAX.WARN}`	WARNING
MySQL: The slave I/O thread is not running	Whether the I/O thread for reading the master's binary log is running.	`{TEMPLATE_NAME:mysql.slave_io_running["{#MASTERHOST}"].count(#1,"No",eq)}=1`	AVERAGE
MySQL: The slave I/O thread is not connected to a replication master	-	`{TEMPLATE_NAME:mysql.slave_io_running["{#MASTERHOST}"].count(#1,"Yes",ne)}=1`	WARNING	Depends on: - MySQL: The slave I/O thread is not running
MySQL: The SQL thread is not running	Whether the SQL thread for executing events in the relay log is running.	`{TEMPLATE_NAME:mysql.slave_sql_running["{#MASTERHOST}"].count(#1,"No",eq)}=1`	WARNING	Depends on: - MySQL: The slave I/O thread is not running
MySQL: Failed to get items (no data for 30m)	Zabbix has not received data for items for the last 30 minutes.	`{TEMPLATE_NAME:mysql.get_status_variables["{$MYSQL.HOST}","{$MYSQL.PORT}"].nodata(30m)}=1`	WARNING	Depends on: - MySQL: Service is down

Feedback

Please report any issues with the template at https://support.zabbix.com

You can also provide feedback, discuss the template or ask for help with it at ZABBIX forums.

Source: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mysql_agent2

Template DB MySQL by Zabbix agent 2

Overview

For Zabbix version: 5.0
The template is developed for monitoring DBMS MySQL and its forks.

This template was tested on:

MySQL, version 5.7, 8.0
Percona, version 8.0
MariaDB, version 10.4
Zabbix, version 5.0

Setup

See Zabbix template operation for basic instructions.

Create MySQL user for monitoring (<password> at your discretion):

CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '<password>';
GRANT USAGE,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

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.
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.

Zabbix configuration

No specific Zabbix configuration is required.

Macros used

Name	Description	Default
{$MYSQL.ABORTED_CONN.MAX.WARN}	The number of failed attempts to connect to the MySQL server for trigger expression.	`3`
{$MYSQL.BUFF_UTIL.MIN.WARN}	The minimum buffer pool utilization percentage for trigger expression.	`50`
{$MYSQL.CREATED_TMP_DISK_TABLES.MAX.WARN}	The maximum number of created tmp tables on a disk per second for trigger expressions.	`10`
{$MYSQL.CREATED_TMP_FILES.MAX.WARN}	The maximum number of created tmp files on a disk per second for trigger expressions.	`10`
{$MYSQL.CREATED_TMP_TABLES.MAX.WARN}	The maximum number of created tmp tables in memory per second for trigger expressions.	`30`
{$MYSQL.DSN}	System data source name such as <protocol(host:port or /path/to/socket)/>.	`<Put your DSN>`
{$MYSQL.PASSWORD}	MySQL user password.	``
{$MYSQL.REPL_LAG.MAX.WARN}	The lag of slave from master for trigger expression.	`30m`
{$MYSQL.SLOW_QUERIES.MAX.WARN}	The number of slow queries for trigger expression.	`3`
{$MYSQL.USER}	MySQL user name.	``

Template links

There are no template links in this template.

Discovery rules

Name Description Type Key and additional info

Databases discovery

Name	Description	Type	Key and additional info
Databases discovery	Scanning databases in DBMS.	ZABBIX_PASSIVE	mysql.db.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `1d` Filter: AND_OR - A: {#DATABASE} NOT_MATCHES_REGEX `information_schema`
Replication discovery	If "show slave status" returns Master_Host, "Replication: *" items are created.	ZABBIX_PASSIVE	mysql.replication.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `1d`

Scanning databases in DBMS.

ZABBIX_PASSIVE

mysql.db.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]

Preprocessing:

- DISCARD_UNCHANGED_HEARTBEAT: 1d

Filter:

AND_OR

- A: {#DATABASE} NOT_MATCHES_REGEX information_schema

Replication discovery

If "show slave status" returns Master_Host, "Replication: *" items are created.

ZABBIX_PASSIVE

mysql.replication.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]

Preprocessing:

- DISCARD_UNCHANGED_HEARTBEAT: 1d

Items collected

Group	Name	Description	Type	Key and additional info
MySQL	MySQL: Status		ZABBIX_PASSIVE	mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `10m`
MySQL	MySQL: Version		ZABBIX_PASSIVE	mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `1d`
MySQL	MySQL: Uptime	The number of seconds that the server has been up.	DEPENDENT	mysql.uptime Preprocessing: - JSONPATH: `$.Uptime`
MySQL	MySQL: Aborted clients per second	The number of connections that were aborted because the client died without closing the connection properly.	DEPENDENT	mysql.aborted_clients.rate Preprocessing: - JSONPATH: `$.Aborted_clients` - CHANGE_PER_SECOND
MySQL	MySQL: Aborted connections per second	The number of failed attempts to connect to the MySQL server.	DEPENDENT	mysql.aborted_connects.rate Preprocessing: - JSONPATH: `$.Aborted_connects` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors accept per second	Number of errors that occurred during calls to accept() on the listening port.	DEPENDENT	mysql.connection_errors_accept.rate Preprocessing: - JSONPATH: `$.Connection_errors_accept` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors internal per second	Number of refused connections due to internal server errors, for example out of memory errors, or failed thread starts.	DEPENDENT	mysql.connection_errors_internal.rate Preprocessing: - JSONPATH: `$.Connection_errors_internal` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors max connections per second	Number of refused connections due to the max_connections limit being reached.	DEPENDENT	mysql.connection_errors_max_connections.rate Preprocessing: - JSONPATH: `$.Connection_errors_max_connections` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors peer address per second	Number of errors while searching for the connecting client IP address.	DEPENDENT	mysql.connection_errors_peer_address.rate Preprocessing: - JSONPATH: `$.Connection_errors_peer_address` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors select per second	Number of errors during calls to select() or poll() on the listening port. The client would not necessarily have been rejected in these cases.	DEPENDENT	mysql.connection_errors_select.rate Preprocessing: - JSONPATH: `$.Connection_errors_select` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors tcpwrap per second	Number of connections the libwrap library refused.	DEPENDENT	mysql.connection_errors_tcpwrap.rate Preprocessing: - JSONPATH: `$.Connection_errors_tcpwrap` - CHANGE_PER_SECOND
MySQL	MySQL: Connections per second	The number of connection attempts (successful or not) to the MySQL server.	DEPENDENT	mysql.connections.rate Preprocessing: - JSONPATH: `$.Connections` - CHANGE_PER_SECOND
MySQL	MySQL: Max used connections	The maximum number of connections that have been in use simultaneously since the server started.	DEPENDENT	mysql.max_used_connections Preprocessing: - JSONPATH: `$.Max_used_connections` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Threads cached	The number of threads in the thread cache.	DEPENDENT	mysql.threads_cached Preprocessing: - JSONPATH: `$.Threads_cached`
MySQL	MySQL: Threads connected	The number of currently open connections.	DEPENDENT	mysql.threads_connected Preprocessing: - JSONPATH: `$.Threads_connected`
MySQL	MySQL: Threads created per second	The 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.	DEPENDENT	mysql.threads_created.rate Preprocessing: - JSONPATH: `$.Threads_created` - CHANGE_PER_SECOND
MySQL	MySQL: Threads running	The number of threads that are not sleeping.	DEPENDENT	mysql.threads_running Preprocessing: - JSONPATH: `$.Threads_running`
MySQL	MySQL: Buffer pool efficiency	The item shows how effectively the buffer pool is serving reads.	CALCULATED	mysql.buffer_pool_efficiency Expression: `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 )`
MySQL	MySQL: Buffer pool utilization	Ratio of used to total pages in the buffer pool.	CALCULATED	mysql.buffer_pool_utilization Expression: `( 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 )`
MySQL	MySQL: Created tmp files on disk per second	How many temporary files mysqld has created.	DEPENDENT	mysql.created_tmp_files.rate Preprocessing: - JSONPATH: `$.Created_tmp_files` - CHANGE_PER_SECOND
MySQL	MySQL: Created tmp tables on disk per second	The number of internal on-disk temporary tables created by the server while executing statements.	DEPENDENT	mysql.created_tmp_disk_tables.rate Preprocessing: - JSONPATH: `$.Created_tmp_disk_tables` - CHANGE_PER_SECOND
MySQL	MySQL: Created tmp tables on memory per second	The number of internal temporary tables created by the server while executing statements.	DEPENDENT	mysql.created_tmp_tables.rate Preprocessing: - JSONPATH: `$.Created_tmp_tables` - CHANGE_PER_SECOND
MySQL	MySQL: InnoDB buffer pool pages free	The total size of the InnoDB buffer pool, in pages.	DEPENDENT	mysql.innodb_buffer_pool_pages_free Preprocessing: - JSONPATH: `$.Innodb_buffer_pool_pages_free`
MySQL	MySQL: InnoDB buffer pool pages total	The total size of the InnoDB buffer pool, in pages.	DEPENDENT	mysql.innodb_buffer_pool_pages_total Preprocessing: - JSONPATH: `$.Innodb_buffer_pool_pages_total` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: InnoDB buffer pool read requests per second	The number of logical read requests per second.	DEPENDENT	mysql.innodb_buffer_pool_read_requests.rate Preprocessing: - JSONPATH: `$.Innodb_buffer_pool_read_requests` - CHANGE_PER_SECOND
MySQL	MySQL: InnoDB buffer pool reads per second	The number of logical reads per second that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.	DEPENDENT	mysql.innodb_buffer_pool_reads.rate Preprocessing: - JSONPATH: `$.Innodb_buffer_pool_reads` - CHANGE_PER_SECOND
MySQL	MySQL: InnoDB row lock time	The total time spent in acquiring row locks for InnoDB tables, in milliseconds.	DEPENDENT	mysql.innodb_row_lock_time Preprocessing: - JSONPATH: `$.Innodb_row_lock_time` - MULTIPLIER: `0.001` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: InnoDB row lock time max	The maximum time to acquire a row lock for InnoDB tables, in milliseconds.	DEPENDENT	mysql.innodb_row_lock_time_max Preprocessing: - JSONPATH: `$.Innodb_row_lock_time_max` - MULTIPLIER: `0.001` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: InnoDB row lock waits	The number of times operations on InnoDB tables had to wait for a row lock.	DEPENDENT	mysql.innodb_row_lock_waits Preprocessing: - JSONPATH: `$.Innodb_row_lock_waits`
MySQL	MySQL: Slow queries per second	The number of queries that have taken more than long_query_time seconds.	DEPENDENT	mysql.slow_queries.rate Preprocessing: - JSONPATH: `$.Slow_queries` - CHANGE_PER_SECOND
MySQL	MySQL: Bytes received	The number of bytes received from all clients.	DEPENDENT	mysql.bytes_received.rate Preprocessing: - JSONPATH: `$.Bytes_received` - CHANGE_PER_SECOND
MySQL	MySQL: Bytes sent	The number of bytes sent to all clients.	DEPENDENT	mysql.bytes_sent.rate Preprocessing: - JSONPATH: `$.Bytes_sent` - CHANGE_PER_SECOND
MySQL	MySQL: Command Delete per second	The Com_delete counter variable indicates the number of times the delete statement has been executed.	DEPENDENT	mysql.com_delete.rate Preprocessing: - JSONPATH: `$.Com_delete` - CHANGE_PER_SECOND
MySQL	MySQL: Command Insert per second	The Com_insert counter variable indicates the number of times the insert statement has been executed.	DEPENDENT	mysql.com_insert.rate Preprocessing: - JSONPATH: `$.Com_insert` - CHANGE_PER_SECOND
MySQL	MySQL: Command Select per second	The Com_select counter variable indicates the number of times the select statement has been executed.	DEPENDENT	mysql.com_select.rate Preprocessing: - JSONPATH: `$.Com_select` - CHANGE_PER_SECOND
MySQL	MySQL: Command Update per second	The Com_update counter variable indicates the number of times the update statement has been executed.	DEPENDENT	mysql.com_update.rate Preprocessing: - JSONPATH: `$.Com_update` - CHANGE_PER_SECOND
MySQL	MySQL: Queries per second	The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable.	DEPENDENT	mysql.queries.rate Preprocessing: - JSONPATH: `$.Queries` - CHANGE_PER_SECOND
MySQL	MySQL: Questions per second	The 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.	DEPENDENT	mysql.questions.rate Preprocessing: - JSONPATH: `$.Questions` - CHANGE_PER_SECOND
MySQL	MySQL: Size of database {#DATABASE}	-	ZABBIX_PASSIVE	mysql.db.size["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}","{#DATABASE}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Replication Seconds Behind Master {#MASTER_HOST}	The 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.	DEPENDENT	mysql.replication.seconds_behind_master["{#MASTER_HOST}"] Preprocessing: - JSONPATH: `$.Seconds_Behind_Master` - MATCHES_REGEX: `\d+` ⛔️ON_FAIL: `CUSTOM_ERROR -> Replication is not performed.` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Replication Slave IO Running {#MASTER_HOST}	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 replication or have explicitly stopped it with STOP SLAVE.	DEPENDENT	mysql.replication.slave_io_running["{#MASTER_HOST}"] Preprocessing: - JSONPATH: `$.Slave_IO_Running` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Replication Slave SQL Running {#MASTER_HOST}	Whether the SQL thread for executing events in the relay log is running. As with the I/O thread, this should normally be Yes.	DEPENDENT	mysql.replication.slave_sql_running["{#MASTER_HOST}"] Preprocessing: - JSONPATH: `$.Slave_SQL_Running` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
Zabbix_raw_items	MySQL: Get status variables	The item gets server global status information.	ZABBIX_PASSIVE	mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]
Zabbix_raw_items	MySQL: InnoDB buffer pool read requests	The number of logical read requests.	DEPENDENT	mysql.innodb_buffer_pool_read_requests Preprocessing: - JSONPATH: `$.Innodb_buffer_pool_read_requests`
Zabbix_raw_items	MySQL: InnoDB buffer pool reads	The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.	DEPENDENT	mysql.innodb_buffer_pool_reads Preprocessing: - JSONPATH: `$.Innodb_buffer_pool_reads`
Zabbix_raw_items	MySQL: Replication Slave status {#MASTER_HOST}	The item gets status information on essential parameters of the slave threads.	ZABBIX_PASSIVE	mysql.replication.get_slave_status["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}","{#MASTER_HOST}"]

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
MySQL: Service is down		`{TEMPLATE_NAME:mysql.ping["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"].last()}=0`	HIGH
MySQL: Version has changed (new version value received: {ITEM.VALUE})	MySQL version has changed. Ack to close.	`{TEMPLATE_NAME:mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"].diff()}=1 and {TEMPLATE_NAME:mysql.version["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"].strlen()}>0`	INFO	Manual close: YES
MySQL: Service has been restarted (uptime < 10m)	MySQL uptime is less than 10 minutes.	`{TEMPLATE_NAME:mysql.uptime.last()}<10m`	INFO
MySQL: Failed to fetch info data (or no data for 30m)	Zabbix has not received data for items for the last 30 minutes.	`{TEMPLATE_NAME:mysql.uptime.nodata(30m)}=1`	INFO	Depends on: - MySQL: Service is down
MySQL: Server has aborted connections (over {$MYSQL.ABORTED_CONN.MAX.WARN} for 5m)	The number of failed attempts to connect to the MySQL server is more than {$MYSQL.ABORTED_CONN.MAX.WARN} in the last 5 minutes.	`{TEMPLATE_NAME:mysql.aborted_connects.rate.min(5m)}>{$MYSQL.ABORTED_CONN.MAX.WARN}`	AVERAGE	Depends on: - MySQL: Refused connections (max_connections limit reached)
MySQL: Refused connections (max_connections limit reached)	Number of refused connections due to the max_connections limit being reached.	`{TEMPLATE_NAME:mysql.connection_errors_max_connections.rate.last()}>0`	AVERAGE
MySQL: Buffer pool utilization is too low (less {$MYSQL.BUFF_UTIL.MIN.WARN}% for 5m)	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.	`{TEMPLATE_NAME:mysql.buffer_pool_utilization.max(5m)}<{$MYSQL.BUFF_UTIL.MIN.WARN}`	WARNING
MySQL: Number of temporary files created per second is high (over {$MYSQL.CREATED_TMP_FILES.MAX.WARN} for 5m)	Possibly the application using the database is in need of query optimization.	`{TEMPLATE_NAME:mysql.created_tmp_files.rate.min(5m)}>{$MYSQL.CREATED_TMP_FILES.MAX.WARN}`	WARNING
MySQL: Number of on-disk temporary tables created per second is high (over {$MYSQL.CREATED_TMP_DISK_TABLES.MAX.WARN} for 5m)	Possibly the application using the database is in need of query optimization.	`{TEMPLATE_NAME:mysql.created_tmp_disk_tables.rate.min(5m)}>{$MYSQL.CREATED_TMP_DISK_TABLES.MAX.WARN}`	WARNING
MySQL: Number of internal temporary tables created per second is high (over {$MYSQL.CREATED_TMP_TABLES.MAX.WARN} for 5m)	Possibly the application using the database is in need of query optimization.	`{TEMPLATE_NAME:mysql.created_tmp_tables.rate.min(5m)}>{$MYSQL.CREATED_TMP_TABLES.MAX.WARN}`	WARNING
MySQL: Server has slow queries (over {$MYSQL.SLOW_QUERIES.MAX.WARN} for 5m)	The number of slow queries is more than {$MYSQL.SLOW_QUERIES.MAX.WARN} in the last 5 minutes.	`{TEMPLATE_NAME:mysql.slow_queries.rate.min(5m)}>{$MYSQL.SLOW_QUERIES.MAX.WARN}`	WARNING
MySQL: Replication lag is too high (over {$MYSQL.REPL_LAG.MAX.WARN} for 5m)	-	`{TEMPLATE_NAME:mysql.replication.seconds_behind_master["{#MASTER_HOST}"].min(5m)}>{$MYSQL.REPL_LAG.MAX.WARN}`	WARNING
MySQL: The slave I/O thread is not running	Whether the I/O thread for reading the master's binary log is running.	`{TEMPLATE_NAME:mysql.replication.slave_io_running["{#MASTER_HOST}"].count(#1,"No",eq)}=1`	AVERAGE
MySQL: The slave I/O thread is not connected to a replication master	-	`{TEMPLATE_NAME:mysql.replication.slave_io_running["{#MASTER_HOST}"].count(#1,"Yes",ne)}=1`	WARNING	Depends on: - MySQL: The slave I/O thread is not running
MySQL: The SQL thread is not running	Whether the SQL thread for executing events in the relay log is running.	`{TEMPLATE_NAME:mysql.replication.slave_sql_running["{#MASTER_HOST}"].count(#1,"No",eq)}=1`	WARNING	Depends on: - MySQL: The slave I/O thread is not running

Feedback

Please report any issues with the template at https://support.zabbix.com

You can also provide a feedback, discuss the template or ask for help with it at ZABBIX forums.

Source: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mysql_odbc

Template DB MySQL by ODBC

Overview

For Zabbix version: 4.4
The template is developed for monitoring DBMS MySQL and its forks.

This template was tested on:

MySQL, version 5.7, 8.0
Percona, version 8.0
MariaDB, version 10.4
Zabbix, version 4.4.0

Setup

Create MySQL user for monitoring (<password> at your discretion):

CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '<password>';
GRANT USAGE,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

Set the user name and password in host macros ({$MYSQL.USER} and {$MYSQL.PASSWORD}).

Zabbix configuration

No specific Zabbix configuration is required.

Macros used

Name	Description	Default
{$MYSQL.ABORTED_CONN.MAX.WARN}	The number of failed attempts to connect to the MySQL server for trigger expression.	`3`
{$MYSQL.BUFF_UTIL.MIN.WARN}	The minimum buffer pool utilization in percent for trigger expression.	`50`
{$MYSQL.DSN}	System data source name.	`<Put your DSN here>`
{$MYSQL.PASSWORD}	MySQL user password.	`<Put your password here>`
{$MYSQL.REPL_LAG.MAX.WARN}	The lag of slave from master for trigger expression.	`30m`
{$MYSQL.SLOW_QUERIES.MAX.WARN}	The number of slow queries for trigger expression.	`3`
{$MYSQL.USER}	MySQL username.	`<Put your username here>`

Template links

There are no template links in this template.

Discovery rules

Name Description Type Key and additional info

Databases discovery

Name	Description	Type	Key and additional info
Databases discovery	Scanning databases in DBMS.	ODBC	db.odbc.discovery[databases,"{$MYSQL.DSN}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `1d` Filter: AND_OR - A: {#DATABASE} NOT_MATCHES_REGEX `information_schema`
Replication discovery	If "show slave status" returns Master_Host, "Replication: *" items are created.	ODBC	db.odbc.discovery[replication,"{$MYSQL.DSN}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `1d`

Scanning databases in DBMS.

ODBC

db.odbc.discovery[databases,"{$MYSQL.DSN}"]

Preprocessing:

- DISCARD_UNCHANGED_HEARTBEAT: 1d

Filter:

AND_OR

- A: {#DATABASE} NOT_MATCHES_REGEX information_schema

Replication discovery

If "show slave status" returns Master_Host, "Replication: *" items are created.

ODBC

db.odbc.discovery[replication,"{$MYSQL.DSN}"]

Preprocessing:

- DISCARD_UNCHANGED_HEARTBEAT: 1d

Items collected

Group	Name	Description	Type	Key and additional info
MySQL	MySQL: Status		ODBC	db.odbc.select[ping,"{$MYSQL.DSN}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `10m` Expression: `select "1"`
MySQL	MySQL: Version		ODBC	db.odbc.select[version,"{$MYSQL.DSN}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `1d` Expression: `select version()`
MySQL	MySQL: Uptime	The number of seconds that the server has been up.	DEPENDENT	mysql.uptime Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Uptime')].Value.first()`
MySQL	MySQL: Aborted clients per second	The number of connections that were aborted because the client died without closing the connection properly.	DEPENDENT	mysql.aborted_clients.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Aborted_clients')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Aborted connections per second	The number of failed attempts to connect to the MySQL server.	DEPENDENT	mysql.aborted_connects.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Aborted_connects')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors accept per second	Number of errors that occurred during calls to accept() on the listening port.	DEPENDENT	mysql.connection_errors_accept.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Connection_errors_accept')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors internal per second	Number of refused connections due to internal server errors, for example out of memory errors, or failed thread starts.	DEPENDENT	mysql.connection_errors_internal.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Connection_errors_internal')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors max connections per second	Number of refused connections due to the max_connections limit being reached.	DEPENDENT	mysql.connection_errors_max_connections.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Connection_errors_max_connections')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors peer address per second	Number of errors while searching for the connecting client IP address.	DEPENDENT	mysql.connection_errors_peer_address.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Connection_errors_peer_address')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors select per second	Number of errors during calls to select() or poll() on the listening port. The client would not necessarily have been rejected in these cases.	DEPENDENT	mysql.connection_errors_select.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Connection_errors_select')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Connection errors tcpwrap per second	Number of connections the libwrap library refused.	DEPENDENT	mysql.connection_errors_tcpwrap.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Connection_errors_tcpwrap')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Connections per second	The number of connection attempts (successful or not) to the MySQL server.	DEPENDENT	mysql.connections.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Connections')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Max used connections	The maximum number of connections that have been in use simultaneously since the server started.	DEPENDENT	mysql.max_used_connections Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Max_used_connections')].Value.first()` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Threads cached	The number of threads in the thread cache.	DEPENDENT	mysql.threads_cached Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Threads_cached')].Value.first()`
MySQL	MySQL: Threads connected	The number of currently open connections.	DEPENDENT	mysql.threads_connected Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Threads_connected')].Value.first()`
MySQL	MySQL: Threads created	The 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.	DEPENDENT	mysql.threads_created Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Threads_created')].Value.first()`
MySQL	MySQL: Threads running	The number of threads that are not sleeping.	DEPENDENT	mysql.threads_running Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Threads_running')].Value.first()`
MySQL	MySQL: Buffer pool efficiency	The item shows how effectively the buffer pool is serving reads.	CALCULATED	mysql.buffer_pool_efficiency Expression: `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 )`
MySQL	MySQL: Buffer pool utilization	Ratio of used to total pages in the buffer pool.	CALCULATED	mysql.buffer_pool_utilization Expression: `( 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 )`
MySQL	MySQL: Created tmp files on disk	How many temporary files mysqld has created.	DEPENDENT	mysql.created_tmp_files Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Created_tmp_files')].Value.first()`
MySQL	MySQL: Created tmp tables on disk	The number of internal on-disk temporary tables created by the server while executing statements.	DEPENDENT	mysql.created_tmp_disk_tables Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Created_tmp_disk_tables')].Value.first()`
MySQL	MySQL: Created tmp tables on memory	The number of internal temporary tables created by the server while executing statements.	DEPENDENT	mysql.created_tmp_tables Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Created_tmp_tables')].Value.first()`
MySQL	MySQL: InnoDB buffer pool pages free	The total size of the InnoDB buffer pool, in pages.	DEPENDENT	mysql.innodb_buffer_pool_pages_free Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Innodb_buffer_pool_pages_free')].Value.first()`
MySQL	MySQL: InnoDB buffer pool pages total	The total size of the InnoDB buffer pool, in pages.	DEPENDENT	mysql.innodb_buffer_pool_pages_total Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Innodb_buffer_pool_pages_total')].Value.first()` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: InnoDB buffer pool read requests per second	The number of logical read requests per second.	DEPENDENT	mysql.innodb_buffer_pool_read_requests.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Innodb_buffer_pool_read_requests')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: InnoDB buffer pool reads per second	The number of logical reads per second that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.	DEPENDENT	mysql.innodb_buffer_pool_reads.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Innodb_buffer_pool_reads')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: InnoDB row lock time	The total time spent in acquiring row locks for InnoDB tables, in milliseconds.	DEPENDENT	mysql.innodb_row_lock_time Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Innodb_row_lock_time')].Value.first()` - MULTIPLIER: `0.001` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: InnoDB row lock time max	The maximum time to acquire a row lock for InnoDB tables, in milliseconds.	DEPENDENT	mysql.innodb_row_lock_time_max Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Innodb_row_lock_time_max')].Value.first()` - MULTIPLIER: `0.001` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: InnoDB row lock waits	The number of times operations on InnoDB tables had to wait for a row lock.	DEPENDENT	mysql.innodb_row_lock_waits Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Innodb_row_lock_waits')].Value.first()`
MySQL	MySQL: Slow queries per second	The number of queries that have taken more than long_query_time seconds.	DEPENDENT	mysql.slow_queries.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Slow_queries')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Bytes received	The number of bytes received from all clients.	DEPENDENT	mysql.bytes_received.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Bytes_received')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Bytes sent	The number of bytes sent to all clients.	DEPENDENT	mysql.bytes_sent.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Bytes_sent')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Command Delete per second	The Com_delete counter variable indicates the number of times the delete statement has been executed.	DEPENDENT	mysql.com_delete.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Com_delete')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Command Insert per second	The Com_insert counter variable indicates the number of times the insert statement has been executed.	DEPENDENT	mysql.com_insert.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Com_insert')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Command Select per second	The Com_select counter variable indicates the number of times the select statement has been executed.	DEPENDENT	mysql.com_select.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Com_select')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Command Update per second	The Com_update counter variable indicates the number of times the update statement has been executed.	DEPENDENT	mysql.com_update.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Com_update')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Queries per second	The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable.	DEPENDENT	mysql.queries.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Queries')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Questions per second	The 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.	DEPENDENT	mysql.questions.rate Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Questions')].Value.first()` - CHANGE_PER_SECOND
MySQL	MySQL: Size of database {#DATABASE}	-	ODBC	db.odbc.select[{#DATABASE}_size,"{$MYSQL.DSN}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `1h` Expression: `SELECT SUM(DATA_LENGTH + INDEX_LENGTH) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="{#DATABASE}"`
MySQL	MySQL: Replication Seconds Behind Master {#MASTER_HOST}	The 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.	DEPENDENT	mysql.seconds_behind_master["{#MASTER_HOST}"] Preprocessing: - JSONPATH: `$.[?(@.Master_Host=='{#MASTER_HOST}')]['Seconds_Behind_Master'].first()` - MATCHES_REGEX: `\d+` ⛔️ON_FAIL: `CUSTOM_ERROR -> Replication is not performed.` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Replication Slave IO Running {#MASTER_HOST}	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 replication or have explicitly stopped it with STOP SLAVE.	DEPENDENT	mysql.slave_io_running["{#MASTER_HOST}"] Preprocessing: - JSONPATH: `$.[?(@.Master_Host=='{#MASTER_HOST}')]['Slave_IO_Running'].first()` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
MySQL	MySQL: Replication Slave SQL Running {#MASTER_HOST}	Whether the SQL thread for executing events in the relay log is running. As with the I/O thread, this should normally be Yes.	DEPENDENT	mysql.slave_sql_running["{#MASTER_HOST}"] Preprocessing: - JSONPATH: `$.[?(@.Master_Host=='{#MASTER_HOST}')]['Slave_SQL_Running'].first()` - DISCARD_UNCHANGED_HEARTBEAT: `1h`
Zabbix_raw_items	MySQL: Get status variables	The item gets server global status information.	ODBC	db.odbc.get[get_status_variables,"{$MYSQL.DSN}"] Expression: `show global status`
Zabbix_raw_items	MySQL: InnoDB buffer pool read requests	The number of logical read requests.	DEPENDENT	mysql.innodb_buffer_pool_read_requests Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Innodb_buffer_pool_read_requests')].Value.first()`
Zabbix_raw_items	MySQL: InnoDB buffer pool reads	The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.	DEPENDENT	mysql.innodb_buffer_pool_reads Preprocessing: - JSONPATH: `$[?(@.Variable_name=='Innodb_buffer_pool_reads')].Value.first()`
Zabbix_raw_items	MySQL: Replication Slave status {#MASTER_HOST}	The item gets status information on essential parameters of the slave threads.	ODBC	db.odbc.get["{#MASTER_HOST}","{$MYSQL.DSN}"] Expression: `show slave status`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
MySQL: Service is down		`{TEMPLATE_NAME:db.odbc.select[ping,"{$MYSQL.DSN}"].last()}=0`	HIGH
MySQL: Version has changed (new version value received: {ITEM.VALUE})	MySQL version has changed. Ack to close.	`{TEMPLATE_NAME:db.odbc.select[version,"{$MYSQL.DSN}"].diff()}=1 and {TEMPLATE_NAME:db.odbc.select[version,"{$MYSQL.DSN}"].strlen()}>0`	INFO	Manual close: YES
MySQL: Service has been restarted (uptime < 10m)	MySQL uptime is less than 10 minutes.	`{TEMPLATE_NAME:mysql.uptime.last()}<10m`	INFO
MySQL: Server has aborted connections (over {$MYSQL.ABORTED_CONN.MAX.WARN} for 5m)	The number of failed attempts to connect to the MySQL server is more than {$MYSQL.ABORTED_CONN.MAX.WARN} in the last 5 minutes.	`{TEMPLATE_NAME:mysql.aborted_connects.rate.min(5m)}>{$MYSQL.ABORTED_CONN.MAX.WARN}`	AVERAGE	Depends on: - MySQL: Refused connections (max_connections limit reached)
MySQL: Refused connections (max_connections limit reached)	Number of refused connections due to the max_connections limit being reached.	`{TEMPLATE_NAME:mysql.connection_errors_max_connections.rate.last()}>0`	AVERAGE
MySQL: Buffer pool utilization is too low (less {$MYSQL.BUFF_UTIL.MIN.WARN}% for 5m)	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.	`{TEMPLATE_NAME:mysql.buffer_pool_utilization.max(5m)}<{$MYSQL.BUFF_UTIL.MIN.WARN}`	WARNING
MySQL: Server has slow queries (over {$MYSQL.SLOW_QUERIES.MAX.WARN} for 5m)	The number of slow queries is more than {$MYSQL.SLOW_QUERIES.MAX.WARN} in the last 5 minutes.	`{TEMPLATE_NAME:mysql.slow_queries.rate.min(5m)}>{$MYSQL.SLOW_QUERIES.MAX.WARN}`	WARNING
MySQL: Replication lag is too high (over {$MYSQL.REPL_LAG.MAX.WARN} for 5m)	-	`{TEMPLATE_NAME:mysql.seconds_behind_master["{#MASTER_HOST}"].min(5m)}>{$MYSQL.REPL_LAG.MAX.WARN}`	WARNING
MySQL: The slave I/O thread is not running	Whether the I/O thread for reading the master's binary log is running.	`{TEMPLATE_NAME:mysql.slave_io_running["{#MASTER_HOST}"].count(#1,"No",eq)}=1`	AVERAGE
MySQL: The slave I/O thread is not connected to a replication master	-	`{TEMPLATE_NAME:mysql.slave_io_running["{#MASTER_HOST}"].count(#1,"Yes",ne)}=1`	WARNING	Depends on: - MySQL: The slave I/O thread is not running
MySQL: The SQL thread is not running	Whether the SQL thread for executing events in the relay log is running.	`{TEMPLATE_NAME:mysql.slave_sql_running["{#MASTER_HOST}"].count(#1,"No",eq)}=1`	WARNING	Depends on: - MySQL: The slave I/O thread is not running
MySQL: Failed to get items (no data for 30m)	Zabbix has not received data for items for the last 30 minutes.	`{TEMPLATE_NAME:db.odbc.get[get_status_variables,"{$MYSQL.DSN}"].nodata(30m)}=1`	WARNING	Depends on: - MySQL: Service is down

Feedback

Please report any issues with the template at https://support.zabbix.com

You can also provide feedback, discuss the template or ask for help with it at ZABBIX forums.

Link	Source	Compatibility	Type, Technology	Created Updated	Rating
Template MySQL (800+ items) A huge template for monitoring MySQL without any triggers ✔ Zabbix Agent ✔ Zabbix Trapper share.zabbix.com/template-mysql-800-items	share.zabbix.com 14355 66	2.0	Template, External script perl	2015-08-19 5 y	Popular
Zabbix template for monitoring Galera cluster Template for monitoring a Galera Cluster running on Linux.Tested on RHEL and CentOS 7.Created using 3.2 but may work with lower versions.Add Value Mapping, import Template and copy userparamater file to client, and restart zabbix agent service. ✔ Zabbix Agent github.com/MogiePete/zabbix-galera-template share.zabbix.com/galera-cluster-monitoring	share.zabbix.com 1145 13	3.2		2017-08-04 3 y	Popular
MySQL-Monitoring-Proxy This tool can be utilized to gather behavioral measurement data or configuration data of MySQL servers in a efficient way. It can be used as an external check for the zabbix monitoring system. The benefit for using this tool is a very low overhead for gathering the measurements because this tool is written ... ✔ Custom Script github.com/scoopex/mysql_extend share.zabbix.com/mysql-extend	share.zabbix.com		External script C	2015-09-27 2 y
Mysql/Mariadb monitoring Yet another module for mysql monitoring Supports multiple instances and multi-master replication with low-level discovery Please, ensure that you are using mysqld that supports multi-source replication, e.g. mysql 5.7 or mariadb 10+ ✔ Zabbix Agent github.com/firaxis/mysql-monitoring share.zabbix.com/mysql-mariadb-monitoring	share.zabbix.com 5		Template	2016-09-11 4 y	Popular
Template MySQL Server Checks ✔ Low Level Discovery (LLD) ✔ SNMP Agent ✔ Custom Script github.com/kingofnerds/Zabbix-Templates/tree/master/MySQL-remoteCheck share.zabbix.com/mysql-server-checks	share.zabbix.com 1		External script perl	2015-08-19 5 y	Popular
MySQL Windows multiple instances monitoring Script and template for monitoring MySQL on windows ✔ Zabbix Agent share.zabbix.com/mysql-windows-multiple-instances-monitoring	share.zabbix.com 3491 2	3.4	Template	2018-06-21 2 y	Popular
Percona MySQL Monitoring The items are populated by polling Zabbix agent. There are predefined triggers available to use. There is a screen as a placeholder for all graphs. 300 sec. polling interval - like with Cacti, the existing PHP script is used to retrive and cache MySQL metrics except some trigger-specific items. Due to ... ✔ Zabbix Agent www.percona.com/doc/percona-monitoring-plugins/1.1/zabbix/index.html share.zabbix.com/percona-mysql-monitoring	share.zabbix.com 11		Template, External script php	2014-10-02 2020 y
Zabbix plugin to monitor RDBMS ZabbixDBA is fast, flexible, and continuously developing plugin to monitor your RDBMS. ZabbixDBA uses threading of DBI connections which is good for monitoring of multiple database instances simultaneously. Just configure it, run daemon and it will do all the job github.com/netrusov/ZabbixDBA	GitHub 66		Module, Template Perl	2015-06-29 1 m	Popular
Zabbix MySQL monitoring plugin (with LLD) Extensive monitoring plugin for MySQL, including operational status, metrics, command counters AND slave-to-master monitoring by comparing table checksums.The slave monitoring is implemented through an extensive use of the powerful low-level discovery features available in Zabbix. As a result, only what ... github.com/m4ce/zabbix-mysql	GitHub 34		Templates, External script bash	2015-02-19 11 m	Popular
Extension for monitoring mysql Zabbix extension for monitoring mysql, written on Go github.com/zarplata/zabbix-agent-extension-mysql	GitHub 22		Template, External script Go	2018-04-10 3 m	Popular
Mysql monitoring template Template with mysql replication monitoring github.com/sergiotocalini/mysbix	GitHub 5		Template, External script ksh	2018-03-20 1 y
Docker image for mysql This container provides a mysql instance.It's designed to be used in conjunction with other containers and data-only containers and provides only 1 process: mysqld_safe.The idea is to use this container with docker-zabbix-server and docker-zabbix-web to form a working Zabbix installation, following the ... github.com/dkanbier/docker-zabbix-mysql	GitHub 4		container docker	2014-09-18 6 m

+ Propose new solution

Zabbix + Mysql

Mysql

Available solutions

Template DB MySQL by Zabbix agent

Overview

Setup

Zabbix configuration

Macros used

Template links

Discovery rules

Items collected

Triggers

Feedback

Template DB MySQL by Zabbix agent 2

Overview

Setup

Zabbix configuration

Macros used

Template links

Discovery rules

Items collected

Triggers

Feedback

Template DB MySQL by ODBC

Overview

Setup

Zabbix configuration

Macros used

Template links

Discovery rules

Items collected

Triggers

Feedback

Articles and documentation

Media