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 ...
Get MySQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
