Problem with MySQL datasource query

Grafana
1

I’m trying to plot a simple graph of the number of ‘max’ connections in a MySQL instance, from the ‘information_schema’ database using the MySQL datasource. The following query works on the MySQL command line, but if I try to make a “Time Series” it gives me a “blank” graph, not sure why. Any ideas?

SELECT UNIX_TIMESTAMP() as time, variable_value as value FROM global_status WHERE variable_name = ‘MAX_USED_CONNECTIONS’ order by time asc

Output of query in MySQL:
mysql> SELECT UNIX_TIMESTAMP() as time, variable_value as value FROM global_status WHERE variable_name = ‘MAX_USED_CONNECTIONS’ order by time asc;
±-----------±------+
| time | value |
±-----------±------+
| 1531844841 | 911 |
±-----------±------+
1 row in set (0.00 sec)

2

I ran into this yesterday. I thought, Grafana would request the sql at given intervals, store the results, and then graph the result of that information. Instead, it just shows what is returned for that simple query. So, I only go a dot on the far righthand side.