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

II. Advanced Database Design Concepts

4 Designing for Speed

5 Using Constraints to Improve Performance

6 Understanding the MySQL Optimizer

7 Indexing Strategies

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 ...

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