MySQL supports a number of different storage engines. When you create a table, by default MySQL will use the MyISAM storage engine to create a MyISAM table. MyISAM is a relatively simple table type, which forgoes several advanced features in order to offer improved performance. In the early days of MySQL, the MyISAM table type was instrumental in making it one of the best performing databases around.

Link:
http://www.sitepoint.com/…

Check out these posts too:

  1. MySQL 5.1 coming with fixes and performance upgrade
  2. Useful MySQL SQL statements
  3. Top 5 MySQL Admin tools
  4. Periodic Table of the Internet
  5. How FriendFeed uses MySQL to store schema-less data
  6. Top 20+ MySQL Best Practices
  7. Top 10 CSS Table Designs