… over, but still the tool serves well for benchmark purposes. OK, let’s start off with the …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: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… benchmark, which 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… ? Let’s run some benchmarks. We repeated the same benchmark I ran in Disaster MySQL 5.5 flushing, but now we used two…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks I… innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_flush_method=O_DIRECT innodb_file_per_table = 1 And for XtraDB I additionally used: innodb_io_capacity = 10000 innodb_adaptive_checkpoint = 1 innodb_write…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log_file_size=256M innodb_flush_method=O_DIRECT for Innodb. The tables… times. Innodb in single tablespace mode showed following results: [root@DB10 ~]# for i in 1 10 100 1000 10000; do ./benchmark.php…. Innodb with innodb_file_per_table=1 had the following results: [root@DB10 ~]# for i in 1 10 100 1000 10000; do ./benchmark…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
…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… innodb-log-block-size ( 512 bytes), and another with –innodb-log-block-size=4096. Full benchmark command…
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: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…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…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
… innodb_write_io_threads = 8 innodb_flush_method = O_DIRECT innodb_thread_concurrency = 0 innodb_ibuf_active_contract = 1
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…run every fileio benchmark and an IO bound read-write oltp benchmark in autocommit mode. File IO benchmark For the FileIO benchmark, I … innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb…
