…] /usr/sbin/mysqld: Incorrect key file for table ‘/tmp/#sql_21b2_0.MYI’;…what really happened. MySQL created a temporary table, using the MyISAM storage engine, and when the disk filled up, MyISAM…Good examples are error 13 (permission denied) or 2 (No such file or directory). The typical reaction is…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
… missing in MyISAM and vice-versa. MyISAM is like a dog and InnoDB is like a cat. Dogs love you no matter what, will always…, is more easily tuned and a system that will run even when things aren’t quite right. My point is, MyISAM is still a good engine for a lot of situations and InnoDB is not the silver bullet that solves…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 28 Comments
… a very helpful article! It is just what I needed to convert a 330GB MyISAM database to InnoDB with reasonable effort. … the beginning of the main loop. Then it works for me like a charm transferring the biggest table we … the mistake with the binary data). Keep posting the good stuff 
Stefan
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… rows in the table for many decisions but this is computed live (maintained for MyISAM and estimated during query execution for Innodb). This basic information… what ? What really matters is not how accurate stats are but how good plans you’re getting for your queries. If you’re getting as good…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… storage engine so must use on disk MyISAM temporary table. What i decided to do is to see how much overhead do on… performing group by which is overhead we’re not looking to measure. This is actually good trick to use for cases when you do… this was too many details for you to read through here is the summary: key_buffer_size is important for MyISAM temporary tables performance to…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… view on using MyISAM in production. For me it is not only about table locks. Table locks is only one of MyISAM limitations you need… selects running. Fragmentation. This is common problem for pretty much all storage engines. It is however also different. MyISAM has in-row fragmentation which… sets or crashes. Here is my list what I think MyISAM tables are good to be used for. This list is not inclusive and every system…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… big one is COUNT(*) without where clause which is often the show stopper for them move until it is worked around. Operations What is good for MyISAM kills Innodb, such as copying binary tables between the servers. It is important…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…for your Innodb tables but there are other things you need OS cache for – MyISAM… good estimates for this number. Eliminate Double Buffering – This is again very important for buffer…what is more important Innodb algorithms are finely tuned with consideration what is in memory and what is on disk, for…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
…What cache hit rate is good for optimal MySQL Performance” is typical question I’m asked. It could by MyISAM key_buffer or Innodb innodb_buffer… ratio 99% for what would be 0% in many peoples mind. But what is even more important is hit ratio is not directly relevant for performance. Take…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what…more sensitive to buffer size compared to MyISAM. MyISAM may work kind of OK with default…some memory but for modern hardware it is typically not the problem. 1024 is good value for applications with…
