Search Results
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
If auto-reconnect is enabled, the client is not notified that the connection was lost. If all operands of the operator are parameters, the derived type is VARCHAR; its collation is determined by the value of collation_connection. If all operands of ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-mysql-sock.html
You can test whether the new socket location works by attempting to connect to the server with this command: $> mysqladmin --socket=/path/to/socket version . The default location for the Unix socket file that the server uses for communication with ...
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 ...