…-the-neck problems. Combining all above, now we can setup distributed replication systems with masters in different data centers. This provides… for synchronous not-getting-behind slaves. With additional nodes, the response time will only increase. And in multi-nodes setups, the performance…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… interesting to see distribution of 95% response time results ( 0 time is obviously the problem in sysbench, which has no enough time resolution for such… here, I should mention, that despite the good response time results, the maximal response time in some cases can jump to 300 ms per…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…produced by pt-query-digest. # Profile # Rank Query ID Response time Calls R/Call Apdx V/M Item # ==== ================== ============= ===== ====== ==== ===== ========== # 1 … the “Query_time distribution” section shows how this query times mostly, which you can see majority of the time lies in the…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… improve the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple cores. This… a list of the queries, followed by a response time table recording the actual response times for each query. The queries should be self… your data over multiple machines, scaling out to improve query response times significantly. These queries are a great test of Shard-Query…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…response time for some random user requests, you are usually interested in queries that are consuming most MySQL time… Last errno 0 # Users prod # Query_time distribution # 1us # 10us ################################################################ # 100us ######### # 1ms # # 10ms # # 100ms # # 1s …
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…is executed. #857590 (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump…, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions Consulting, support, training…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…is executed. #857590 (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump…, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions Consulting, support, training…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success… the decision quite easy. There are probably only a few distributions, which can be considered: CentOS, Debian, RedHat Enterprise Linux, SuSE… anywhere else it is plain stupid and makes you waste time on outsmarting a wise-ass system. Of course I do…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…-query-digest, the best tool for evaluating where your database response time is being spent. This month we saw the GA release… a report of the most frequent queries, even if the response time is so imprecise. But pt-query-digest and similar tools… github project. It’s called export-slow-log-table. I distribute it under the terms of the GNU Public License v3…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… tcpdump.out # Rank Query ID Response time Calls R/Call Item # ==== ================== ================ ======= ========== ==== # …_used # 0% No_index_used # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s #…
