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-configuring-instances.html
The second server joining asks the one and only member in the group to join, any missing data on the second server is replicated from the donor data on the bootstrapping member, and then the group expands. This section explains the configuration ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-failure-detection.html
If a member does not receive messages from another member for 5 seconds, it suspects that the member has failed, and lists the status of that member as UNREACHABLE in its own Performance Schema table replication_group_members. If a suspicion lasts ... Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-methods.html
In other words servers with a newer version can join the group only as secondaries. Rolling Migration Upgrade In this method you remove members from the group, upgrade them and then create a second group using the upgraded members. Rolling ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned issues. As long as the ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
If a timeout is specified, and timeout seconds elapse before all of the transactions in the GTID set have been applied, the function stops waiting. timeout is optional, and the default timeout is 0 seconds, in which case the function always waits ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
In the second statement, only rows with 'Pat' <= key_col < 'Pau' are considered. In the second statement, the LIKE value is not a constant. Understanding the B-tree and hash data structures can help predict how different queries perform on ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-per-index-table.html
For a compressed InnoDB table, both the table data and all the secondary indexes are compressed. COMPRESS_TIME The total time in seconds used for compressing data in this index. UNCOMPRESS_TIME The total time in seconds used for uncompressing data ... The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you evaluate the performance and usefulness of compression for specific ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-table.html
COMPRESS_TIME The total time in seconds used for attempts to compress B-tree pages of size PAGE_SIZE. UNCOMPRESS_TIME The total time in seconds used for uncompressing B-tree pages of the size PAGE_SIZE. The INNODB_CMP and INNODB_CMP_RESET tables ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html
DURATION How long statement execution remained in the given state, in seconds. Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.30, “SHOW PROFILE Statement”). The table is ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
Example usage: innochecksum --version --verbose, -v Command-Line Format --verbose Type Boolean Default Value false Verbose mode; prints a progress indicator to the log file every five seconds. Because --allow-mismatches is set to 1, the checksum ...