… innodb_flush_neighbor_pages. By default InnoDB flushes so named neighbor pages, which really are not neighbors. Say we want to flush page P. InnoDB is looking in an area of 128 pages… from original intention to flush as many pages as possible in singe sequential write. So we added new innodb_flush_neighbor_pages=cont method, with it…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… flush 8 pages. InnoDB flushes page P and its 7 neighbors (which are not really neighbors), and then stops after this (alas, 8 pages flushed). That is, instead of flushing… reasons why innodb_adaptive_flushing is not able to keep up. What if we disable flushing of neighbor pages (we have the option innodb_flush_neighbor_pages in Percona…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
…=2 innodb_log_file_size=4G innodb_adaptive_checkpoint=keep_average innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io_threads=16 innodb_read…
Post: InnoDB Flushing: Theory and solutions
April 4, 2011 By 23 Comments
I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a … implementation of flushing neighbors is problematic. When we want to flush N pages in order to control checkpoint_age, we expect that flushing pages will have…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… reason? Let’s try a guess: flushing neighborhood pages. Let’s repeat the last run, but with innodb_flush_neighbor_pages=0. Okay, we are back… innodb_write_io_threads = 16 innodb_io_capacity=500 innodb_max_dirty_pages_pct = 60 innodb_purge_threads=1 innodb_adaptive_flushing=0 innodb_doublewrite=1 innodb_flush_neighbor_pages=0 innodb_adaptive…
Post: Announcing Percona Server 5.5.19-24.0
January 13, 2012 By 4 Comments
….5.19-24.0 milestone at Launchpad. New Features Variable innodb_flush_neighbor_pages can be now set to a new value cont. The… disables the neighbor page flush and area matches the default InnoDB behavior: any dirty pages in the vicinity of the page selected for flushing may be flushed too…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…=2 innodb_log_file_size=4G innodb_log_block_size=4096 innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io_threads=8 innodb_read…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… for Percona Server: innodb_log_file_size=4G (innodb_log_files_in_group=2) innodb_flush_neighbor_pages=0 innodb_adaptive_checkpoint=keep_average innodb_read_ahead=none…: innodb_log_file_size=8G Disabling flushing of neighborhood pages: innodb_flush_neighbor_pages=0 New adaptive checkpointing algorithm innodb_adaptive_checkpoint=keep_average Disabled read-ahead logic: innodb…
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
…/wiki/patches:innodb_io_patches * innodb_flush_neighbor_pages (default 1) – When the dirty page are flushed (written to datafile), this parameter determines whether the neighbor pages in the datafile are also flushed at…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… Tuned flushing algorithm Disable flushing of neighbor pages and the configuration to provide better experience on SSD is : innodb_flush_neighbor_pages = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb…
