…_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be done by key… total block if there are long selects running. Fragmentation. This is common problem for pretty much all…avoiding flushing dirty index blocks from key_buffer to disk, but it also comes at great danger if MySQL…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…_fast_index_creation, because temporary files for merge-sorting are created in… mentioning is fragmentation. Fast index creation results in much less fragmented indexes …_index_creation is OFF to avoid dropping keys that are part …. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index …
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
…increase in size significantly due to fragmentation. Usage Differences What works well …commit. You also may want to avoid excessive SELECT COUNT(*) FROM TBL (with…defaults for Innodb. First Depending on MySQL version they may be somewhere …_buffer_pool_size and innodb_log_file_size. There are a lot …
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
…course but meta data such as original image sizes, file size as well as thumbnail location on the …MyISAM tables in case of MySQL/System crash is painful and great to be avoided. Long primary key – why …table would also be slow as it is quite fragmented. Table however is not getting any table scans …
