II. Advanced Database Design Concepts
5 Using Constraints to Improve Performance
6 Understanding the MySQL Optimizer
This section explores how to design and configure your MySQL database to be as fast as possible.
Chapter 4, “Designing for Speed,” begins by examining the various types of MySQL storage engines, as well as how they should be selected for optimal speed. This chapter also assesses a number of performance-related table configuration parameters, as well as how you can use views to speed and simplify your application. Finally, the chapter discusses situations in which you might want to denormalize your database.
MySQL offers a collection of constraints that you can use to help improve ...
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.
