Taking time to properly design your project’s table structures is key to its success. Neglecting to do so can have dire consequences not only on storage requirements, but also on application performance, maintainability, and data integrity. In this chapter, you’ll become better acquainted with the many facets of MySQL table design. By its conclusion, you will be familiar with the following topics:
The purpose, advantages, disadvantages, and relevant configuration parameters of MySQL’s key storage engines, namely ARCHIVE, BLACKHOLE, CSV, EXAMPLE, FEDERATED, InnoDB, ...
