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: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… same page multiple times into the buffer pool. So considering this drawback, Batched Key Access (BKA) optimization was introduced. When BKA is being… the join optimizations when the workload is IO bound. For the purpose of benchmarking IO bound workload, the InnoDB buffer pool size is… status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5…
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… counters above that both MySQL 5.6 and MariaDB 5.5 are reporting high numbers for Innodb_buffer_pool_read_ahead which shows…
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
… and MySQL 5.6 optimizer improvements, and both of them look very good indeed. Peter will present the results in an “optimizer standoff… fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL 5.5… diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be here pretty…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
… about Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number 9682004056 Log… log. Dirty Buffer Pool Pages On the other side, we have dirty buffers. These two numbers are relevant from the BUFFER POOL AND MEMORY section… to optimize the Checkpoint age, it is flushing to try to optimize IO and to obey the LRU in the buffer pool. Since buffers can…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…buffer_pool_instancesblogpercona.commanual Innodb_buffer_pool_pages_datablogpercona.commanual Innodb_buffer_pool_pages_dirtyblogpercona.commanual Innodb_buffer_pool_pages_flushedblogpercona.commanual Innodb_buffer_pool_pages_freeblogpercona.commanual Innodb_buffer_pool…
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…. You may want to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 11 Comments
… in cache, for example being washed away by other queries. MySQL Server does not provide any information of this type, Percona… warmed up first as well as how buffer pool is affected by batch jobs, alter tables, optimize table etc – the lasting impact these may have on system performance is often caused by impact they have on buffer pool which…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
… is good for optimal MySQL Performance” is typical question I’m asked. It could by MyISAM key_buffer or Innodb innodb_buffer_pool it does… 99.99% but you would still have problems with key buffer efficiency. In the real world even single operation may be… would be to look at response time contribution – how much buffer misses (physical reads) contributed to response time ? This would take…
