… anything quite like that in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external… to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… #*** 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_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… Inconsistencies and May Not Even Work! MyISAM tables are supported within Percona XtraDB Cluster, however, MyISAM has only basic support, primarily because… who wants to, but still have MyISAM tables. You can still try by filtering MyISAM tables though if you can leave them… internally within the cluster, this is to avoid collisions when INSERTs are happening on not only a single node. However, this…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…_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
… a normal table as against a partitioned table. 2. The Insert should be quicker on a partitioned table, as it will… come out of the partition, not the whole table. 3. Insert on Duplicate Key (I dont do replace… ever)… if across… a MyIsam environment on similar sized tables). What I am really saying is that its not only about the ‘Selects’ and Inserts…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
…, 23B rows. Not small… I calculated that with something like insert into MyISAM_table… select * from Innodb_table… would take about 10… concurrency so I kicked off, from a script, insertions into 16 identical MyISAM files for distinct parts of the table. That was… was simply to do insert into MyISAM_table select * from MyISAM_table1 and so on for the 16 files. Since MyISAM are flat files…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… this happened make sure you have decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be…. MyISAM uses table locks and has concurrent inserts which can go concurrently with selects. This is sometimes presented as great concurrency for inserts… select statements but it has to be one insert at the time. Happily inserts in MyISAM are rather fast so it rarely is…
Post: MyISAM concurrent insert
June 13, 2006 By 12 Comments
Arjen posted a good note about MyISAM concurrent-insert features, though I should mention concurrent-insert can be cause of scalablity and peformance… using range-queries and doing INSERT not often than disabling concurrent-insert with –skip-concurrent-insert can improve MyISAM performance. As I said the…
Post: MyISAM mmap feature (5.1)
May 26, 2006 By 10 Comments
…=1 startup option. In this case instead of systems call MyISAM will use memcpy function. There is a memory addressing limit…/INSERT inside file queries, and no performance gain (maybe a bit slower) for INSERT at the end of file. In case with INSERT…) UPDATE non key column (updaye-nokey) OLTP rw queries, SELECT/INSERT/DELETE/UPDATE queries (OLTP rw) batch select queries – scan of…
Post: Beware of MyISAM Key Cache mutex contention
August 12, 2008 By 10 Comments
… use multiple cores efficiently to get good insert rate… or so it seemed. In reality inserting in parallel into different tables when… copied from key_cache to the thread local space. Happily MyISAM allows you to create multiple key caches . We use “keycache… columns. Honestly I did not expect so large difference for Inserts. I have already wrote about very large impact on joins…
