slow query scale in stats needs cumulative option?
Posted: 29 Sep 2012, 19:09
Not sure if this is the best way to solve this but it's impossible to see changes in slow queries on the graphs when the scale for the regular queries is so high.
Slow queries appears as a flat red line next to zero on all our graphs because it's an average per minute, which is almost always 1 per minute when calculated that way.
Instead I'd like to be able to have slow queries as cumulative per hour on all the graphs?
Just add them up and reset the count after storing the summary each hour?
Keep up the great work - I absolutely love the stats compared to other packages which are far too resource heavy.
Slow queries appears as a flat red line next to zero on all our graphs because it's an average per minute, which is almost always 1 per minute when calculated that way.
Instead I'd like to be able to have slow queries as cumulative per hour on all the graphs?
Just add them up and reset the count after storing the summary each hour?
Keep up the great work - I absolutely love the stats compared to other packages which are far too resource heavy.