… speed. Depending on load type MyISAM may benefit from bulk_insert_tree_size increase myisam_sort_buffer_size or key_buffer_size increase. Innodb typically needs large innodb_buffer_pool_size and large innodb_log_file… make sure MyISAM build indexes via sorting not by BTREE insertion. For Innodb SET UNIQUE_CHECKS=0 may be used to speed up…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… be IO bound. As you can see from MyISAM results (above) the insert speeds does not degrade that badly until going from… scan performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well) – Innodb suffers fragmentation less…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
… that produced this benchmark. I am interested in general, innodb, and myisam settings and installation configuration of the machine. I am interested…, processor cache, RAM size, front side bus speed, harddrive rpms, harddrive max write speed, and operating system. Also are you doing multiple…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… | 23.59G … Locator Size Speed Form Factor Type Type Detail ========= ======== …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…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… you have some hardware problems (99%) or found new Innodb bug (1%) Innodb recovery should be automatic and bring your database to… also mention if you have innodb_file_per_table=1 your recovery speed will depend on number of Innodb tables you have, as…, but also – warmup takes longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in tables, instead it…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 59 Comments
… about using MyISAM (not using it that is) and that if not using InnoDB you aren’t too smart. However, InnoDB brings a lot of cons to the table which are missing in MyISAM and vice-versa. MyISAM is like a dog and InnoDB… not use MyISAM. If none of the above apply, then you get the benefits of MyISAM which includes consistently faster query speeds, tables…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for… to repeat and test – just run Innodb from the RAM drive 
Next I tested MyISAM which is well known for its simplicity… from MyISAM (double of Innodb already) which scaled to 70.000 queries/sec peaking out at 16 threads. However even with MyISAM we…
Comment: High-Performance Click Analysis with MySQL
December 23, 2008 By 13 Comments
… is really some conflict here – to get the best aggregation speed you need to aggregate chunk at once. Merging 100000 events… data compact. 4) MyISAM vs Innodb – if you have read only data you can often get data clustering with MyISAM too by ALTER TABLE … ORDER BY X. It is not same as with Innodb (data is never…
Comment: Using CHAR keys for joins, how much is the overhead ?
June 19, 2007 By 18 Comments
… slowed down join speed for MyISAM tables from 1.7 seconds to 3.8 seconds, which is slower than Innodb with chars. Note… one is LATIN1 which improved join speed from 6.1 to 4.4 seconds for Innodb tables. Using VARBINARY instead gave about…” varchar join tests for Innodb table with utf8 encoding. This caused some degradation slowing down join speed from 4.5 seconds to…
Post: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
…which can be showstoppers for many applications when MyISAM would be sufficient otherwise. But this is only…MVCC and row level locks functionally close to Innodb or Falcon. Though many internal architecture decisions are… and the best thing you can do to speed up this process is download maria and …
