Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-format-conversion-functions.html
MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping the order of X and Y coordinates. Functions such as ST_GeomFromText() that accept WKT geometry ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the recovery users must be properly set up, as they are also ... State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. MySQL uses the default collation for this character set ...Other ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-oci-component.html
Note The Oracle Cloud Infrastructure Vault keyring component is included in MySQL Enterprise Edition, a commercial product. No key information is permanently stored in MySQL server local storage. All keys are stored in Oracle Cloud Infrastructure ...component_keyring_oci is part of the component infrastructure that communicates with Oracle Cloud Infrastructure Vault for back end ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...The ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
Optimizer Hint Syntax MySQL supports comments in SQL statements as described in Section 11.7, “Comments”. Duplicate hints: For a hint such as /*+ MRR(idx1) MRR(idx1) */, MySQL uses the first hint and issues a warning about the duplicate hint.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
For applications based on the C API implemented by the libmysqlclient client library, the mysql_options() and mysql_options4() functions define the connection attribute set. This convention permits new attributes to be introduced by MySQL without ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. The following sections describe ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-file-context.html
The MySQL Server reads from and writes to many files. The instructions that follow use the semanage binary to manage file context; on RHEL, it's part of the policycoreutils-python-utils package: yum install -y policycoreutils-python-utils After ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...