Search Results
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connections.html
When you must move information over a network in a secure fashion, an unencrypted connection is unacceptable. By default, MySQL programs attempt to connect using encryption if the server supports encrypted connections, falling back to an unencrypted ... With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and ...
https://dev.mysql.com/doc/refman/8.4/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/8.4/en/execute.html
EXECUTE stmt_name [USING @var_name [, @var_name] ...] After preparing a statement with PREPARE, you execute it with an EXECUTE statement that refers to the prepared statement name. If the prepared statement contains any parameter markers, you must ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
Can the rules for strict mode be extended? When we refer to strict mode, we mean a mode where at least one of the modes TRADITIONAL, STRICT_TRANS_TABLES, or STRICT_ALL_TABLES is enabled. What is the default server SQL mode when MySQL 8.4 is ...What ...
https://dev.mysql.com/doc/refman/8.4/en/firewall.html
For a given account, the firewall can operate in recording, protecting, or detecting mode, for training in the accepted statement patterns, active protection against unacceptable statements, or passive detection of unacceptable statements. Note ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-geometrycollection.html
A GeomCollection is a geometry that is a collection of zero or more geometries of any class. GeomCollection and GeometryCollection are synonymous, with GeomCollection the preferred type name. All the elements in a geometry collection must be in the ...
https://dev.mysql.com/doc/refman/8.4/en/gis-geometrycollection-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. If any geometry argument is not a syntactically ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-group-membership.html
In MySQL Group Replication, a set of servers forms a replication group. A group has a name, which takes the form of a UUID. The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. If a server joins ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-group-write-consensus.html
For example, the default value of 10 is suitable for a group running on a LAN, but for groups operating over a slower network such as a WAN, increase this number to improve performance. This section explains how to inspect and configure the maximum ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-increase.html
If a member is absent for a period that is not long enough for it to be expelled from the group, it can reconnect and start participating in the group again by retrieving missed transactions from another member's XCom message cache. However, if the ...