One of the very frequent cases with performance problems with MySQL is what they happen every so often …
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…Andy, I am not testing IO performance and instead trying to optimize writes, also the durability requirements are not that stringent and…
Comment: Joining many tables in MySQL - optimizer_search_depth
May 12, 2012 By 6 Comments
… pushing the performance in case of particular queries but surely cannot be an all-around answer to inefficiencies of the optimizer, that…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… this optimization actually is. Key-ordered Scan for BKA With this optimization the idea of MRR is further extended to improve join performance… these buffers should be increased appropriately for the best possible performance gain. This is not entirely visible in the manual either… MRR performance, and BKA uses the MRR interface, so these buffers indirectly impact BKA performance. I did not find much of a performance…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… was taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries these might need to… making it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search_depth=0, rarely used option… bring optimization, and full query execution time to less than 50ms. Low values, such as 3,4 provided a bit better performance…
Post: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
… co-presenting with Virident webinar: “How to Turbocharge Your MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish… Approaches for scaling MySQL instances on fewer servers while delivering optimal performance using flash drives The registration is free and available there…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… definition (and hence covering index optimization is not used), then primary key lookups have to be performed for each secondary key entry… calls made to the storage engine to perform the index record read and then to perform the MRR range scan on the… needed in the optimizer‘s cost estimation algorithm. MariaDB 5.5 expands the concept of MRR to improve the performance of secondary…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL 5.5 offers pluggable authentication… different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL world as…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
Don’t forget that Timour and Sergei are giving a 3 hour tutorial on MariaDB 5.3 (and 5.5?) and MySQL 5.6 optimizers: http://www.percona.com/live/mysql-conference-2012/sessions/improving-mysqlmariadb-query-performance-through-optimizer-tuning
