May 25, 2012

Post: Using MyISAM in production

… LOCK TABLES/UNLOCK TABLES) be careful. This option may improve performance dramatically in certain cases by avoiding flushing dirty index blocks… factor and performance requirements, not to mention different load: Log tables. Now Archive storage engine can be even better. Read only data, especially packed with myisampack. This can’t be corrupted or updated and…