… the client’s settings (there are some things like innodb_flush_log_at_trx_commit which vary). Here are the settings….txt have_innodb YES ignore_builtin_innodb ON innodb_adaptive_flushing ON innodb_adaptive_hash_index ON innodb_additional_mem_pool_size 2097152… Barracuda innodb_file_per_table ON innodb_flush_log_at_trx_commit 1 innodb_flush_method O_DIRECT innodb_force_recovery 0 innodb…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
… my post MySQL 5.5.8 and Percona Server: being adaptive I mentioned that I used innodb-log-block-size=4096…_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M…_size=4G innodb_adaptive_checkpoint=keep_average innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… note I used innodb_buffer_pool_size = 2G and innodb_flush_method=O_DIRECT to emulate IO bound load. InnoDB parameters: innodb… innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M… innodb_flush_method=O_DIRECT innodb_file_per_table = 1 And for XtraDB I additionally used: innodb_io_capacity = 10000 innodb_adaptive_checkpoint…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure… and reorganizes small portions of table online. Q38: Seems that adaptive hash indexes are not used for primary key lookups or… HT: Strange, primary key equality searches should work through the adaptive hash index! What is your database like? Do you have…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… was doing dirty buffer pool flush list reads to make its adaptive flushing decisions. Fixed by acquiring the flush list mutex around the list… option innodb_flush_method=O_DIRECT was set up, log bitmap files were created and treated as InnoDB data files for flushing purposes…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… finally possible to achieve stable throughput without dips, but an adaptive flushing still requires big log files. MySQL configuration: [mysqld] gdb innodb…_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb…
Comment: MySQL 5.5.4 in tpcc-like workload
April 21, 2010 By 25 Comments
… as I told at UC2010. In another workload, adaptive_flushing may be better. The both methods are worth to try. (But I don…… 
) InnoDB is now improved enough comparatively. So, the each improvement methods are not universal improvement. (specific for some workloads) We should…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… it does not only contain data pages – it also contain adaptive hash indexes, insert buffer, locks which also take some time… to OS cache because there is no copying, due to adaptive hash indexes, ability to buffer writes and number of other… anything. On Linux, FreeBSD, Solaris you need to set innodb_flush_method=O_DIRECT. On other Operating Systems you may be able…
Comment: Which adaptive should we use?
September 16, 2010 By 14 Comments
Yasufumi, I thought innodb_flush_method=O_DIRECT will override doublewrite? (I am confused with doublewrite and double buffering) If that is true what is the implication of the test case with adaptive_flushing with innodb_doublewrite=true? — Ratheesh
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
…_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=8M…=0 innodb_flush_method = O_DIRECT innodb_write_io_threads=4 innodb_read_io_threads=4 innodb_io_capacity=800 innodb_adaptive_checkpoint…
