… likely would like to see some percentile numbers – 95 percentile or 99 percentile. The problem is computing these in SQL is ugly and resource consuming…
Comment: Computing 95 percentile in MySQL
Dale, Histogram is good though takes more work to get in SQL plus it is harder to define the goals. It is much easier to say 95 percentile should be within a second and 99 percentile within 3 seconds than define goals in terms of histogram.
Comment: Computing 95 percentile in MySQL
… more meaningful. I am not sure what a 99 or 95 percentile ranking would mean to me. If anything it would lead… get a lot of noise. To generate a histogram with SQL I usually just use the group by of a count…

