…from 100G table. No matter if it’s InnoDB or MyISAM, you’d usually ALTER TABLE `huge_table…tables with read lock, (3) swap .frm files while keeping mysql suspended and (4) unlock the tables afterwards: — 1. mysql> CREATE TABLE `huge_table…00 sec) mysql> INSERT INTO `huge_table` (text) VALUES (‘test…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…MyISAM tables. Though the difference can be related to the size of set of empty tables which is about 10 times smaller for MyISAM…files does not affect performance a lot on reads – what is about writes ? I tried again very simple test inserting…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-only tables … insertion, because you can write CSV files with any programming language. Naturally, CSV files … custom table, which is really constructed behind the scenes from the name-value tables in …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…also contain adaptive hash indexes, insert buffer, locks which also… doing work with huge temporary tables and otherwise running…tables but there are other things you need OS cache for – MyISAM tables (mysql database, temporary etc) will need it, .frm file… always save you from swapping. Some specific …
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… difference in Performace with MyISAM and Innodb is huge for read only workload it… have kind of middle point insertion so full table scan do not wipe it…700 bytes or something like that from any blob/string in the page…unique. Tablespaces. To call “innodb_file_per_table” option tablespaces is a joke. …
