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

    ODBC User Experience monitor question

    cisaksen

      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 ?

       

      Thanks