MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 371 to 380 of 547 total results

29.12.11.11 The replication_connection_status Table

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-status-table.html

GROUP_NAME If this server is a member of a group, shows the name of the group the server belongs to. This table shows the current status of the I/O thread that handles the replica's connection to the source, information on the last transaction ...

29.12.20.9 Socket Summary Tables

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-summary-tables.html

Each socket summary table has one or more grouping columns to indicate how the table aggregates events. This column can be grouped on to isolate, for example, client activity from that of the server listening sockets. These socket summary tables ...

29.10 Performance Schema Statement Digests and Sampling

https://dev.mysql.com/doc/refman/8.0/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 ...

B.3.4.3 Problems with NULL Values

https://dev.mysql.com/doc/refman/8.0/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, ...

19.1.7 Common Replication Administration Tasks

https://dev.mysql.com/doc/refman/8.0/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 ...

19.5.1.32 Replication Retries and Timeouts

https://dev.mysql.com/doc/refman/8.0/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 (from ...

19.1.3.2 GTID Life Cycle

https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html

For example, 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 ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...

19.1.2 Setting Up Binary Log File Position Based Replication

https://dev.mysql.com/doc/refman/8.0/en/replication-howto.html

19.3.3 Replication Privilege Checks

https://dev.mysql.com/doc/refman/8.0/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. MySQL then checks each transaction against the ...

19.1.2.6 Setting Up Replicas

https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html

Displaying 371 to 380 of 547 total results