https://dev.mysql.com/group-replication-summary.html
A replication group is formed by multiple servers and each server in the group may execute transactions independently at any time. Group Replication is a technique that can be used to implement fault-tolerant systems. The replication group is a set ...
https://dev.mysql.com/group-replication-upgrade.html
While you are in the process of upgrading an online group, in order to maximize availability, you might need to have members with different MySQL Server versions running at the same time. If your group needs to remain online, as is common with ...
https://dev.mysql.com/handler-scope.html
A stored program may include handlers to be invoked when certain conditions occur within the program. The applicability of each handler depends on its location within the program definition and on the condition or conditions that it handles: A ...
https://dev.mysql.com/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.16, ...
https://dev.mysql.com/index-hints.html
Thus, you should expect USE INDEX, FORCE INDEX, and IGNORE INDEX to be deprecated in a future release of MySQL, and at some time thereafter to be removed altogether. Index hints give the optimizer information about how to choose indexes during ...
https://dev.mysql.com/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...
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 ...
