PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/innodb-best-practices.html
Committing hundreds of times a second puts a cap on performance (limited by the write speed of your storage device). Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/innodb-deadlock-example.html
If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction InnoDB rolls ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disabling-tablespace-path-validation.html
Disabling path validation improves startup time on systems with a large number of tablespace files. At startup, InnoDB scans directories defined by the innodb_directories variable for tablespace files. The paths of discovered tablespace files are ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/innodb-information-schema-compression-tables.html
There are two pairs of InnoDB INFORMATION_SCHEMA tables about compression that can provide insight into how well compression is working overall: INNODB_CMP and INNODB_CMP_RESET provide information about the number of compression operations and the ...INNODB_CMPMEM and INNODB_CMPMEM_RESET provide information about the way memory is allocated for ...