…would not honor –file-extra-flags during “prepare” phase and instead of having files created using …= ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_…benchmarks for the same setting. Summary For the two workloads that are most relevant to databases – …
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
…taken only for last 1h to remove warm-up phase Parameters to vary: we vary innodb_buffer_pool_…different memory/data ration. And we test it on two storages: HDD RAID10 and Intel SSD 910 Results …results are received with innodb_flush_log_at_trx_commit=2, which in comments to previous post was called…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… my experience was totally flawless, I bumped into two bugs: MySQL 5.6.7 locks itself on …only for last 2000 sec to remove warm-up phase. Measurements are taken every second. Parameters to vary: …log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 125G innodb_buffer_…
