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/fetching-spatial-data.html
Geometry values stored in a table can be fetched in internal format. Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-example.html
The Information Schema contains the number of deadlocks: mysql> SELECT `count` FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME="lock_deadlocks"; +-------+ | count | +-------+ | 1 | +-------+ 1 row in set (0.00 sec) The InnoDB status contains the ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-options.html
MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Type String The destination keyring plugin for key migration. The option value ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-print-file.html
ndb_print_file obtains information from an NDB Cluster Disk Data file. --file-key-from-stdin Command-Line Format --file-key-from-stdin Introduced 8.0.31-ndb-8.0.31 Type Boolean Default Value FALSE Valid Values TRUE Supply file system encryption or ...Usage ndb_print_file [-v] [-q] file_name+ file_name is the name of an NDB Cluster Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-coordinator-table.html
This table provides information about the last transaction which was buffered by the coordinator thread to a worker’s queue, as well as the transaction it is currently buffering. LAST_ERROR_TIMESTAMP A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' ... For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the coordinator ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
For more information about SET, see Section 15.7.6.1, “SET Syntax for Variable Assignment”. To remove a specific persisted variable from mysqld-auto.cnf, but produce a warning rather than an error if the variable is not present in the file, add ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
Important Under some circumstances, ALTER USER may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be read by anyone having read access to that information. For ...
https://dev.mysql.com/doc/refman/8.0/en/audit-api-message-emit.html
Example: mysql> SELECT audit_api_message_emit_udf('component_text', 'producer_text', 'message_text', 'key1', 'value1', 'key2', 123, 'key3', NULL) AS 'Message'; +---------+ | Message | +---------+ | OK | +---------+ Additional information: Each audit ... As of MySQL 8.0.14, the audit_api_message_emit component enables applications to add their own message events to the audit log, using the audit_api_message_emit_udf() ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
For information on upgrading to the new component functions provided by the MySQL component component_enterprise_encryption, and a list of the behavior differences between the legacy functions and the component functions, see Upgrading MySQL ... In ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions.html
For information on upgrading to the new component functions provided by the MySQL component component_enterprise_encryption, and a list of the behavior differences between the legacy functions and the component functions, see Upgrading MySQL ... In ...