Available solutions
MariaDB by Zabbix agent
Overview
This template is designed for the effortless deployment of MariaDB monitoring by Zabbix via Zabbix agent and doesn't require any external scripts.
Requirements
Zabbix version: 8.0 and higher.
Tested versions
This template has been tested on:
- MariaDB 10.6, 11.8, 12.1.2, 12.3.2
Configuration
Zabbix should be configured according to the instructions in the Templates out of the box section.
Setup
- Install Zabbix agent and MariaDB client. If necessary, add the path to the 'mariadb' and 'mariadb-admin' utilities to the global environment variable PATH.
- Copy the
template_db_mariadb.conffile with user parameters into folder with Zabbix agent configuration (/etc/zabbix/zabbix_agentd.d/ by default). Don't forget to restart Zabbix agent. - Create the MariaDB user that will be used for monitoring (
<password>at your discretion). For example:
CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '<password>';
GRANT SLAVE MONITOR, PROCESS, SHOW DATABASES, SHOW VIEW ON *.* TO 'zbx_monitor'@'%';
For more information, please see MariaDB documentation.
- Create
.my.cnfconfiguration file in the home directory of Zabbix agent for Linux distributions (/var/lib/zabbix by default) ormy.cnfin c:\ for Windows. For example:
[client]
protocol=tcp
user='zbx_monitor'
password='<password>'
For more information, please see MariaDB documentation.
NOTE: Linux distributions that use SELinux may require additional steps for access configuration.
For example, the following rule could be added to the SELinux policy:
# cat <<EOF > zabbix_home.te
module zabbix_home 1.0;
require {
type zabbix_agent_t;
type zabbix_var_lib_t;
type mysqld_etc_t;
type mysqld_port_t;
type mysqld_var_run_t;
class file { open read };
class tcp_socket name_connect;
class sock_file write;
}
#============= zabbix_agent_t ==============
allow zabbix_agent_t zabbix_var_lib_t:file read;
allow zabbix_agent_t zabbix_var_lib_t:file open;
allow zabbix_agent_t mysqld_etc_t:file read;
allow zabbix_agent_t mysqld_port_t:tcp_socket name_connect;
allow zabbix_agent_t mysqld_var_run_t:sock_file write;
EOF
# checkmodule -M -m -o zabbix_home.mod zabbix_home.te
# semodule_package -o zabbix_home.pp -m zabbix_home.mod
# semodule -i zabbix_home.pp
# restorecon -R /var/lib/zabbix
Optionally, it is possible to customize the template:
- The discovery of tables is disabled by default. To enable table discovery, change the value of the macro
{$MARIADB.TABLE.NAMES.MATCHES}to the name of a single table, or use a regex string to include multiple tables. - You can also add an additional context macro
{$MARIADB.TABLE.NAMES.MATCHES:<dbname>}for specific databases to precisely control which tables should be discovered. - To exclude certain tables from discovery, change the value of the macro
{$MARIADB.TABLE.NAMES.NOT_MATCHES}to the name of a single table, or use a regex string to exclude multiple tables. - You can also add an additional context macro
{$MARIADB.TABLE.NAMES.NOT_MATCHES:<dbname>}for specific databases to precisely control which tables should be excluded.
Macros used
| Name | Description | Default |
|---|---|---|
| {$MARIADB.HOST} | Hostname or IP of MariaDB host or container. |
127.0.0.1 |
| {$MARIADB.PORT} | MariaDB service port. |
3306 |
| {$MARIADB.ABORTED_CONN.MAX.WARN} | Number of failed attempts to connect to the MariaDB server for trigger expressions. |
3 |
| {$MARIADB.REPL_LAG.MAX.WARN} | Amount of time the replica is behind the source for trigger expressions. |
30m |
| {$MARIADB.SLOW_QUERIES.MAX.WARN} | Number of slow queries for trigger expressions. |
3 |
| {$MARIADB.FULLSCAN.RATIO.WARN} | Warning threshold for full table scan ratio. |
0.1 |
| {$MARIADB.FULLSCAN.SELECT_RATE.MIN.WARN} | The minimum |
5 |
| {$MARIADB.BUFF_UTIL.MIN.WARN} | The minimum buffer pool utilization in percent for trigger expressions. |
50 |
| {$MARIADB.CREATED_TMP_TABLES.MAX.WARN} | The maximum number of temporary tables created in memory per second for trigger expressions. |
30 |
| {$MARIADB.CREATED_TMP_DISK_TABLES.MAX.WARN} | The maximum number of temporary tables created on a disk per second for trigger expressions. |
10 |
| {$MARIADB.CREATED_TMP_FILES.MAX.WARN} | The maximum number of temporary files created on a disk per second for trigger expressions. |
10 |
| {$MARIADB.INNODB_LOG_FILES} | Number of physical files in the InnoDB redo log for calculating |
2 |
| {$MARIADB.DBNAME.MATCHES} | Filter of discoverable databases. |
.+ |
| {$MARIADB.DBNAME.NOT_MATCHES} | Filter to exclude discovered databases. |
information_schema|performance_schema|mariadb|sys |
| {$MARIADB.TABLE.NAMES.MATCHES} | Filter of discoverable tables. Use a context to change the filter of discoverable tables for a specific database. |
CHANGE_IF_NEEDED |
| {$MARIADB.TABLE.NAMES.NOT_MATCHES} | Filter to exclude discovered tables. Use a context to change the filter to exclude discovered tables for a specific database. |
CHANGE_IF_NEEDED |
| {$MARIADB.TOTALSIZE.GROWTH.MAX.WARN} | The warning threshold of the total table size growth for trigger expressions. |
300M |
| {$MARIADB.TOTALSIZE.GROWTH.MAX.CRIT} | The critical threshold of the total table size growth for trigger expressions. |
1G |
| {$MARIADB.FRAGMENTATION.WARN} | The free ratio threshold for warning fragmentation trigger expressions. |
0.3 |
| {$MARIADB.FRAGMENTATION.CRIT} | The free ratio threshold for critical fragmentation trigger expressions. |
0.6 |
| {$MARIADB.DATA_FREE.MIN.WARN} | The minimum |
1G |
| {$MARIADB.DATA_FREE.MIN.CRIT} | The minimum |
5G |
| {$MARIADB.TABLE_SIZE.MIN.WARN} | The minimum table size for warning fragmentation trigger expressions. |
3G |
| {$MARIADB.TABLE_SIZE.MIN.CRIT} | The minimum table size for critical fragmentation trigger expressions. |
10G |
Items
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Get status variables | Gets server global status information. |
Zabbix agent | mariadb.get_status_variables["{$MARIADB.HOST}","{$MARIADB.PORT}"] |
| Status | MariaDB server status. |
Zabbix agent | mariadb.ping["{$MARIADB.HOST}","{$MARIADB.PORT}"] Preprocessing
|
| Version | MariaDB server version. |
Zabbix agent | mariadb.version["{$MARIADB.HOST}","{$MARIADB.PORT}"] Preprocessing
|
| Uptime | Number of seconds that the server has been up. |
Dependent item | mariadb.uptime Preprocessing
|
| Aborted clients per second | Number of connections that were aborted because the client died without closing the connection properly. |
Dependent item | mariadb.aborted_clients.rate Preprocessing
|
| Aborted connections per second | Number of failed attempts to connect to the MariaDB server. |
Dependent item | mariadb.aborted_connects.rate Preprocessing
|
| Connection errors accept per second | Number of errors that occurred during calls to |
Dependent item | mariadb.connection_errors_accept.rate Preprocessing
|
| 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 item | mariadb.connection_errors_internal.rate Preprocessing
|
| Connection errors max connections per second | Number of refused connections due to the |
Dependent item | mariadb.connection_errors_max_connections.rate Preprocessing
|
| Connection errors peer address per second | Number of errors while searching for the connecting client's IP address. |
Dependent item | mariadb.connection_errors_peer_address.rate Preprocessing
|
| Connection errors select per second | Number of errors during calls to |
Dependent item | mariadb.connection_errors_select.rate Preprocessing
|
| Connection errors tcpwrap per second | Number of connections the libwrap library has refused. |
Dependent item | mariadb.connection_errors_tcpwrap.rate Preprocessing
|
| Connections per second | Number of connection attempts (successful or not) to the MariaDB server. |
Dependent item | mariadb.connections.rate Preprocessing
|
| Max used connections | The maximum number of connections that have been in use simultaneously since the server start. |
Dependent item | mariadb.max_used_connections Preprocessing
|
| Threads cached | Number of threads in the thread cache. |
Dependent item | mariadb.threads_cached Preprocessing
|
| Threads connected | Number of currently open connections. |
Dependent item | mariadb.threads_connected Preprocessing
|
| Threads created per second | Number of threads created to handle connections. If the value of |
Dependent item | mariadb.threads_created.rate Preprocessing
|
| Threads running | Number of threads that are not sleeping. |
Dependent item | mariadb.threads_running Preprocessing
|
| Buffer pool efficiency | Shows how effectively the buffer pool is serving reads. |
Calculated | mariadb.buffer_pool_efficiency |
| Buffer pool utilization | Ratio of used to total pages in the buffer pool. |
Calculated | mariadb.buffer_pool_utilization |
| Created tmp files on disk per second | How many temporary files |
Dependent item | mariadb.created_tmp_files.rate Preprocessing
|
| Created tmp tables on disk per second | Number of internal on-disk temporary tables created by the server while executing statements. |
Dependent item | mariadb.created_tmp_disk_tables.rate Preprocessing
|
| Created tmp tables in memory per second | Number of internal temporary tables created by the server while executing statements. |
Dependent item | mariadb.created_tmp_tables.rate Preprocessing
|
| InnoDB buffer pool pages free | The number of free pages in the InnoDB buffer pool. |
Dependent item | mariadb.innodb_buffer_pool_pages_free Preprocessing
|
| InnoDB buffer pool pages total | The total size of the InnoDB buffer pool, in pages. |
Dependent item | mariadb.innodb_buffer_pool_pages_total Preprocessing
|
| InnoDB buffer pool read requests | Number of logical read requests. |
Dependent item | mariadb.innodb_buffer_pool_read_requests Preprocessing
|
| InnoDB buffer pool read requests per second | Number of logical read requests per second. |
Dependent item | mariadb.innodb_buffer_pool_read_requests.rate Preprocessing
|
| InnoDB buffer pool reads | Number of logical reads that InnoDB could not satisfy from the buffer pool and had to read directly from the disk. |
Dependent item | mariadb.innodb_buffer_pool_reads Preprocessing
|
| InnoDB buffer pool reads per second | Number of logical reads per second that InnoDB could not satisfy from the buffer pool and had to read directly from the disk. |
Dependent item | mariadb.innodb_buffer_pool_reads.rate Preprocessing
|
| InnoDB log waits per second | Number of InnoDB log waits per second. An increase in this per-second value indicates that threads are increasingly waiting for redo log writes, which typically points to disk subsystem performance issues or an |
Dependent item | mariadb.innodb_log_waits.rate Preprocessing
|
| InnoDB row lock time | The total time spent in acquiring row locks for InnoDB tables. |
Dependent item | mariadb.innodb_row_lock_time Preprocessing
|
| InnoDB row lock wait time avg | Average time spent waiting for row locks in InnoDB. |
Dependent item | mariadb.innodb_row_lock_time_avg Preprocessing
|
| InnoDB row lock time max | The maximum time to acquire a row lock for InnoDB tables. |
Dependent item | mariadb.innodb_row_lock_time_max Preprocessing
|
| InnoDB row lock waits | Number of times operations on InnoDB tables had to wait for a row lock. |
Dependent item | mariadb.innodb_row_lock_waits Preprocessing
|
| InnoDB row lock current waits | Current number of active row lock waits in InnoDB. |
Dependent item | mariadb.innodb_row_lock_current_waits Preprocessing
|
| Slow queries per second | Number of queries that have taken more than |
Dependent item | mariadb.slow_queries.rate Preprocessing
|
| Bytes received | Number of bytes received from all clients. |
Dependent item | mariadb.bytes_received.rate Preprocessing
|
| Bytes sent | Number of bytes sent to all clients. |
Dependent item | mariadb.bytes_sent.rate Preprocessing
|
| Command delete per second | The |
Dependent item | mariadb.com_delete.rate Preprocessing
|
| Command insert per second | The |
Dependent item | mariadb.com_insert.rate Preprocessing
|
| Command select per second | The |
Dependent item | mariadb.com_select.rate Preprocessing
|
| Command update per second | The |
Dependent item | mariadb.com_update.rate Preprocessing
|
| Queries per second | Number of statements executed by the server. This variable includes statements executed within stored programs, unlike the |
Dependent item | mariadb.queries.rate Preprocessing
|
| Questions per second | 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 |
Dependent item | mariadb.questions.rate Preprocessing
|
| Binlog cache disk use | Number of transactions that used a temporary disk cache because they could not fit in the regular binary log cache, being larger than |
Dependent item | mariadb.binlog_cache_disk_use Preprocessing
|
| Select scan per second | The number of |
Dependent item | mariadb.select_scan.rate Preprocessing
|
| Full table scan ratio | The ratio of |
Calculated | mariadb.full_scans.ratio Preprocessing
|
| InnoDB buffer pool wait free | 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 number of waits for this operation to finish. If this value is not small, consider increasing |
Dependent item | mariadb.innodb_buffer_pool_wait_free Preprocessing
|
| InnoDB number open files | Number of open files held by InnoDB. InnoDB only. |
Dependent item | mariadb.innodb_num_open_files Preprocessing
|
| Open table definitions | Number of cached table definitions. |
Dependent item | mariadb.open_table_definitions Preprocessing
|
| Open tables | Number of tables that are open. |
Dependent item | mariadb.open_tables Preprocessing
|
| InnoDB log written | Number of bytes written to the InnoDB log. |
Dependent item | mariadb.innodb_os_log_written Preprocessing
|
| Calculated value of innodb_log_file_size |
|
Calculated | mariadb.innodb_log_file_size Preprocessing
|
| Binlog commits | Total number of transactions committed to the binary log. |
Dependent item | mariadb.binlog_commits Preprocessing
|
| Binlog group commits | Total number of group commits done to the binary log. |
Dependent item | mariadb.binlog_group_commits Preprocessing
|
| Master GTID wait count | The number of times |
Dependent item | mariadb.master_gtid_wait_count Preprocessing
|
| Master GTID wait time | Total time spent in |
Dependent item | mariadb.master_gtid_wait_time Preprocessing
|
| Master GTID wait timeouts | Number of timeouts occurring in |
Dependent item | mariadb.master_gtid_wait_timeouts Preprocessing
|
| Aria pagecache reads | Number of physical reads from disk to the Aria pagecache. |
Dependent item | mariadb.aria_pagecache_reads Preprocessing
|
| Aria pagecache reads per second | Number of physical reads from disk to the Aria pagecache per second. |
Dependent item | mariadb.aria_pagecache_reads.rate Preprocessing
|
| Aria pagecache read requests | Number of read requests issued to the Aria pagecache. |
Dependent item | mariadb.aria_pagecache_read_requests Preprocessing
|
| Aria pagecache read requests per second | Number of read requests issued to the Aria pagecache per second. |
Dependent item | mariadb.aria_pagecache_read_requests.rate Preprocessing
|
| Aria pagecache writes per second | Number of physical writes from Aria pagecache to disk per second. |
Dependent item | mariadb.aria_pagecache_writes.rate Preprocessing
|
| Aria pagecache write requests per second | Number of write requests issued to the Aria pagecache per second. |
Dependent item | mariadb.aria_pagecache_write_requests.rate Preprocessing
|
| Aria transaction log syncs per second | Number of Aria transaction log fsync operations per second. |
Dependent item | mariadb.aria_transaction_log_syncs.rate Preprocessing
|
| Aria pagecache blocks not flushed | Number of Aria pagecache blocks that contain modified data and have not yet been flushed to disk. |
Dependent item | mariadb.aria_pagecache_blocks_not_flushed Preprocessing
|
| Aria pagecache blocks unused | Number of currently free blocks in the Aria pagecache buffer. |
Dependent item | mariadb.aria_pagecache_blocks_unused Preprocessing
|
| Aria pagecache blocks used | Number of blocks currently in use in the Aria pagecache buffer. |
Dependent item | mariadb.aria_pagecache_blocks_used Preprocessing
|
| Aria pagecache hit rate | Percentage of Aria pagecache read requests served from cache (higher means fewer disk reads). |
Calculated | mariadb.aria_pagecache_hit_rate |
Triggers
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| MariaDB: Service is unreachable | MariaDB is unreachable. |
last(/MariaDB by Zabbix agent/mariadb.ping["{$MARIADB.HOST}","{$MARIADB.PORT}"])=0 |
High | |
| MariaDB: Version has changed | The MariaDB version has changed. Acknowledge to close the problem manually. |
last(/MariaDB by Zabbix agent/mariadb.version["{$MARIADB.HOST}","{$MARIADB.PORT}"],#1)<>last(/MariaDB by Zabbix agent/mariadb.version["{$MARIADB.HOST}","{$MARIADB.PORT}"],#2) and length(last(/MariaDB by Zabbix agent/mariadb.version["{$MARIADB.HOST}","{$MARIADB.PORT}"]))>0 |
Info | Manual close: Yes |
| MariaDB: Service has been restarted | MariaDB uptime is less than 10 minutes. |
last(/MariaDB by Zabbix agent/mariadb.uptime)<10m |
Info | |
| MariaDB: Failed to fetch data | Zabbix has not received any data for the last 30 minutes. |
nodata(/MariaDB by Zabbix agent/mariadb.uptime,30m)=1 |
Info | Depends on:
|
| MariaDB: Server has aborted connections | The number of failed attempts to connect to the MariaDB server has been more than |
min(/MariaDB by Zabbix agent/mariadb.aborted_connects.rate,5m)>{$MARIADB.ABORTED_CONN.MAX.WARN} |
Average | Depends on:
|
| MariaDB: Refused connections | Number of refused connections due to the |
last(/MariaDB by Zabbix agent/mariadb.connection_errors_max_connections.rate)>0 |
Average | |
| MariaDB: Buffer pool utilization is too low | The buffer pool utilization has been less than |
max(/MariaDB by Zabbix agent/mariadb.buffer_pool_utilization,5m)<{$MARIADB.BUFF_UTIL.MIN.WARN} and last(/MariaDB by Zabbix agent/mariadb.uptime)>3600 |
Warning | |
| MariaDB: Number of temporary files created per second is high | The application using the database may be in need of query optimization. |
min(/MariaDB by Zabbix agent/mariadb.created_tmp_files.rate,5m)>{$MARIADB.CREATED_TMP_FILES.MAX.WARN} |
Warning | |
| MariaDB: Number of on-disk temporary tables created per second is high | The application using the database may be in need of query optimization. |
min(/MariaDB by Zabbix agent/mariadb.created_tmp_disk_tables.rate,5m)>{$MARIADB.CREATED_TMP_DISK_TABLES.MAX.WARN} |
Warning | |
| MariaDB: Number of internal temporary tables created per second is high | The application using the database may be in need of query optimization. |
min(/MariaDB by Zabbix agent/mariadb.created_tmp_tables.rate,5m)>{$MARIADB.CREATED_TMP_TABLES.MAX.WARN} |
Warning | |
| MariaDB: Server has slow queries | The number of slow queries has been more than |
min(/MariaDB by Zabbix agent/mariadb.slow_queries.rate,5m)>{$MARIADB.SLOW_QUERIES.MAX.WARN} |
Warning | |
| MariaDB: High rate of full table scans | The rate of |
avg(/MariaDB by Zabbix agent/mariadb.full_scans.ratio,5m)>{$MARIADB.FULLSCAN.RATIO.WARN} and avg(/MariaDB by Zabbix agent/mariadb.com_select.rate,5m)>{$MARIADB.FULLSCAN.SELECT_RATE.MIN.WARN} |
Warning |
LLD rule Database discovery
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Database discovery | Used for the discovery of databases. |
Zabbix agent | mariadb.db.discovery["{$MARIADB.HOST}","{$MARIADB.PORT}"] Preprocessing
|
Item prototypes for Database discovery
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Database [{#DBNAME}]: Size | Database size. |
Zabbix agent | mariadb.dbsize["{$MARIADB.HOST}","{$MARIADB.PORT}","{#DBNAME}"] Preprocessing
|
LLD rule Database [{#DBNAME}]: Table discovery
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Database [{#DBNAME}]: Table discovery | Used for the discovery of tables of the databases. |
Zabbix agent | mariadb.table.discovery["{$MARIADB.HOST}","{$MARIADB.PORT}","{#DBNAME}"] Preprocessing
|
Item prototypes for Database [{#DBNAME}]: Table discovery
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Table [{#DBNAME}/{#TABLE_NAME}]: Get data | Database table data. |
Zabbix agent | mariadb.tabledata["{$MARIADB.HOST}","{$MARIADB.PORT}","{#DBNAME}","{#TABLE_NAME}"] |
| Table [{#DBNAME}/{#TABLE_NAME}]: Data length | The size of the data in the table. |
Dependent item | mariadb.table.data_length["{#DBNAME}","{#TABLE_NAME}"] Preprocessing
|
| Table [{#DBNAME}/{#TABLE_NAME}]: Index length | The size occupied by the table's indexes. |
Dependent item | mariadb.table.index_length["{#DBNAME}","{#TABLE_NAME}"] Preprocessing
|
| Table [{#DBNAME}/{#TABLE_NAME}]: Total size | The sum of |
Calculated | mariadb.table.total_size["{#DBNAME}","{#TABLE_NAME}"] Preprocessing
|
| Table [{#DBNAME}/{#TABLE_NAME}]: Data free | The amount of unused but allocated space. |
Dependent item | mariadb.table.data_free["{#DBNAME}","{#TABLE_NAME}"] Preprocessing
|
| Table [{#DBNAME}/{#TABLE_NAME}]: Free ratio | The fraction of allocated table space that is currently unused ( High values indicate potential table fragmentation or inefficient space usage. |
Calculated | mariadb.table.free_ratio["{#DBNAME}","{#TABLE_NAME}"] Preprocessing
|
| Table [{#DBNAME}/{#TABLE_NAME}]: Rows | The approximate number of rows in the table. For InnoDB, the |
Dependent item | mariadb.table.rows["{#DBNAME}","{#TABLE_NAME}"] Preprocessing
|
Trigger prototypes for Database [{#DBNAME}]: Table discovery
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| MariaDB: Table [{#DBNAME}/{#TABLE_NAME}]: Total size growth is too high | Total table size growth is too high. |
(last(/MariaDB by Zabbix agent/mariadb.table.total_size["{#DBNAME}","{#TABLE_NAME}"])-min(/MariaDB by Zabbix agent/mariadb.table.total_size["{#DBNAME}","{#TABLE_NAME}"],5m))>{$MARIADB.TOTALSIZE.GROWTH.MAX.CRIT} |
High | |
| MariaDB: Table [{#DBNAME}/{#TABLE_NAME}]: Total size growth is high | Total table size growth is high. |
(last(/MariaDB by Zabbix agent/mariadb.table.total_size["{#DBNAME}","{#TABLE_NAME}"])-min(/MariaDB by Zabbix agent/mariadb.table.total_size["{#DBNAME}","{#TABLE_NAME}"],5m))>{$MARIADB.TOTALSIZE.GROWTH.MAX.WARN} |
Warning | Depends on:
|
| MariaDB: Table [{#DBNAME}/{#TABLE_NAME}]: Free space very high | Free table space is very high (fragmentation critical). |
last(/MariaDB by Zabbix agent/mariadb.table.free_ratio["{#DBNAME}","{#TABLE_NAME}"]) > {$MARIADB.FRAGMENTATION.CRIT} and last(/MariaDB by Zabbix agent/mariadb.table.data_free["{#DBNAME}","{#TABLE_NAME}"]) > {$MARIADB.DATA_FREE.MIN.CRIT} and last(/MariaDB by Zabbix agent/mariadb.table.total_size["{#DBNAME}","{#TABLE_NAME}"]) > {$MARIADB.TABLE_SIZE.MIN.CRIT} |
High | |
| MariaDB: Table [{#DBNAME}/{#TABLE_NAME}]: Free space high | Free table space is high (fragmentation warning). |
last(/MariaDB by Zabbix agent/mariadb.table.free_ratio["{#DBNAME}","{#TABLE_NAME}"]) > {$MARIADB.FRAGMENTATION.WARN} and last(/MariaDB by Zabbix agent/mariadb.table.data_free["{#DBNAME}","{#TABLE_NAME}"]) > {$MARIADB.DATA_FREE.MIN.WARN} and last(/MariaDB by Zabbix agent/mariadb.table.total_size["{#DBNAME}","{#TABLE_NAME}"]) > {$MARIADB.TABLE_SIZE.MIN.WARN} |
Warning | Depends on:
|
LLD rule Replication discovery
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Replication discovery | Discovery of the replication. |
Zabbix agent | mariadb.replication.discovery["{$MARIADB.HOST}","{$MARIADB.PORT}"] Preprocessing
|
Item prototypes for Replication discovery
| Name | Description | Type | Key and additional info |
|---|---|---|---|
| Replication: Replica status {#MASTER_HOST} | Gets status information on the essential parameters of the replica threads. |
Zabbix agent | mariadb.slave_status["{$MARIADB.HOST}","{$MARIADB.PORT}","{#SQL_STATEMENT}"] Preprocessing
|
| Replication: Replica SQL running state {#MASTER_HOST} | Shows the state of the SQL thread. |
Dependent item | mariadb.slave_sql_running_state["{#MASTER_HOST}"] Preprocessing
|
| Replication: Seconds behind source {#MASTER_HOST} | The number of seconds the replica SQL thread has been behind processing the source binary log. A high number (or an increasing one) can indicate that the replica is unable to handle events from the source in a timely fashion. |
Dependent item | mariadb.seconds_behind_master["{#MASTER_HOST}"] Preprocessing
|
| Replication: Replica IO running {#MASTER_HOST} | Indicates whether the I/O thread for reading the source's binary log is running. Normally, you want this to be explicitly stopped it with |
Dependent item | mariadb.slave_io_running["{#MASTER_HOST}"] Preprocessing
|
| Replication: Replica SQL running {#MASTER_HOST} | Indicates whether the SQL thread for executing events in the relay log is running. As with the I/O thread, this should normally be |
Dependent item | mariadb.slave_sql_running["{#MASTER_HOST}"] Preprocessing
|
| Replication: Last IO error {#MASTER_HOST} | Describes the last I/O error message reported by the replica I/O thread that caused replication to stop or behave incorrectly. |
Dependent item | mariadb.slave_io_error["{#MASTER_HOST}"] Preprocessing
|
| Replication: Last SQL error {#MASTER_HOST} | Describes the last SQL error message reported by the replica SQL thread that caused replication to stop or behave incorrectly. |
Dependent item | mariadb.slave_sql_error["{#MASTER_HOST}"] Preprocessing
|
Trigger prototypes for Replication discovery
| Name | Description | Expression | Severity | Dependencies and additional info |
|---|---|---|---|---|
| MariaDB: Replication lag is too high | Replication delay is too long. |
min(/MariaDB by Zabbix agent/mariadb.seconds_behind_master["{#MASTER_HOST}"],5m)>{$MARIADB.REPL_LAG.MAX.WARN} |
Warning | |
| MariaDB: The replica I/O thread is not running | Indicates whether the I/O thread for reading the source's binary log is running. |
last(/MariaDB by Zabbix agent/mariadb.slave_io_running["{#MASTER_HOST}"])=2 |
Average | |
| MariaDB: The replica I/O thread is not connected to a replication source | Indicates whether the replica I/O thread is connected to the source. |
last(/MariaDB by Zabbix agent/mariadb.slave_io_running["{#MASTER_HOST}"])<>1 |
Warning | Depends on:
|
| MariaDB: The SQL thread is not running | Indicates whether the SQL thread for executing events in the relay log is running. |
last(/MariaDB by Zabbix agent/mariadb.slave_sql_running["{#MASTER_HOST}"])=2 |
Warning | Depends on:
|
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 at ZABBIX forums