Code:
27746:20200706:170432.559 active check "mysql.ping" is not supported: Unsupported item key. 27746:20200706:170432.559 active check "mysql.qps" is not supported: Unsupported item key. 27746:20200706:170432.559 active check "mysql.sbm" is not supported: Unsupported item key. 27746:20200706:170432.559 active check "mysql.sir" is not supported: Unsupported item key. 27746:20200706:170432.559 active check "mysql.slowqueries" is not supported: Unsupported item key. 27746:20200706:170432.559 active check "mysql.sott" is not supported: Unsupported item key. 27746:20200706:170432.559 active check "mysql.sr" is not supported: Unsupported item key. 27746:20200706:170432.559 active check "mysql.srt" is not supported: Unsupported item key. 27746:20200706:170432.559 active check "mysql.threads" is not supported: Unsupported item key. 27746:20200706:170432.559 active check "mysql.uptime" is not supported: Unsupported item key.
Code:
cat /etc/zabbix/zabbix_agentd.conf LogFile=/var/log/zabbix/zabbix_agentd.log LogFileSize=10 Server=zabbix-server StartAgents=0 ServerActive=zabbix-server Hostname=mysql-slave BufferSend=10 BufferSize=400 TLSConnect=psk TLSAccept=psk TLSPSKIdentity=identity TLSPSKFile=/etc/zabbix/zabbix_agent.psk BufferSend=10 BufferSize=400 PidFile=/var/run/zabbix/zabbix_agentd.pid #DebugLevel=4
Code:
cat /etc/zabbix/zabbix_agentd.d/zabbix_agentd.mysql.conf UserParameter=mysql.ping,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock ping|grep alive|wc -l UserParameter=mysql.uptime,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock status|cut -f2 -d":"|cut -f1 -d"T" UserParameter=mysql.threads,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock status|cut -f3 -d":"|cut -f1 -d"Q" UserParameter=mysql.slowqueries,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock status|cut -f5 -d":"|cut -f1 -d"O" UserParameter=mysql.qps,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock status|cut -f9 -d":" UserParameter=mysql.srt,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock extended-status|/bin/grep -i 'Slave_retried_transactions' | cut -f3 -d'|' UserParameter=mysql.sott,mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock extended-status|/bin/grep -i 'Slave_open_temp_tables' | cut -f3 -d'|' UserParameter=mysql.sr,mysql --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock -e "Show slave status\G"|/bin/grep -w 'Slave_SQL_Running' | cut -f2 -d':' | sed "s/No/0/; s/Yes/1/" UserParameter=mysql.sir,mysql --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock -e "Show slave status\G"|/bin/grep -w 'Slave_IO_Running' | cut -f2 -d':' | sed "s/No/0/; s/Yes/1/" UserParameter=mysql.sbm,mysql --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock -e "Show slave status\G"|/bin/grep -i 'Seconds_Behind_Master' | cut -f2 -d':'
Code:
mysqladmin --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock ping mysqld is alive mysql --defaults-file=/etc/zabbix/scripts/config.cnf --socket=/var/lib/mysql/mysql.sock -e "Show slave status\G"|/bin/grep -w 'Slave_IO_Running' Slave_IO_Running: Yes
any ideea what can be the problem, and how to solve it ?


Comment