PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-tuning-recovery.html
The following statement sets the maximum number of attempts to connect to a donor to 5: mysql> SET GLOBAL group_replication_recovery_retry_count= 5; For remote cloning operations, this limit does not apply. Sleep Interval for Connection Attempts For ... Several aspects of Group Replication's distributed recovery process can be configured to suit your ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-session-temp-tablespaces-table.html
Session temporary tablespaces are recreated each time the server is started. The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html
InnoDB is aware of table locks if innodb_table_locks = 1 (the default) and autocommit = 0, and the MySQL layer above it knows about row-level locks. Otherwise, InnoDB cannot detect deadlocks where a table lock set by a MySQL LOCK TABLES statement or ... 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-enabling-monitors.html
When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, approximately. InnoDB monitor output begins with a header containing a timestamp and the monitor name.
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 ...To speed up index scans, you can periodically perform a “null” ALTER TABLE operation, which causes MySQL to rebuild the table: ALTER TABLE tbl_name ENGINE=INNODB You can also use ALTER TABLE tbl_name FORCE to perform a “null” alter operation that rebuilds the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-internal-data.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-understanding-innodb-locking.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-failure-conditions.html
A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and final phases of the DDL operation. The tmpdir or innodb_tmpdir file system runs out of disk space, while MySQL writes temporary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-optimize-tablespace-page-allocation.html
As of MySQL 8.0.22, you can optimize how InnoDB allocates space to file-per-table and general tablespaces on Linux. As of MySQL 8.0.22, you can disable innodb_extend_and_initialize on Linux systems to avoid physically writing NULLs to newly ...By ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-restrictions-limitations.html
mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name 'db_row_id' SHOW TABLE STATUS does not provide accurate statistics for InnoDB tables except for the physical size reserved by the table. InnoDB ... This section describes restrictions and limitations of the InnoDB storage ...