Administration tasks related to
involve these aspects:
Managing the data files
that represent the system
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.
Making sure that
InnoDB is used for the
tables where it is intended, rather than a different storage
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.
InnoDB tables are now the default for
MySQL, much of the associated administration material is now in the
main “Administration” chapter,
Chapter 5, MySQL Server Administration.