Can a stored procedure be used in place of a single SQL statement in the ODBC User Experience monitor ?
I need to pull several rows from a table in MariaDB and then perform a calculation and return a single value.
This is the calculation to determine Query Cache Hit Rate :
query_hits and com_select are 2 different rows in the global_status table
Or is there a better why to do this ?