… innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…going down. What you might see instead is flushing tables regularly or reducing table cache … 7234 TABLE_SCHEMA: test TABLE_NAME: my ENGINE: InnoDB NAME: #sql516_1c42_2 TABLE_ROWS: 0…Internal hash tables (constant factor + variable factor) Adaptive hash index 4422068288 (2039977928 + 2382090360) Page …
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… and 40G buffer pool. We started it up with innodb_adaptive_flushing=OFF and innodb_doublewrite=OFF, then ramped up traffic and everything looked… adjusting innodb_io_capacity here. Is there a lesson in this? Sometimes tuning InnoDB settings can have quite unexpected results…. Setting innodb_adaptive_flushing ON…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
… 0 innodb_ibuf_active_contract = 1
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… innodb_buffer_pool_size=24G, innodb_log_file_size=2000M (innodb_log_files_in_group=2), and innodb_flush_log_at_trx_commit=2. Also, innodb_adaptive_flushing (ON) / innodb_adaptive_checkpoint (estimate…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
… tablespaces) *cough ext3 cough*. innodb_adaptive_flushing: An Innodb plugin/5.5 setting that tries to be smarter about flushing more aggressively based on the number of dirty pages and the rate of transaction log growth. innodb_adaptive_flushing_method: (Percona…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… ~ 10GB of data, 12G innodb_buffer_pool_size, 1G innodb_log_file_size), MySQL 5.5.10 with innodb_adaptive_flushing=ON (default)). The problem… 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…
Post: Why delayed flushing can result in less work
December 9, 2009 By 5 Comments
…’s recent post on InnoDB adaptive flushing asked, That’s really interesting stuff; am I reading it correctly though that adaptive flush actually increased the… and average IO rate were higher with adaptive flush nabled (assuming I’m reading properly). Yes. Adaptive flushing actually increased the overall number of…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… are flush list bound, then for MySQL 5.1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… some waves for InnoDB-plugin. Here we observe innodb_adaptive_flushing in action (which is ON by default), and I think innodb_adaptive_flushing in InnoDB-plugin is not quite balanced, it may do overaggressive flushing…
