… very frequent cases with performance problems with MySQL is what they happen every so often or … it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, … techniques to use. Do push concurrency too high Many developers will test script with multiple …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… of instance storage 64-bit platform I/O Performance: High API name: m2.4xlarge As for the …10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22…spikes in performance. Other then that, I have also disabled query cache to avoid contention caused by query cache…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places, so… the server much faster with the binary log enabled Faster queries through speedier joins, faster subqueries, and elimination of useless tables…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…probe step. This join algorithm works best for highly selective queries, and obviously when the first operand used…is not going to provide the best possible query performance. As I mentioned at the start that BKA…at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w… mean that queries with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
…in the MySQL community are snobbish about using MyISAM (not using it that… right and very easy to maintain. Cats are finicky, high maintenance and if things aren’t just perfect will … a huge number of concurrent writes and selects and query performance must be consistently fast in this use case – you …
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
…response time performance until you use it against your work load with your dataset with your queries; thats…sharded datastore. A possible solution is to use mysql proxy and an alterate server with a snapshotted…and recall I ran into some problems under high concurrency. I guess what are your guys …
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…, thinking MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Query Cache …high performance is Query Cache performs query lookup in the cache before query parsing, so if result is served from query cache, query parsing step is saved. Queries…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… with MySQL Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache…. I believe Query Storage would benefit a lot from fast compression, such as QuickLZ. Results sets for most queries is highly compressible and…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 10 Comments
… (0.18 sec) The query consumed 0.18 seconds. Where did the time go? mysql> SHOW PROFILE FOR QUERY 1; +———————-+———-+ | Status | Duration | +———————-+———-+ | starting… wasn’t captured in the profile. The above query is something I developed for High Performance MySQL Third Edition, by the way. The book…
