Ad Widget

Collapse

template mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dzek
    Junior Member
    • Apr 2012
    • 18

    #1

    template mysql

    в zabbix_agentd.conf

    Code:
    UserParameter=mysql.ping,mysqladmin -uroot -ppwd ping|grep alive|wc -l
    UserParameter=mysql.uptime,mysqladmin -uroot -ppwd status|cut -f2 -d":"|cut -f1 -d"T"
    UserParameter=mysql.threads,mysqladmin -uroot -ppwd status|cut -f3 -d":"|cut -f1 -d"Q"
    UserParameter=mysql.questions,mysqladmin -uroot -ppwd status|cut -f4 -d":"|cut -f1 -d"S"
    UserParameter=mysql.slowqueries,mysqladmin -uroot -ppwd status|cut -f5 -d":"|cut -f1 -d"O"
    UserParameter=mysql.qps,mysqladmin -uroot -ppwd status|cut -f9 -d":"
    UserParameter=mysql.version,mysql -V
    в логах
    Code:
    [Zabbix server:mysql.status[Bytes_received]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Bytes_sent]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Com_begin]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Com_commit]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Com_delete]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Com_insert]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Com_rollback]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Com_select]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Com_update]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Questions]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Slow_queries]] became not supported: Not supported by Zabbix Agent
    [Zabbix server:mysql.status[Uptime]] became not supported: Not supported by Zabbix Agent
    что не доглядел?
  • a.tihonov
    Junior Member
    • Oct 2012
    • 24

    #2
    по пробуйте

    su zabbix -s /bin/bash
    и там от него по выполнять команды, может он доступа не имеет ? По пробуйте сам наступал на эти грабли.

    А вообще у вас mysql.status[Slow_queries]] - очень странная, по идее должно быть так
    mysql.slowqueries[Slow_queries] - а у вас ключ mysql.status.

    Comment

    • dzek
      Junior Member
      • Apr 2012
      • 18

      #3
      спасибо за ответ.
      по идеи там юзер рут указан.
      вчера разобрался. но видимо тут премодерация. тему не видел.

      Comment

      Working...