Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-main.html
On the source server, the output from SHOW PROCESSLIST looks like this: mysql> SHOW PROCESSLIST\G *************************** 1. If you see no Binlog Dump threads on a source server, this means that replication is not running; that is, no replicas ... The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding ...
https://dev.mysql.com/doc/refman/8.4/en/replication.html
Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database servers (known as replicas). In this environment, all writes and updates must take place on the source server. The original type ...Replication is asynchronous by default; replicas do not need to be connected permanently to receive updates from a ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
For a server where binary logging is enabled (log_bin is ON), RESET BINARY LOGS AND GTIDS deletes all existing binary log files and resets the binary log index file, resetting the server to its state before binary logging was started. For a server ... Note This statement takes the place of the old RESET MASTER statement, which is no longer ...
https://dev.mysql.com/doc/refman/8.4/en/reset-replica.html
(This is a condition likely to exist on a replica if you have issued a STOP REPLICA statement or if the replica is highly loaded.) For a server where GTIDs are in use (gtid_mode is ON), issuing RESET REPLICA has no effect on the GTID execution ...
https://dev.mysql.com/doc/refman/8.4/en/set-role.html
When a user connects to the server and authenticates successfully, the server determines which roles to activate as the default roles. If the activate_all_roles_on_login system variable is enabled, the server activates all granted roles. The server ... SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
A server that participates in a group in single-primary mode should use skip_replica_start=ON. Otherwise, the server is not allowed to join a group as a secondary. This option acts as a hint to the server, and the donor for distributed recovery ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-install.html
This section describes the installation of the server and client OpenTelemetry support. Installing Client Plugin The Telemetry plugin for the MySQL client can be enabled with a command line switch, --telemetry_client or from a configuration option, ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
This parameter is configurable to enable you to strike a balance appropriate for the server work load. For example, on a replication source server, a thread that is sending binary log events to a replica effectively runs forever. These would lead to ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool.html
MySQL Enterprise Edition includes MySQL Enterprise Thread Pool, implemented using a server plugin. The default thread-handling model in MySQL Server executes statements using one thread per client connection. As more clients connect to the server ...