MySQL Stored Procedure

Grafana MySQL
1

Hi
is possible to call stored procedure? I mean, instead to “select …” execute “call myprocedure(parameters)”.

Thanks

1 Like
2

I’m very interested in this answer too. It seems to be supported for MS-SQL. It would be a hugely beneficial if it were supported for MySQL too.

3

I’m totally new to Grafana, but it worked for my with MySQL - at least as a time series. As long as the stored procedure outputs a column called “time”, it seems to work fine. Because my table uses a datetime column for timestamp, this is the (raw) query I entered into my panel:

call sp_GetDataForGrafana( $resourceId, FROM_UNIXTIME($__unixEpochFrom()), FROM_UNIXTIME($__unixEpochTo()), ... );
4

Thanks. Yes it works only if the dataset include datetime column.

5

This topic was automatically closed after 365 days. New replies are no longer allowed.