Search Results
https://dev.mysql.com/doc/refman/9.7/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/9.7/en/explain-for-connection.html
connection_id is the connection identifier, as obtained from the INFORMATION_SCHEMA PROCESSLIST table or the SHOW PROCESSLIST statement. To obtain the execution plan for an explainable statement executing in a named connection, use this statement: ...
https://dev.mysql.com/doc/refman/9.7/en/file-permissions.html
For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/file_name' (Errcode: 13) The default UMASK and UMASK_DIR values are 0640 and 0750, respectively. If this is unsuitable, create ...
https://dev.mysql.com/doc/refman/9.7/en/geometry-well-formedness-validity.html
Syntactic well-formedness is also checked for attempts to store geometries into tables. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-cloning.html
Be aware that a remote cloning operation removes user-created tablespaces and data from the joining member before transferring the data from the donor. Cloning is therefore not suitable for groups where members run different minor MySQL Server ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-deploying-locally.html
The instructions in this section are not suitable for production deployments because all MySQL server instances are running on the same single host. mysql-9.7/bin/mysqld --initialize-insecure --basedir=$PWD/mysql-9.7 --datadir=$PWD/data/s1 ... The ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-distributed-recovery-connections.html
The host name that the server is using for SQL client connections can be verified in the Member_host column of the Performance Schema table replication_group_members. The steps for a joining member to establish a connection for distributed recovery ... When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-distributed-recovery-fault.html
The donor for distributed recovery is selected randomly from the existing list of suitable online group members in the current view. When the member joining has restarted at the end of the operation, it establishes a connection with a new donor for ... Group Replication's distributed recovery process has a number of built-in measures to ensure fault tolerance in the event of any problems during the ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-failure-detection.html
If a member does not receive messages from another member for 5 seconds, it suspects that the member has failed, and lists the status of that member as UNREACHABLE in its own Performance Schema table replication_group_members. Where the network is ... Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-fault-tolerance.html
MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide distributed coordination between servers. As such, it requires a majority of servers to be active to reach quorum and thus make a decision. This has ...