14.2.2. Administering InnoDB

Managing the data files that represent the system tablespace, InnoDB tables, and their associated indexes. You can change the way these files are laid out and divided, which affects both performance and the features available for specific tables.

Managing the redo log files that are used for crash recovery. You can specify the size of these files.

Making sure that InnoDB is used for the tables where it is intended, rather than a different storage engine.

General administrative tasks related to performance. You might consult with application developers during the application design phase, monitor performance on an ongoing basis to ensure the system settings are working well, and diagnose and help fix performance and capacity issues that arise suddenly.