… MyISAM for everything!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with. MyISAM does not maintain checksum consistency during regular operations and is not ACID compliant. MyISAM… sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and the… will be caught by ZFS and the data will be read from the other drive in the mirror. Better availability and…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… something you’re not that familiar with, I’d suggest reading over the manual’s description of how replication filtering rules… anything quite like that in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… implementation is considered BETA quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the… bug #65077 from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… not see the difference. However…. 1. If you have uneven reads across the DB (most appearing in one section …latest writes… single table, where probably only recently read records will be cached, resulting in more disc reads. 2. If you need to delete… partition (at least I have seen this happen in a MyIsam environment on similar sized tables). What I am really saying…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB… values. MyISAM scales very bad, and reason is the same as for READ_KEY_POINT queries. InnoDB is better than MyISAM by 2-26 times and than Falcon by 1.64 – 3.85 times. READ…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… were recently number of posts about MyISAM, for example Arjen wrote pretty nice article about MyISAM features so I thought I would… this happened make sure you have decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be… MyISAM are rather fast so it rarely is the problem The other misconception about table locks is if you have 95% reads…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… similar to read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only. But talking to Monty today I learned it is not the case. read_rnd_buffer can be used for All storage engines not only by MyISAM. It is used for some sorts to optimally read…
