PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Usually this delay should be minimal, but it does depend on the size of the backlog. Permitted Queries Under Consistency Rules Although all writes are held when using BEFORE_ON_PRIMARY_FAILOVER consistency level, not all reads are blocked to ensure ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-fault-tolerance.html
Group Size Majority Instant Failures Tolerated 1 1 0 2 2 0 3 2 1 4 3 1 5 3 2 6 4 2 7 4 3 . MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide distributed coordination between servers. As such, it ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-gtids.html
The group_replication_gtid_assignment_block_size system variable sets the size of the blocks, with a default of 1 million GTIDs in each block. From MySQL 8.0.27, the settings GTID_ONLY=1, REQUIRE_ROW_FORMAT = 1, and SOURCE_AUTO_POSITION = 1 are ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
Plan the group size for the number of expected failures (regardless whether they are consecutive, happen all at once or are sporadic). The group needs to achieve consensus whenever a change that needs to be replicated happens. This is the case for ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-length.html
The sizes of the identifier string columns in the grant tables are measured in characters. The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
With innodb_stats_persistent_sample_pages set to the default value of 20, and with a default page size of 16 KiB (innodb_page_size=16384), you can then estimate that 20 * 12 * 16384 bytes are read for table t, or about 4 MiB. ANALYZE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-optimization.html
InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning.
https://dev.mysql.com/doc/refman/8.0/en/innodb-disk-management.html
Organizing tables into many small files, a few larger files, or a combination of both. Balancing the size of redo log files against the I/O activity that occurs when the log files become full. As a DBA, you must manage disk I/O to keep the I/O ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 17.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-failure-conditions.html
The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary online log exceeds the value of the innodb_online_alter_log_max_size configuration option. The failure of an online DDL operation is ...