One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…
Post: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
… MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish Jamthe). Running MySQL…performance advantages (ROI) when flash storage is used appropriately for MySQL workloads Approaches for scaling MySQL instances on fewer servers while delivering optimal performance…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… the MySQL config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_sort_keys=on’ (only on MariaDB 5.5) optimizer… were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w…
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… further I found the following explanation from Timour Katchaounov in MySQL mailing list archives I have some recollection that there were…
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…made on MySQL 5.6 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_cost_based=off’ optimizer_switch=’…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one… post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…. Peter will present the results in an “optimizer standoff” talk at the upcoming MySQL conference, and Timour and Sergei from Monty Program… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places…
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
Post: MySQL Performance - eliminating ORDER BY function
October 17, 2007 By 6 Comments
One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants or order … phase can be skipped all together. Note in this case MySQL Optimizer is rather smart and is able to do this even… functions are different MySQL is not able to do this optimization even in cases when this would be possible: mysql> explain select * from…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…which has the highest performance optimization potential. But let us get back to the Server Side Optimization. Lets assume our performance goal applies to…mysql_time/wtime) mysql_ratio ,avg(sphinx_time/wtime) sphinx_ratio, avg((wtime-mysql_time-sphinx_time-utime)/wtime) lost_ratio from performance_…
