… by threads running queries. On Unix/Linux you will always see 4 helper threads, on Windows it however can be adjusted by innodb_file_io_threads variable. For each helper thread you can see thread state – if thread is…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… IO bound load. InnoDB parameters: innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 3 innodb…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… key and promoting real one to unique. Tablespaces. To call “innodb_file_per_table” option tablespaces is a joke. It is better… manually 
I/O On Linux you’re currently limited to innodb_file_io_threads=4. Some people do not know it but setting it… years) is Async IO support in Linux. It should be very helpful with direct IO as well as with innodb_file_per_table=1…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… default InnoDB uses 1 insert buffer thread, 1 log thread, 1 read thread, 1 write thread. With innodb_file_io_threads InnoDB will use 1 insert buffer thread, 1 log thread, N/2-1 read thread, N/2-1 write thread. You can start from “innodb_file_io_threads…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… 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_max…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…_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_io_threads=16 innodb_io_capacity…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io_threads…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log_at_trx_commit=0 #innodb_log_file…
Comment: xtrabackup-1.2
May 10, 2010 By 2 Comments
… is disabled InnoDB: Mutexes and rw_locks use InnoDB‘s own implementation InnoDB: Warning: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb_write_io_threads instead InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB…
