Mysql monitoring using telegraf and influx db

1

hi everyone i’am using telegraf and influxdb to monitor mysql database in order to display thread connections,connected_users,number of requests on my database
so i used the [[inputs.mysql]] plugin
-telegraf status working fine without error

  • i tested telegraf with “telegraf --config /etc/telegraf/telegraf.conf --config /etc/telegraf/telegraf.conf --test” it shows data
    but while updloading a mysql dashboard on my Grafana i got that unknown error and all graph shows ‘‘no data’’:
    Templating
    Template variables could not be initialized: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TAG VALUES WITH KEY=“server”’ at line 1
2

Please show us the full query (copy and paste from the Query Inspector) which
contains that string.

Antony

3

How can i know which one of the querry shall i inspect? the error message doesn’t guide me to any querry !!
how can i know where is his querry from 18 panels !
and if that error was due to only one querry why all my 18 panels show no data !
i just followed the tuto step by step

4

Okay, please point us at the tutorial you are referring to, so we can see what
you might have done.

Antony.

5

this one :


this was the only tuto found about monitoring mysql using telegraf !