关于监控mysql状态

1.在mysql库中添加一个连接的账号
GRANT USAGE ON . TO ‘zabbix’@‘localhost’ IDENTIFIED BY ‘passwd’;
FLUSH PRIVILEGES;
2.需要新建一个UserParameter参数文件夹添加如下内容

添加如下内容

For all the following commands HOME should be set to the directory that has .my.cnf file with password information.

Flexible parameter to grab global variables. On the frontend side, use keys like mysql.status[Com_insert].

Key syntax is mysql.status[variable].

UserParameter=mysql.status[*],echo “show global status where Variable_name=’$1’;” | HOME=/var/lib/zabbix mysql -N | awk ‘{print $$2}’

Flexible parameter to determine database or table size. On the frontend side, use keys like mysql.size[zabbix,history,data].

Key syntax is mysql.size[,,].

Database may be a database name or “all”. Default is “all”.

Table may be a table name or “all”. Default is “all”.

Type may be “data”, “index”, “free” or “both”. Both is a sum of data and index. Default is “both”.

Database is mandatory if a table is specified. Type may be specified always.

Returns value in bytes.

‘sum’ on data_length or index_length alone needed when we are getting this information for whole database instead of a single table

UserParameter=mysql.size[*],bash -c ‘echo “select sum($(case “$3” in both|”") echo “data_length+index_length”;; data|index) echo “$3_{l}ength";;free)echo"dat{a}_{f}ree";;esac))frominformatio{n}_{s}chema.tables$([[ “$1” = “all” || ! “$1” ]] || echo " where table_schema=”KaTeX parse error: Can't use function '\"' in math mode at position 2: 1\̲"̲")([[ “$2” = “all” || ! “$2” ]] || echo “and table_name=”$2"");" | HOME=/var/lib/zabbix mysql -N’

UserParameter=mysql.ping,HOME=/var/lib/zabbix mysqladmin ping | grep -c alive
UserParameter=mysql.version,mysql -V
3.新建一个文件夹
mkdir -p /var/lib/zabbix

#修改文件
vim /var/lib/zabbix/.my.cnf

#填入内容
[mysql]
user=zabbix
password=zabbix
host=127.0.0.1

[mysqladmin]
user=zabbix
password=zabbix
host=127.0.0.1

4.重启数据库和agent
systemctl restart mariadb
systemctl restart zabbix-agent
5.在web界面添加mysql的监控可以用自身自带的模板关联