… surprising as in reality only 1 (max 2) partitions got data inserted to them per … remove index on column C – the “UPDATE” part of INSERT ON DUPLICATE KEY UPDATE completes …MyISAM and Innodb are affected by this issue. The Update path for MyISAM without indexes took 10 seconds for 1 partition vs…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2008 By 117 Comments
Very interesting benchmark. Anyway, when will the InnoDB vs MyISAM vs Falcon benchmarks – part 2 availabe ? I’m very curious to see the progress after 1 year from part 1.
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…part…2 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…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…% — 909 iops unaligned -vs- 1049 aligned. Random…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… feedback, so I do my part. Benchmark date: Oct-2012 Benchmark …Xeon(R) CPU E5-2660 0 @ 2.20GHz Memory: 192GB Storage: Very…innodb logfiles to get more stable results. So there it is with 2x4GB vs 2x8GB innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
