https://dev.mysql.com/innodb-backup.html
In conjunction with the MySQL binary log, users can perform point-in-time recovery. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly by ...
https://dev.mysql.com/innodb-best-practices.html
Committing hundreds of times a second puts a cap on performance (limited by the write speed of your storage device). Specifying a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is ...
https://dev.mysql.com/innodb-buffer-page-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 15.15.5, “InnoDB ...
https://dev.mysql.com/innodb-deadlock-detection.html
Resolve these situations by setting the value of the innodb_lock_wait_timeout system variable. At times, it may be more efficient to disable deadlock detection and rely on the innodb_lock_wait_timeout setting for transaction rollback when a deadlock ... When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the ...
https://dev.mysql.com/innodb-dedicated-server.html
Automatically configured settings are evaluated and reconfigured if necessary each time the MySQL server is started. When innodb_dedicated_server is enabled, InnoDB automatically configures the following variables: innodb_buffer_pool_size ...
https://dev.mysql.com/innodb-doublewrite-buffer.html
The maximum number of doublewrite files is two times the number of buffer pool instances. The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before writing the pages to their proper positions in the ...
https://dev.mysql.com/innodb-enabling-monitors.html
InnoDB monitor output begins with a header containing a timestamp and the monitor name. The --innodb-status-file option is intended for temporary use, as output generation can affect performance, and the innodb_status.pid file can become quite large ... When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, ...
https://dev.mysql.com/innodb-file-defragmenting.html
Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> 12345; The preceding query requires MySQL to perform a full table scan, the slowest type ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/innodb-file-per-table-tablespaces.html
An innodb_file_per_table setting can be specified in an option file or configured at runtime using a SET GLOBAL statement. Changing the setting at runtime requires privileges sufficient to set global system variables. Option file: [mysqld] ... A ...
https://dev.mysql.com/innodb-ft-index-cache-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set ...
