Ad Widget

Collapse

why I can't get the mysql data?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vnline
    Junior Member
    • Oct 2011
    • 18

    #1

    why I can't get the mysql data?

    version: zabbix 1.9.7RC
    I have add UserParameter like that:

    UserParameter=mysql.ping,mysqladmin -uroot -p`cat /save/mysql_root` ping | grep -c alive
    UserParameter=mysql.uptime,mysqladmin -uroot -p`cat /save/mysql_root` status | awk '{print $2}'
    UserParameter=mysql.threads,mysqladmin -uroot -p`cat /save/mysql_root` status | awk '{print $4}'
    UserParameter=version.mysql,mysqladmin -uroot -p`cat /save/mysql_root` version | awk 'NR==6{print $3}'
    UserParameter=mysql.qps,mysqladmin -uroot -p`cat /save/mysql_root` status | cut -f9 -d ":"
    UserParameter=mysql.slowqueries,mysqladmin -uroot -p`cat /save/mysql_root` status | cut -f5 -d ":"|cut -f1 -d "O"
    zabbix_get can't get anything, but the zabbix_agentd -t key can get the collection data
    Last edited by vnline; 23-11-2011, 09:48.
Working...