Buy Percona ServicesBuy Now!

Not Able to see the graphs in zabbiox for mysql.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Not Able to see the graphs in zabbiox for mysql.

    Hi ,

    I have followed the document exactly as mentioned in https://www.percona.com/doc/percona-...bix/index.html.
    I updated the script /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php with username and password which is global for all our databases with @'%'.

    from Zabbiz
    from end i see everything looks cool, but i am not sure what i am missing graphs are not getting generated.

    Can you please do let me know if i need to do something extra?

    Amit


  • #2
    getting the following error in zabbix_server.log
    26534:20160212:105249.173 item "pmdbm001iad.io.askjeeves.info:MySQL.pending-chkp-writes" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26534:20160212:105249.173 item "pmdbm001iad.io.askjeeves.info:MySQL.pending-ibuf-aio-reads" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26534:20160212:105249.173 item "pmdbm001iad.io.askjeeves.info:MySQL.pending-log-flushes" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26534:20160212:105249.173 item "pmdbm001iad.io.askjeeves.info:MySQL.pending-log-writes" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26534:20160212:105249.173 item "pmdbm001iad.io.askjeeves.info:MySQL.pending-normal-aio-reads" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105254.174 item "pmdbm001iad.io.askjeeves.info:MySQL.pending-normal-aio-writes" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105254.174 item "pmdbm001iad.io.askjeeves.info:MySQL.pool-read-requests" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105254.174 item "pmdbm001iad.io.askjeeves.info:MySQL.pool-reads" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105254.174 item "pmdbm001iad.io.askjeeves.info:MySQL.pool-size" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105254.174 item "pmdbm001iad.io.askjeeves.info:MySQL.query-cache-size" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26534:20160212:105259.177 item "pmdbm001iad.io.askjeeves.info:MySQL.read-views" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26534:20160212:105259.177 item "pmdbm001iad.io.askjeeves.info:MySQL.recovery-system-memory" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26534:20160212:105259.177 item "pmdbm001iad.io.askjeeves.info:MySQL.relay-log-space" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26534:20160212:105259.177 item "pmdbm001iad.io.askjeeves.info:MySQL.rows-deleted" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26534:20160212:105259.177 item "pmdbm001iad.io.askjeeves.info:MySQL.rows-inserted" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105304.178 item "pmdbm001iad.io.askjeeves.info:MySQL.rows-read" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105304.178 item "pmdbm001iad.io.askjeeves.info:MySQL.rows-updated" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105304.178 item "pmdbm001iad.io.askjeeves.info:MySQL.slave-lag" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105304.178 item "pmdbm001iad.io.askjeeves.info:MySQL.slave-running" became not supported: Received value [N] is not suitable for value type [Numeric (float)]
    26532:20160212:105304.178 item "pmdbm001iad.io.askjeeves.info:MySQL.slave-stopped" became not supported: Received value [N] is not suitable for value type [Numeric (float)]

    Comment


    • #3
      Did you ever find a solution to this? I'm having the same problem. I'm running Zabbix 3.2.3.

      Comment

      Working...
      X