I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… introduced a regression that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… that a major problem for MySQL scalability? The scan is performed under kernel_mutex (or trx_sys->mutex in 5.6…!) angle. It requires neither read-only server nor rewriting application queries. Furthermore, it can be combined with the read-only optimization… alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… pt-query-digest. One customer was suffering from periods of high load on their database server, leading to degraded application performance, and…-format profile, to get just the ranking of queries. To my luck, one query stood out right away, always appearing many times more than any other one during peaks. Rewriting that query (actually the customer removed it altogether, by merging it with…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
… training and consulting, I’ll classify several common types of queries with which developers struggle. I’ll test several SQL solutions… them for optimal query efficiency. The discussion will cover optimizer reports, query profiling, and session status to measure performance. The query patterns will include…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For example… look as though single-thread performance is no more a concern. I believe it still is! First, performance at concurrency of 1… times (MySQL server does not use multiple threads to execute query in parallel at this point). Response times at the variety…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
…’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I… can use the wealth of information Performance Schema gathers to understand some of the typical performance bottlenecks. Other areas of focus include… temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks…
Comment: Why MySQL Performance at Low Concurrency is Important
March 31, 2013 By 8 Comments
… conclusions assume a benchmark with fast (100 to 200 usecs) queries: * performance_schema overhead is too high for benchmarks * innodb_checksum_algorithm…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… – SSD config) which shows the most consistent performance. The others all have assorted performance drops scattered throughout the graph. We see the… time-based flushing enabled actually produces better and more consistent performance than vCache without time-based flushing, but even at its… join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… variation, e.g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but… = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we use following queries: select…
