Zabbix怎么监控Zabbixserver端MySQL的数据量？

如果只是 zabbix Server 的性能指标，直接查看监控页面就可以
如果需要查看具体的数据库文件大小等指标通过关联数据的监控模板匹配

mysql添加监控用户并修改配置

use mysql;
CREATE USER 'zabbix'@'localhost' IDENTIFIED BY 'Zabbix@123';
# 如果您遇到的是 ERROR 1396 (HY000) 类似的错误，通常表示您试图创建的用户已经存在。
ALTER USER 'zabbix'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Zabbix123';
GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'localhost';
flush privileges;

修改agent配置

vi /etc/zabbix/zabbix_agentd.conf
Include=/etc/zabbix/zabbix_agentd.d/*.conf

复制并修改配置文件

创建配置文件
vi /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

编辑配置文件
vi /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
#template_db_mysql.conf created by Zabbix for "Template DB MySQL" and Zabbix 4.2
#For OS Linux: You need create .my.cnf in zabbix-agent home directory (/var/lib/zabbix by default)
#For OS Windows: You need add PATH to mysql and mysqladmin and create my.cnf in %WINDIR%\\my.cnf,C:\\my.cnf,BASEDIR\\my.cnf https://dev.mysql.com/doc/refman/5.7/en/option-files.html
#
UserParameter=mysql.ping[*], mysqladmin -h"$1" -P"$2" -u root ping
UserParameter=mysql.get_status_variables[*], mysql -h"$1" -P"$2" -sNX -e "show global status"
UserParameter=mysql.version[*], mysql -s -h"$1" -P"$2" -sN -e "select version();"
UserParameter=mysql.db.discovery[*], mysql -h"$1" -P"$2" -sN -e "show databases"
UserParameter=mysql.dbsize[*], mysql -h"$1" -P"$2" -sN -e "SELECT SUM(DATA_LENGTH + INDEX_LENGTH) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$3'"
UserParameter=mysql.replication.discovery[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"
UserParameter=mysql.slave_status[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"

vi /etc/my.cnf.d/zabbix.cnf
#Zabbix Agent
[mysql]
host=localhost
user=zabbix
password=Zabbix123
#socket=/usr/local/mysql/mysql.sock

选择mysql监控模板，同时修改宏