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-class-geometry.html
For computations on multiple geometry values, all values must have the same SRID or an error occurs. It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from ...SRID 0 represents an infinite flat Cartesian plane with no units assigned to its ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
When PARTITION is used with the name of the target table for the INSERT portion of the statement, it must be possible to insert all rows selected into the partitions or subpartitions named in the partition list following the option. Such statements ...SELECT, you can quickly insert many rows into a table from the result of a SELECT statement, which can select from one or many ... INSERT [LOW_PRIORITY | ...
https://dev.mysql.com/doc/refman/8.0/en/kill.html
With CONNECTION_ADMIN or SUPER, you can kill all threads and statements, except that to affect a thread or statement that is executing with the SYSTEM_USER privilege, your own session must additionally have the SYSTEM_USER privilege. If the thread ...Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema threads ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O (receiver) thread. This ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-assign-anon.html
The replica must have gtid_mode=ON set, and this cannot be changed afterwards, unless you remove the ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS=ON setting. If the replica server is started without GTIDs enabled and with ...If it is possible to enable ...
https://dev.mysql.com/doc/refman/8.0/en/set-names.html
If given, the collation must one of the permitted collations for charset_name. SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, ...
https://dev.mysql.com/doc/refman/8.0/en/start-group-replication.html
You must issue a START GROUP_REPLICATION statement to provide the credentials again. Note that user credentials set using these statements are stored in the replication metadata repositories, and are used when START GROUP_REPLICATION is specified ...
https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html
When the server uses a cached internal statement structure, it must take care that the structure does not go out of date. Metadata changes can occur for an object used by the statement, causing a mismatch between the current object definition and ...
https://dev.mysql.com/doc/refman/8.0/en/stop-group-replication.html
Any user credentials that you specified in the START GROUP_REPLICATION statement when starting Group Replication on this member are removed from memory, and must be supplied when you start Group Replication again. This statement requires the ...
https://dev.mysql.com/doc/refman/8.0/en/time.html
The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), but also elapsed time or a time interval between two events (which may be much greater than 24 hours, or even ...