… even for small amount of threads. For 8 threads the 95% response time is 0.69ms. Now let me get back… to second. I draw boxplots, which show 25-50-75 percentiles. So there is no grow in throughput after 2 threads…
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
Hi Vadim I find this very useful and also agree with Tobi that a latency distribution will be very useful. Many times applications need to meet response time SLAs for 95 or 99 percentile of requests, so knowing a distribution will be useful.
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…. That way a single chart can provide all the interesting percentiles at once. This would also allow to visually detect anomalies… 99%ile is, IMHO, too little information. The average, 90%, 95% and 99% numbers together give a much more thorough view…
Post: Computing 95 percentile in MySQL
November 28, 2008 By 5 Comments
When doing performance analyzes you often would want to see 95 percentile, 99 percentile and similar values. The “average” is the evil of… your response time goal in 95 or 99 percentile is much better. Say you say 99 percentile response time should be one second… this system the 95 percentile is just over 5 sec (some 3 times more than the average) and 99% percentile is just a…
Post: Performance Optimization and Six Sigma
June 7, 2010 By 6 Comments
… 95 percentile something like 1000 transactions will give more or less stable results in most cases. If we’re looking at 99 percentile… of my talks about performance measurements I suggested to measure 95 percentile over short period of times for example every minute, which…. I believe meeting 95 percentile response time every minute of the day is a lot harder than getting 99 percentile over 24 hours…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…: min: 0.0001s avg: 0.0001s max: 0.0086s approx. 95 percentile: 0.0001s Threads fairness: events (avg/stddev): 773835.0000/0… avg: 0.0027s max: 0.0112s approx. 95 percentile: 0.0030s So we get about 3ms 95 percentile request time – not bad – all request…
Post: Color code your performance numbers
June 2, 2010 By 4 Comments
… functions. We most likely would like to see some percentile numbers – 95 percentile or 99 percentile. The problem is computing these in SQL is…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
…: min: 0.04ms avg: 0.06ms max: 0.34ms approx. 95 percentile: 0.06ms Threads fairness: events (avg/stddev): 1343.0000/0…: min: 0.10ms avg: 1.11ms max: 259.69ms approx. 95 percentile: 5.31ms Threads fairness: events (avg/stddev): 33900.0000/0…
Post: mysql-proxy, urgh performance and scalability ?
June 9, 2009 By 27 Comments
….30ms approx. 95 percentile: 1.56ms Proxy+MySQL per-request statistics: min: 2.04ms avg: 2.86ms max: 6.44ms approx. 95 percentile: 4…
Comment: Computing 95 percentile in MySQL
November 29, 2008 By 5 Comments
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.
