Ad Widget

Collapse

zabbix help monitoring mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aroldo Eduardo
    Junior Member
    • Oct 2023
    • 1

    #1

    zabbix help monitoring mysql

    Zabbix version: 6.2

    error: cannot process returned result: cannot parse as a valid JSON object: invalid object format, expected opening character '{' or '[' at: 'OK';

    discovery rule "hotname:mysql.replication.discovery["{$MYSQL.HOST}","{$MYSQL.PORT}"]" became not supported: Unsupported item key.

    Everything has been set up as this in the official documentation.

    configuration used in template_db_mysql.conf:

    UserParameter=mysql.ping[*], mysqladmin -h"$1" -P"$2" ping
    UserParameter=mysql.get_status_variables[*], mysql -h"$1" -P"$2" -sNX -e "show global status"
    UserParameter=mysql.version[*], mysqladmin -s -h"$1" -P"$2" 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 COALESCE(SUM(DATA_LENGTH + INDEX_LENGTH),0) 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"​
Working...