Montior Database Size

[Zaniwoop]

My Zabbix database has grown over the years and deicided it is time to montior it's growth.

I use MySQL with innodb file per table, so its not that obvious how much space it is taking up.

I added two user parameters to the database server:

UserParameter=database.size.data,mysql -e 'select sum(data_length) from information_schema.tables where TABLE_SCHEMA = "zabbix";' -Ns 
UserParameter=database.size.index,mysql -e 'select sum(index_length) from information_schema.tables where TABLE_SCHEMA = "zabbix';" -Ns

[richlv]

you also might be interested in the userparameter that's in the example files (misc/conf/zabbix_agentd/userparameter_mysql.conf)