This blog post is part two in what is now a continuing series on the … is another advantage of InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is cold….1, Q4.2) but worse when small amounts of data are examined. Conclusion In some cases MyISAM is faster than InnoDB, but usually…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…part in a two-part series comparing Virident’s vCache to FlashCache. The first part… vs….innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-…comments in Part 2). There MyISAM shows bad scalability with increasing count of thread. I think the reason is pread system call MyISAM uses…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…MyISAM vs Innodb. …| YES | BTREE | | | antest | 1 | c | 2 | i | A | NULL | NULL | …| Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +——–+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference is I… model name : Dual-Core AMD Opteron(tm) Processor 2210 stepping : 2 cpu MHz : 1800.163 cache size : 1024 KB 4GB of…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 9, 2007 By 117 Comments
…InnoDB vs. MyISAM vs. Falcon in MySQL MySQL Performance Blog — InnoDB vs MyISAM vs Falcon benchmarks. Great test and lots of figures and graphs. … of work (2) MyISAM toasts InnoDB in read performance is a myth. InnoDB rules for now with low concurrency. Eagerly waiting for part II. Tagged…
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: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… NULL, PRIMARY KEY (id), KEY state (state) ) ENGINE=MyISAM; 2) Table with VARCHAR: CREATE TABLE cities_varchar ( id…than for MyISAM. This is great example of the case when Innodb is much faster than MyISAM for Read …case but this is other story. To avoid part of this problem we of course arrange state…
Comment: Choosing innodb_buffer_pool_size
November 4, 2007 By 39 Comments
… this becomes rather tricky question – it depends on sizes of MyISAM vs Innodb as well as workload. Generally you ever have to use… I would use 2:1 split towards giving more memory to Innodb ans then for MyISAM part use about 1/3-1/2 for Key buffer and just use other part as extra OS cache as MyISAM…
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…
