…mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool… MySQL With 10GB Innodb buffer pool for example and see how large RSS and VSZ get in …/proc/sys/vm/swappiness is another helpful change though it does not always save…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB… you’re adding/dropping/changing columns as if you …Buffer Pool Size Matters There is 10x difference between the case when index fits in…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in the buffer pool…Innodb_buffer_pool_read_ahead when the buffers are sized appropriately, which shows that the IO access pattern has been changed…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…buffer size. In MySQL 5.6 the buffer size used by MRR can be controlled by the variable read_rnd_buffer_size…InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in the buffer pool…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…Innodb_buffer_pool_read_requestsblogpercona.commanual Innodb_buffer_pool_readsblogpercona.commanual innodb_buffer_pool_sizeblogpercona.commanual Innodb_buffer_pool_wait_freeblogpercona.commanual Innodb_buffer_pool_write_requestsblogpercona.commanual innodb_change…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…Innodb Buffer Pool Size scan resistant by default. Very welcome change ! thread_cache_size is enabled by default, though I wonder why default value is 9. In…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… variables in MySQL Servers only few of them are really important for most common workload. After you get these settings right other changes… OK with default key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer pool caches both data and…
Post: Adaptive flushing in MySQL 5.6
September 4, 2012 By 8 Comments
…, not being able to process queries. So, how it is changed in MySQL 5.6.6: I should admit there is no more…_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_buffer_pool_size = 150G innodb_log_file_size = 4G innodb_log_files_in_group = 2 #####plugin options innodb_read…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…size.. – Of course the things may change if “innodb…mysql benchmark with 500W using Percona Server 5.5.8. Here is relevant part of config what I used innodb_buffer_pool_size=26G innodb…
