0 Replies Latest reply on Apr 16, 2018 3:00 PM by cisaksen

    ODBC User Experience monitor question


      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 : 

      (qcache_hits/ (qcache_hits+com_select))


      query_hits and com_select are 2 different rows in the global_status table


      Or is there a better why to do this ?