Skip to main content
Version: 下一篇

Monitoring:MariaDB database monitoring

Collect and monitor the general performance indicators of MariaDB database. Support MariaDB5+.

Configuration parameter

Parameter nameParameter help description
Monitoring HostMonitored IPV4, IPV6 or domain name. Note⚠️Without protocol header (eg: https://, http://)
Monitoring nameIdentify the name of this monitoring. The name needs to be unique
PortPort provided by the database. The default is 3306
Query timeoutSet the timeout time when SQL query does not respond to data, unit: ms, default: 3000ms
Database nameDatabase instance name, optional
UsernameDatabase connection user name, optional
PasswordDatabase connection password, optional
URLDatabase connection URL,optional,If configured, the database name, user name, password and other parameters in the URL will overwrite the above configured parameters
Collection intervalInterval time of monitor periodic data collection, unit: second, and the minimum interval that can be set is 10 seconds
Whether to detectWhether to detect and check the availability of monitoring before adding monitoring. Adding and modifying operations will continue only after the detection is successful
Description remarksFor more information about identifying and describing this monitoring, users can note information here

Collection indicator

Indicator set:basic

Indicator nameIndicator unitIndicator help description
versionnoneDatabase version
portnoneDatabase exposure service port
datadirnoneDatabase storage data disk address
max_connectionsnoneDatabase maximum connections

Indicator set:status

Indicator nameIndicator unitIndicator help description
threads_creatednoneMariaDB created total connections
threads_connectednoneMariaDB connected connections
threads_cachednoneMariaDB current cached connections
threads_runningnoneMariaDB current active connections

Indicator set:innodb

Indicator nameIndicator unitIndicator help description
innodb_data_readsnoneinnodb average number of reads from files per second
innodb_data_writesnoneinnodb average number of writes from file per second
innodb_data_readKBinnodb average amount of data read per second
innodb_data_writtenKBinnodb average amount of data written per second