Search Results
https://dev.mysql.com/doc/refman/8.4/en/processlist-access.html
Id is the connection identifier for the client associated with the thread. The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list entries. The other sources have negative performance consequences because they require a ...
https://dev.mysql.com/doc/refman/8.4/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. List the options in an option file that ...
https://dev.mysql.com/doc/refman/8.4/en/programs-client.html
This section describes client programs that connect to the MySQL server.
https://dev.mysql.com/doc/refman/8.4/en/purge-binary-logs.html
However, if a replica is not connected and you happen to purge one of the log files it has yet to read, the replica cannot replicate after it reconnects. PURGE BINARY LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration.html
In addition, InnoDB Cluster interfaces seamlessly with MySQL Router, which enables your applications to connect to the cluster without writing your own failover process. Once replication has been started it executes without requiring much regular ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
To address the issue, connect to the replica manually and determine the cause of the problem. If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. If a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-formats.html
Setting the variable globally takes effect for clients that connect after the change, but not for any current client sessions, including the session where the variable setting was changed. Replication works because events written to the binary log ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-failover.html
Ensure that all of the binary log files are processed using a single mysql process, rather than multiple connections. There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
The new replica now uses the information in its connection metadata repository to start the replication process. You can add another replica to an existing replication configuration without stopping the source server. To do this, you can set up the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterstatus.html
To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary log. Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for ...