Ad Widget

Collapse

Graph data from MySQL Table?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ronno
    Junior Member
    • Nov 2008
    • 2

    #1

    Graph data from MySQL Table?

    Is it possible to graph data from a MySQL table?
  • rue
    Member
    Zabbix Certified Specialist
    • May 2006
    • 43

    #2
    yes.

    cheers

    rue

    PS: You might want to be a bit more specific... . ;o)

    Comment

    • ronno
      Junior Member
      • Nov 2008
      • 2

      #3
      Thanks, perhaps we both should. :-)

      I have data in MySQL that I want to graph. What's the method for extraction?

      Comment

      • exkg
        Senior Member
        Zabbix Certified Trainer
        Zabbix Certified Specialist
        • Mar 2007
        • 718

        #4
        Hi,

        Fast and easy, in your monitored host

        UserParameter=mysql.query,echo "select count(*) from hosts"| mysql -N -uroot -p<YOUR_MYSQL_PASS> zabbix

        Restart you ZBX-Agent and test from you ZBX-Server:

        zabbix_get -s<monitored-HOST> -k mysql.query[]


        []s,
        Luciano
        --
        Luciano Alves
        www.zabbix.com
        Brazil | México | Argentina | Colômbia | Chile
        Zabbix Performance Tuning

        Comment

        • Joby
          Junior Member
          • Nov 2012
          • 29

          #5
          Graph data from MySQL Table?

          This is working...Thanks
          Last edited by Joby; 13-06-2013, 15:35.

          Comment

          Working...