… 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 ???
April 1, 2011 By 16 Comments
… 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
December 29, 2010 By Leave a Comment
… 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
May 14, 2011 By 27 Comments
… 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.
May 14, 2011 By Leave a Comment
… 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…
Post: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
… Response Time Distribution, which uses those operations, was made slightly more efficient. Bug fixed: #878022 (Laurynas Biveinis) An output buffer truncation check in Response Time Distribution…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…). Other Changes Improvements and fixes on platform-specific distribution: The compilation of the Response Time Distribution patch has been fixed on Solaris (supported platform…) For more information, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions Consulting, support, training, and custom…
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
…). Other Changes Improvements and fixes on platform-specific distribution: The compilation of the Response Time Distribution patch has been fixed on Solaris (supported platform…) For more information, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions Consulting, support, training, and custom…
Comment: Why do we care about MySQL Performance at High Concurrency?
February 27, 2013 By 9 Comments
The FIFO policy is simple, and also responsible for a good response time distribution (95%-99% values) in sysbench with threadpool 
Prioritizing is not… (transactions can be independent after all) . Mikael spent lot of time describing non-trivial amount of logic to workaround http://bugs…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…_warnings is enabled. (Oleg Tsarev) response_time_distribution – Counts queries with very short execution times and groups them by time interval. (Oleg Tsarev) innodb_buffer… problem with SHOW PROCESSLIST displaying an incorrect time. Bug #610525 – Reduces the number of compile time errors when the server is rebuilt…
