MediaWiki:Config-mysql-engine-help
InnoDB is almost always the best option, since it has good concurrency support.
MyISAM may be faster in single-user or read-only installations. MyISAM databases tend to get corrupted more often than InnoDB databases.