Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
Normalization permits statements that are similar to be grouped and summarized to expose information about the types of statements the server is executing and how often they occur. If the table becomes full, the Performance Schema groups statements ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-null.html
When using DISTINCT, GROUP BY, or ORDER BY, all NULL values are regarded as equal. Aggregate (group) functions such as COUNT(), MIN(), and SUM() ignore NULL values. The concept of the NULL value is a common source of confusion for newcomers to SQL, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration.html
Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in MySQL Shell. InnoDB Cluster wraps MySQL Group Replication in a programmatic environment that enables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-timeout.html
The process of retrying transactions can cause lag on a replica or on a Group Replication group member, which can be configured as a single-threaded or multithreaded replica. The global value of the system variable replica_transaction_retries sets ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
The tag is a user-defined string used to identify a specific group of transactions; see the description of the gtid_next system variable for permitted syntax. This GTID persister thread collects GTIDs in groups, flushes them to the ... A global ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
You might need to do this after carrying out test queries to verify a replication setup on new GTID-enabled servers, or when you want to join a new server to a replication group but it contains some unwanted local transactions that are not accepted ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in MySQL Shell. InnoDB Cluster wraps MySQL Group Replication in a programmatic environment that enables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group member. You can create a user account with the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in MySQL Shell. InnoDB Cluster wraps MySQL Group Replication in a programmatic environment that enables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in MySQL Shell. InnoDB Cluster wraps MySQL Group Replication in a programmatic environment that enables ...