content_image/859756.jpg
For related information, see Section 15.5.2, “Change Buffer” , and Section 15.5.3, “Adaptive Hash Index” . 

• LOG 

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. 

• BUFFER POOL AND MEMORY 

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” . 

• ROW OPERATIONS 

This section shows what the main thread is doing, including the number and performance rate for each type of row operation. 

## 15.18 InnoDB Backup and Recovery 

This section covers topics related to InnoDB  backup and recovery. 

•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.1 InnoDB Backup 

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. 

## Hot Backups 

<img src='content_image/859756.jpg'>

## Note 

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 

