Help with adding database size/used on the Dashboard

[greavette]

Hello Forum,

I'm interested in adding my Zabbix database size and/or how much of my database is full to my Dashboard. I also would like to have an alert setup when my database size gets to a certain threshold.

I've searched the forums but found mostly old posts asking the same question. I'm using Zabbix 6 and I'm hoping this is something that would be easy now to setup.

Can anyone provide help or point me to some steps I can follow on how I can add these details to my Zabbix server.

Thank you.

[greavette]

Thank you bartosz.mickiewicz for your suggestions...I really appreciate your input!

Your links allowed me to do some digging and I found out that there is a template "MySQL by Zabbix agent 2" - https://git.zabbix.com/projects/ZBX/...b/mysql_agent2. This template allowed me to get data out of my Zabbix database. One caveat discovered by my friend who also added this template to his Zabbix was when adding in the Plugins to your /etc/zabbix/zabbix_agent2.conf file like this:

Add in your username and password with read access to your Zabbix.
Create a mysql.dsn name. It can be literally anything you want it to be.

Plugins.Mysql.Sessions.<mysql.dns>.Uri=tcp://localhost
Plugins.Mysql.Sessions.<mysql.dsn>.User=<user>
Plugins.Mysql.Sessions.<mysql.dsn>.Password=<password>

I've also attached a picture of how the widget will look.




Once you've done that you can then add a widget to your Dashboard showing the value of your database size.



The important part to take note of is the mysql.dsn name. It can be whatever you want it to be. This mysql.dsn name will be used in your Macro for your Zabbix Host. See the image I've attached Whatever name you choose for the mysql.dsn, put that into the Value of the Macro {$MYSQL.DSN}.



Now I have at a glance the size of my database and if it's growing or not. I'm really happy with how easy it it to use Zabbix and give useful details to my Dashboard.

I hope this helps someone else looking to add the same data to their Zabbix!

[Bartosz Mickiewicz]

I think the best way forward with this would be to use ODBC Monitoring (https://www.zabbix.com/documentation...es/odbc_checks). Alternatively, you can follow this thread (https://www.zabbix.com/forum/zabbix-...-database-size) to check solutions proposed by other forum members.

[Bartosz Mickiewicz]

Also, another way would be to use vfs.dir.size agent key, so you can monitor MySQL datadir size, default path for MySQL would be /var/lib/mysql/zabbix. You can find more about the vfs.dir.size key here (https://www.zabbix.com/documentation...s/zabbix_agent).

[greavette]

Thank you bartosz.mickiewicz for your suggestions...I really appreciate your input!

Your links allowed me to do some digging and I found out that there is a template "MySQL by Zabbix agent 2" - https://git.zabbix.com/projects/ZBX/...b/mysql_agent2. This template allowed me to get data out of my Zabbix database. One caveat discovered by my friend who also added this template to his Zabbix was when adding in the Plugins to your /etc/zabbix/zabbix_agent2.conf file like this:

Add in your username and password with read access to your Zabbix.
Create a mysql.dsn name. It can be literally anything you want it to be.

Plugins.Mysql.Sessions.<mysql.dns>.Uri=tcp://localhost
Plugins.Mysql.Sessions.<mysql.dsn>.User=<user>
Plugins.Mysql.Sessions.<mysql.dsn>.Password=<password>

I've also attached a picture of how the widget will look.




Once you've done that you can then add a widget to your Dashboard showing the value of your database size.



The important part to take note of is the mysql.dsn name. It can be whatever you want it to be. This mysql.dsn name will be used in your Macro for your Zabbix Host. See the image I've attached Whatever name you choose for the mysql.dsn, put that into the Value of the Macro {$MYSQL.DSN}.



Now I have at a glance the size of my database and if it's growing or not. I'm really happy with how easy it it to use Zabbix and give useful details to my Dashboard.

I hope this helps someone else looking to add the same data to their Zabbix!