…InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool…MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool…Innodb_buffer_pool_read_ahead which shows that the access pattern was sequential and hence InnoDB decided to do read_ahead, while in MySQL…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take… for filtering records. For example, suppose you have a key defined as: KEY `i_l_partkey` (`l_partkey`,`l_quantity`,`l_shipmode…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…memory tables. So first MySQL versions did not bother naming variables with storage engines prefix. This is why we have key_buffer, not “myisam_key_buffer…key_buffer itself. large_pages – Use of Large Pages for allocation of large global areas such as Innodb Buffer Pool, Key Buffer…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Innodb_buffer_pool_pages_latchedblogpercona.commanual Innodb_buffer_pool_pages_miscblogpercona.commanual Innodb_buffer_pool_pages_totalblogpercona.commanual Innodb_buffer_pool_read_aheadblogpercona.commanual Innodb_buffer_pool_read_ahead_evictedblogpercona.commanual Innodb_buffer_pool…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL…Innodb – it just loves to have as much data in buffer pool as possible for best performance…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
…(often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning … mmap is much slower than allocating from memory memory pool which process already “owns” and in …pages. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for other …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… hardware, including RAID controllers, installed memory, and so on in the boot …full explanation in our book, High Performance MySQL 2nd Edition (it’s not in…s hard to read. If the InnoDB buffer pool is set to 22GB, it’…default users in the mysql.* tables, running mk-duplicate-key-checker to find …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…buffer pool. In high load situations where INNODB is using most of the system’s memory the kernel can decide (incorrectly) to swap out MySQL…buffer pool flush. I think Yasufumi Kinoshita talked at Users’ Conference 2007 about his patch that makes InnoDB‘s flushes smoother and increase performance…
