…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… of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I …
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables…) 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…
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: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… ~58GB. MySQL version: 5.5.16 Initial 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…
Post: Benchmarks of new innodb_flush_neighbor_pages
January 17, 2012 By 6 Comments
… intention to flush as many pages as possible in singe sequential write. So we added new innodb_flush_neighbor_pages=cont method, with it… have ? Let’s run some benchmarks. We repeated the same benchmark I ran in Disaster MySQL 5.5 flushing, but now we used two… we have longer and deeper periods when MySQL stuck in flushing, and in such cases, the innodb_flush_neighbor_pages=cont only helps to…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for …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…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… 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…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… I ran the tpcc-mysql benchmark with 500W (about 50GB of data) on the FusionIO 160GB SLC card. For innodb_buffer_pool_size…:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 64M innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=16 innodb…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…innodb_locks_unsafe_for_binlog = 1 innodb_max_dirty_pages_pct=15 innodb_support_xa=0 innodb_flush_method = O_DIRECT First the options are somethat benchmark…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
… tpcc-mysql benchmark with 500W using Percona Server 5.5.8. Here is relevant part of config what I used innodb_…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…
