… all the interesting percentiles at once. This would also allow to visually detect anomalies like a bimodal distribution. The 99%ile is, IMHO, too little information. The average, 90%, 95% and 99% numbers together give a much more thorough view on the…
Comment: Testing Intel® SSD 910
September 15, 2012 By 2 Comments
Vadim, For enterprise class SSD the most important performance characteristics – Read/Write throughput in steady state and request latency percentiles. In many cases nobody cares about how much TPS device sustain if you can not get 99% of them under 100ms, for example. Or better – under 10ms.
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… performance implications. On the other hand, if we determine that 99% of the traffic are these single row PK lookups and… scenario, you will tune innodb_concurrency_tickets to the 99th percentile of small PK lookups. If you’re optimizing for response…
Comment: MySQL Performance on Memory Appliance
February 11, 2009 By 23 Comments
…: 14 (0.20 per sec.) read/write requests: 1900270 (26491.99 per sec.) other operations: 200018 (2788.49 per sec.) Test…: 0.0027s avg: 0.0115s max: 0.0979s approx. 95 percentile: 0.0313s Threads fairness: events (avg/stddev): 6250.1250/66…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… 1 second in 95% cases and below 3 seconds in 99% cases”. Note We’re specific to the user interaction – people… other interactions for many applications, and also we speak about percentile response time rather than “all queries”. It is surely good…
Comment: Computing 95 percentile in MySQL
November 29, 2008 By 5 Comments
… be more meaningful. I am not sure what a 99 or 95 percentile ranking would mean to me. If anything it would…
