…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 27 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 38 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 11 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: How many partitions can you have ?
December 5, 2009 By 18 Comments
… 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…
