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