May 25, 2012

Comment: Testing Fusion-io ioDrive

Vadim, Do you have response time distribution for writes ? Also what Model/size of ioDrive is this ?

Comment: Testing Intel SSD 520

Vadim, I see you measured response time distribution for reads in sync mode but only Throughput every 10 seconds for random writes. Any reason for that ?

Post: Testing Virident FlashMAX 1400

… still continue to run benchmarks of different SSD cards. This time I show numbers for Virident FlashMAX 1400. This is a… I’ve seen so far in my benchmarks. To see distribution of response time, the results for random read synchronous IO. There we… in sync mode, and only 64 threads are getting close. Response time: In the conclusion, from all tested cards, Virident FlashMAX shows…

Comment: Introducing new type of benchmark

… processing time P – it’s the reciprocal of the max system throughput (1/TPS in the case of a database). The response time of the system under load is R = P + L + Q, where is Q is the average time a request… is fully utilized, and that’s not true with Poisson distribution! According to the queuing theory, Q = P * U / ( 1 – U…

Comment: Introducing new type of benchmark

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.

Post: Query Response time histogram - new feature in Percona Server

… adds new INFORMATION_SCHEMA table QUERY_RESPONSE_TIME ( full docs are on page response_time_distribution), which looks like time count 0.000001 53 0.000010… demonstrate possible usage of histogram of response time, let me show you how increasing throughput affects response time. There are histograms and pie charts…

Post: Performance or Stability ???

… is response time what users will use to judge if your system is fast or slow. You will always see some response time distribution rather than all queries of the same time having same response time and this distribution will vary a lot…

Post: Percona Server 5.1.53-12.4

… hash functions to provide faster checksums) are now included in distributions. Fixes feature request #689992. (Aleksandr Kuzminsky)  Other Changes: innodb… specified. (Yasufumi Kinoyasu) Added system variable have_response_time_distribution and compile option –without-response_time_distribution in Response Time Distribution. (Oleg Tsarev) Bugs Fixed Bug #643149 – Slow…

Post: Distributed Set Processing with Shard-Query

… how to distribute the computation of aggregation queries over time. I realised that I could apply these same mathematical concepts to distributed queries… new nodes in data center B and distribute the queries over both data centers. The response time should only be increased by the…

Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.

… I’ve coined “distributed set processing”. Please also read this post’s “sister post” which describes the distributed set processing technique. Also… the system from being overloading and provides a scalable average response time under increased concurrency. Another queue in front of the storage…