https://dev.mysql.com/information-schema-introduction.html
Other terms that are sometimes used for this information are data dictionary and system catalog. INFORMATION_SCHEMA queries that search for information from more than one database might take a long time and impact performance. INFORMATION_SCHEMA ...
https://dev.mysql.com/innochecksum.html
To turn on verbose mode, run: shell> innochecksum --verbose To turn off verbose mode, run: shell> innochecksum --verbose=FALSE The --verbose option and --log option can be specified at the same time. This tool reads an InnoDB tablespace file, ...
https://dev.mysql.com/innodb-analyze-table-complexity.html
Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a table * the number of partitions Typically, the greater the resulting ... ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/innodb-backup-recovery.html
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”. This section covers topics related to InnoDB backup and recovery. For ...
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 ...
