InnoDB Backup and Recovery For related information, see Section 15.5.2, “Change Buffer” , and Section 15.5.3, “Adaptive Hash Index” . This section displays information about the  InnoDB  log. The contents include the current log sequence number, how far the log has been flushed to disk, and the position at which  InnoDB  last took a checkpoint. (See Section 15.11.3, “InnoDB Checkpoints” .) The section also displays information about pending writes and write performance statistics. This section gives you statistics on pages read and written. You can calculate from these numbers how many data file I/O operations your queries currently are doing. For buffer pool statistics descriptions, see Monitoring the Buffer Pool Using the InnoDB Standard Monitor. For additional information about the operation of the buffer pool, see Section 15.5.1, “Buffer Pool” . This section shows what the main thread is doing, including the number and performance rate for each type of row operation. This section covers topics related to  InnoDB  backup and recovery. The key to safe database management is making regular backups. Depending on your data volume, number of MySQL servers, and database workload, you can use these backup techniques, alone or in combination: hot backup with  MySQL Enterprise Backup ; cold backup by copying files while the MySQL server is shut down; logical backup with  mysqldump  for smaller data volumes or to record the structure of schema objects. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the  mysqld  server for faster restore. Using  MySQL Enterprise Backup  is the recommended method for backing up  InnoDB  data. InnoDB  does not support databases that are restored using third-party backup tools. The  mysqlbackup  command, part of the MySQL Enterprise Backup component, lets you back up a running MySQL instance, including  InnoDB  tables, with minimal disruption to operations while producing a consistent snapshot of the database. When  mysqlbackup  is copying  InnoDB  tables, reads and writes to  InnoDB  tables can continue. MySQL Enterprise Backup can also create compressed backup files, and Note Hot Backups 3346 • LOG • BUFFER POOL AND MEMORY • ROW OPERATIONS •For information about backup techniques applicable to  InnoDB , see Section 15.18.1, “InnoDB Backup” . •For information about point-in-time recovery, recovery from disk failure or corruption, and how  InnoDB performs crash recovery, see Section 15.18.2, “InnoDB Recovery” . 15.18 InnoDB Backup and Recovery 15.18.1 InnoDB Backup