This chapter will primarily compare MyISAM and InnoDB. It will look at Drupal's history of being designed for MyISAM, and talk about some of the Drupal-specific pitfalls with using InnoDB. It will then explain the many advantages to using InnoDB, presenting this as currently being the only serious option for large high traffic websites using MySQL. This chapter will also briefly look at some of the up and coming MySQL storage engines currently being developed.
- Storage Engines
- Concepts
- Mix and Match
- MyISAM
- Strengths
- Weaknesses
- InnoDB
- Strengths
- Weaknesses
- Previews
- Falcon
- Maria
