In Drupal 7 InnoDB will replace MyISAM as the default storage engine for increased scalability and data integrity. Most big sites are already using InnoDB, drupal.org does since some time. InnoDB is generally a better choice for Drupal so why wait for Drupal 7.