… 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…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… existing slaves using mylvmbackup or a method that is derived from that. Essentially, we are using FLUSH TABLES WITH READ LOCK, and…, we bring up the new mysqld, which finds a crashed innodb, recovers this, and then it is being configured to become… recovery of the innodb in the target location fails, though, even though it has been made even under FLUSH TABLES WITH READ…
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
…… I can set some InnoDB options! I’m going to try the obvious first: innodb-flush-method, sync-frm and innodb-flush-log-at-trx-commit. There is an undocumented option for innodb-flush-method called “nosync” that is meant to not flush…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… InnoDB configured for this hardware innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 1900M innodb…
Post: Benchmarks of new innodb_flush_neighbor_pages
January 17, 2012 By 6 Comments
… on 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… 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: 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…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 innodb…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer… rules can be established. I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for scalability… not showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987, used…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed… unless you’re piping large blobs to Innodb in this case increase it a bit. innodb_flush_log_at_trx_commit=2 If… your application and default which is 8 is decent start innodb_flush_method=O_DIRECT Avoid double buffering and reduce swap pressure, in…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… are still done similar way ? Other the years variables like innodb_thread_concurrency were added with rather complicated history of changes… less understandable with value 0 meaning disabling Innodb internal thread queuing. Another one is innodb_flush_logs_at_trx_commit – initially it had… and 1. Interesting enough in some cases Innodb team does get things right. innodb_flush_method variable does not use value 0,1,2…
