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… second worth of data, hence I did not test with innodb_flush_log_at_trx_commit=1. I would also not recommend running on EBS with innodb_flush_log_at_trx_commit=1, because IO times on…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…values by PK column and then performing the lookup, and then there are other possibilities like InnoDB doing read_ahead by noticing…config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_sort_keys=on’ optimizer_switch=’mrr_cost_based=off’ optimizer_…
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: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… were made in the MySQL config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_sort_keys=on’ (only… these lookups are performed in a single call to the storage engine and the counters Handler_read_key and Innodb_rows_read… and then to perform the MRR range scan on the PK. This causes the counters Handler_read_key and Innodb_rows_read…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…support, as well as a lot of optimizer improvements. Even the standard MySQL 5….improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB …personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for …
Comment: Instrumentation and the cost of Foreign Keys
April 19, 2012 By 9 Comments
… a performance benefit because the optimizer has more information about what needs to be done and the plan is created faster. Does innodb get any such performance… final gate for data consistency. So, how about some real performance data benchmarks with and without FKs to see if the…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal… on indexes). With these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a… write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set… use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance benefits as well. Tuning your…
Post: Performance Optimization and Six Sigma
June 7, 2010 By 6 Comments
… on performance rather than performance stability even though it is the later what their users really care about. Consider Adaptive Checkpoint in Innodb for example – until it got implemented we had very poor performance stability under very large number….7%. One reason we use rather weak confidence intervals in performance optimization is we need a lot of transactions to get stable…
