…InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks…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… on CentOS / …
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
…benchmark was run on a DELL server running CentOS…InnoDB buffer was used. In CPU-bound case innodb_buffer_pool_size=2G In IO-bound case innodb_buffer_pool_size=512M innodb_flush_method…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
…in RedHat / CentOS 5.x may be not so good for MySQL. And …writes (column bo in vmstat) during benchmark As you see noop / deadline …innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_write_io_threads=4 innodb_read_io_threads=4 innodb_io_capacity=800 innodb…
