O'Reilly logo

MySQL by Robert D. Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4. Designing for Speed

Choosing the Right Storage Engine and Table Type

MySQL’s rich functionality and flexibility can be overwhelming: You have so many choices when constructing your MySQL-based solution. This is especially true when designing your database. MySQL offers an ever-increasing number of different storage engines and table types. This section reviews the various types of engines, along with how to select the best-performing option for your specific situation.

Before beginning the examination of your options, keep in mind one important MySQL flexibility feature: You can employ a mixture of different storage engine and table type configurations at the same time, usually without needing to make changes to your ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required