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/gis-general-property-functions.html
If any SRID argument is not within the range of a 32-bit unsigned integer, an ER_DATA_OUT_OF_RANGE error occurs. If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If a latitude value is not in ... The functions listed in this section do not restrict their argument and accept a geometry value of any ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-dns-srv.html
When DNS SRV record lookup is used, clients generally must apply these rules for connection requests (there may be client- or connector-specific exceptions): The request must specify the full DNS SRV record name, with the service and protocol names ... In the Domain Name System (DNS), a SRV record (service location record) is a type of resource record that enables a client to specify a name that indicates a service, protocol, and ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
Locking state is recorded in the account_locked column, which must have a value of 'N'. If the User column value is nonblank, the user name in an incoming connection must match exactly. It means that the user must connect without specifying a ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage.html
Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared library must be loaded into MySQL using the INSTALL PLUGIN statement. The shared library must be located in the MySQL server plugin directory, the ...
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/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/table-corruption.html
When the server detects MyISAM table corruption, it writes additional information to the error log, such as the name and line number of the source file, and the list of threads accessing the table. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional details. MySQL account information is stored in the tables of the mysql system schema.
https://dev.mysql.com/doc/refman/8.0/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...