PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-mbr.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. For functions that take multiple geometry arguments, if those arguments are not in the same SRS, an ER_GIS_DIFFERENT_SRIDS error occurs. If ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-functions.html
(Bug #54483) See Section 14.6.2, “Mathematical Functions”, for more information about the return types of these functions, as well as Section 13.1, “Numeric Data Types”. Each of these functions returns an integer only if it is passed an ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-members-table.html
RECOVERING: The server has joined a group from which it is retrieving data. ERROR: The member has encountered an error, either during applying transactions or during the recovery phase, and is not participating in the group's transactions. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-timing.html
For example, the standard gettimeofday() function can take hundreds of cycles, which is an unacceptable overhead for data gathering that may occur thousands or millions of times per second. Their accuracy is subject to the usual forms of error ...It ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
To configure that setting explicitly at startup, use these lines in the server my.cnf file: [mysqld] protocol_compression_algorithms=zlib,zstd,uncompressed To set and persist the protocol_compression_algorithms system variable to that value at ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-consensus-leader.html
To use a single consensus leader, the group must be configured as follows: The group must be in single-primary mode. You must carry out a full reboot of the replication group (bootstrap) for Group Replication to pick up a change to this setting. The ... By default, the group communication engine for Group Replication (XCom, a Paxos variant) operates using every member of the replication group as a ...
https://dev.mysql.com/doc/refman/8.0/en/rename-user.html
(That is, the statement fails if renaming an account would cause a stored object to become orphaned.) To perform the operation anyway, you must have the SET_USER_ID privilege; in this case, the statement succeeds with a warning rather than failing ...To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-online-group.html
Important For the coordinator to be able to configure group wide actions on a running group, all members must be running MySQL 8.0.13 or higher and have the functions installed. To simplify the migration or election processes and guarantee they are ...These functions are installed by the Group Replication plugin in version 8.0.13 and ... You can configure an online group while Group ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
An exception to this is that SUBPARTITION BY KEY (unlike PARTITION BY KEY) does not currently support a default column, so the column used for this purpose must be specified, even if the table has an explicit primary key. If you explicitly define ...