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

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监控模板，同时修改宏