Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
Note that if the joining member exhausts the list of advertised endpoints without making a connection, it does not fall back to the donor's standard SQL client connection, but switches to another donor. Note that if a remote cloning operation is ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-ip-address-permissions.html
Note When the MySQL communication stack is used for establishing group communications (group_replication_communication_stack=MYSQL), the setting for group_replication_ip_allowlist is ignored. Note When a connection attempt from an IP address is ...
https://dev.mysql.com/doc/refman/8.4/en/index.html
For information about which versions have been released, see the MySQL 8.4 Release Notes. For notes detailing the changes in each release, see the MySQL 8.4 Release Notes. Including MySQL NDB Cluster 8.4 Abstract This is the MySQL Reference Manual.
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
FOUND_ROWS() Note The SQL_CALC_FOUND_ROWS query modifier and accompanying FOUND_ROWS() function are deprecated; expect them to be removed in a future version of MySQL. Note that mysql_insert_id() is only updated after INSERT and UPDATE statements, ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
Note Comparison behavior for database and table names in INFORMATION_SCHEMA queries might differ from what you expect. Note If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
Note If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the data dictionary, which use InnoDB. The information_schema_stats_expiry system variable defines the period of time ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
Note innodb_stats_persistent_sample_pages defines the number of pages sampled at a global level. Note All 4 MiB may not be read from disk, as some leaf pages may already be cached in the buffer pool. ANALYZE TABLE complexity for InnoDB tables is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
InnoDB AUTO_INCREMENT Lock Modes InnoDB AUTO_INCREMENT Lock Mode Usage Implications InnoDB AUTO_INCREMENT Counter Initialization Notes InnoDB AUTO_INCREMENT Lock Modes This section describes the AUTO_INCREMENT lock modes used to generate ... InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
ERROR 1031 (HY000): Table storage engine for 't1' doesn't have this option Note The table is not created if the current configuration does not permit using compressed tables. | ... This section describes syntax warnings and errors that you may ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
Note When undo log encryption is disabled, the server continues to require the keyring component or plugin that was used to encrypt undo log data until the undo tablespaces that contained the encrypted undo log data are truncated. For example: ...