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-frequently-asked-questions.html
Alternatively, from MySQL 8.0.21, you can specify them on the START GROUP_REPLICATION statement each time Group Replication is started. Warning When the network round-trip time (RTT) between any group members is 5 seconds or more you could encounter ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache.html
When selecting a group_replication_message_cache_size setting, do so with reference to the expected volume of messages in the time period before a member is expelled. The length of this time period is controlled by the ... The group communication ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Transactions are executed optimistically and then, at commit time, are checked for conflicts. Bi-directional communication must be maintained at all times between all group members. Group members need to log transactions that are received from their ... Infrastructure Server Instance Configuration Server instances that you want to use for Group Replication must satisfy the following ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
In that situation, to re-create the group, it must be started by bootstrapping as if it was being started for the first time. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
Typically, this is set up at the time you are provisioning a server to join the group. Alternatively, from MySQL 8.0.21, you can specify them on the START GROUP_REPLICATION statement each time Group Replication is started. State transfer from the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-per-index-table.html
COMPRESS_TIME The total time in seconds used for compressing data in this index. Compressed InnoDB pages are uncompressed whenever compression fails, or the first time a compressed page is accessed in the buffer pool and the uncompressed page does ... 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-tablestats-table.html
Statistics are collected again the next time the table is accessed. This column is reset each time table statistics are recalculated AUTOINC The next number to be issued for any auto-increment-based operation. The rate at which the AUTOINC value ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
UPDATE_TIME The time that the partition or subpartition was last modified. CHECK_TIME The last time that the table to which this partition or subpartition belongs was checked. For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
TIME The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. Important ...