Получение параметров MySQL с Zabbix агента

Добавить пользователя для мониторинга

CREATE USER 'monitor';
GRANT USAGE ON *.* TO 'monitor'@'localhost' IDENTIFIED BY 'USERPASSWORD';
FLUSH PRIVILEGES;

Создать файл /etc/zabbix-agent.d/mysql.conf

UserParameter=mysql.ping,mysqladmin -uUSER -pPASSWORD ping 2>/dev/null | grep alive | wc -l
UserParameter=mysql.uptime,mysqladmin -uUSER -pPASSWORD status 2>/dev/null | cut -f2 -d":" | cut -f1 -d"T" 
UserParameter=mysql.threads,mysqladmin -uUSER -pPASSWORD status 2>/dev/null | cut -f3 -d":" | cut -f1 -d"Q"
UserParameter=mysql.questions,mysqladmin -uUSER -pPASSWORD status 2>/dev/null | cut -f4 -d":" | cut -f1 -d"S"
UserParameter=mysql.slowqueries,mysqladmin -uUSER -pPASSWORD status 2>/dev/null | cut -f5 -d":" | cut -f1 -d"O"
UserParameter=mysql.qps,mysqladmin -uUSER -pPASSWORD status 2>/dev/null | cut -f9 d":"
UserParameter=mysql.status[*],mysqladmin -uUSER -pPASSWORD extended-status 2>/dev/null | grep -w $1 | awk '{print $$4}'
UserParameter=version.mysql,mysql -V