5.3. Managing Disk I/O and File Space for InnoDB Tables

5.3.1. InnoDB Disk I/O
5.3.2. File Space Management
5.3.3. InnoDB Checkpoints
5.3.4. Defragmenting a Table

As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space to avoid filling up storage devices. The ACID design model requires a certain amount of I/O that might seem redundant, but helps to ensure data reliability. Within these constraints, InnoDB tries to optimize the database work and the organization of disk files to minimize the amount of disk I/O. Sometimes, I/O is postponed until the database is not busy, or until everything needs to be brought to a consistent state, such as during a database restart after a fast shutdown.

This section discusses the main considerations for I/O and disk space with the default kind of MySQL tables (also known as InnoDB tables):

Spec-Zone.ru - all specs in one place