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

13. Improving Disk Speed

This book has continually pointed out the benefits of rapidly processing information in memory whenever possible, rather than incurring the higher costs of disk interaction. However, eventually the piper must be paid, and the disk must be accessed. This chapter discusses a number of steps that administrators can take to keep these performance-draining disk charges as low as possible.

The chapter is divided into three major sections. The first provides general (that is, MySQL storage engine and operating system–neutral) suggestions on how to accelerate disk performance. The next section presents MyISAM and InnoDB-specific recommendations for getting the most out of your disk drives. Finally, the chapter ...

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