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

12. InnoDB Performance Enhancement

Now that you’ve explored general MySQL database engine-tuning options, as well as specific things you can do to boost MyISAM performance, this chapter turns your attention to increasing the InnoDB storage engine’s responsiveness.

This chapter begins by examining the InnoDB data storage architecture, as well as how to make all disk I/O operations as efficient as possible. Next, it studies how to leverage InnoDB’s powerful memory management capabilities. Finally, it reviews several ways that administrators can provide guidance to InnoDB to improve operational activities.

Before this chapter begins, you should note the following important points:

• This chapter only focuses on those InnoDB server ...

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