In order to promote flexibility and choice, MySQL allows you to select what "type" of table it will create - you have the choice of MyISAM, which is the default type, InnoDB, and BDB. Of these, MyISAM and InnoDB are popular, and both offer their own advantages.
MyISAM is the default - it is very, very fast for reading and writing data of all types, which is its main feature. Over the years it has acquired more features, but ultimately it looks like it will be replaced by another table type in the long-term, called Falcon.
InnoDB support transactions and foreign keys, as well as row-level locking - this potentially allows it to update rows faster. However, on the whole you will find that InnoDB is a great deal slower than MyISAM. Unless you specifically require something that InnoDB offers, I suggest you stick with MyISAM.
Copyright 2012 Future Publishing Limited (company
registered number 2008885), a company registered
in England and Wales whose registered office is at