…InnoDB vs. MyISAM vs. Falcon in MySQL MySQL Performance Blog — InnoDB vs MyISAM vs Falcon benchmarks. Great test and lots of figures and graphs. It highlights two things. (1… after 11 months of work (2) MyISAM toasts InnoDB in read performance is a myth. InnoDB rules for now with low concurrency. Eagerly…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…I’ll show graphs for more interesting… — 909 iops unaligned -vs- 1049 aligned. Random…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… simplier – you do not have to deal with complicated lock graphs or rely on timeout for deadlock resolution. For workloads with…> select * from test2; +—-+———–+ | id | names | +—-+———–+ | 1 | Mysql | | 2 | Solid | | 3 | MyISAM | +—-+———–+ Session1: mysql> begin; Query OK, 0 rows affected (0.00… are InnoDB sessions: Test 1: Deadlock detection (deadlock is correctly detected): insert into test2 values (1,’Mysql’),(2,’Solid’),(3,’MyISAM‘); Session1…
