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/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking.html
Administration is restricted to authorized users who are granted special privileges so that only they can create and modify the dictionaries. For information about the similarities and differences, see Table 8.45, “Comparison Between Data-Masking ... Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-event-fields.html
A user-defined field does not exist until created by a log filter. Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An event field may be classified as core, optional, or user-defined: A ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically well-formed. Syntactic well-formedness is also checked for attempts to store geometries into tables. For geometry ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-fault.html
Warning For a remote cloning operation, user-created tablespaces and data on the recipient (the joining member) are dropped before the remote cloning operation begins to transfer the data from the donor. The donor for distributed recovery is ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
While traffic is flowing, transactions can be externalized on some members before the others, especially if some members have less write throughput than others, creating the possibility of stale reads. If a transaction executes against a table that ... In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-adaptive-hash.html
If a table fits almost entirely in main memory, a hash index speeds up queries by enabling direct lookup of any element, turning the index value into a sort of pointer. If there are numerous threads waiting on rw-latches created in btr0sea.c, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
$> mysql test mysql> CREATE TABLE customer (a INT, b CHAR (20), INDEX (a)); Query OK, 0 rows affected (0.00 sec) mysql> -- Do a transaction with autocommit turned on. If autocommit mode is enabled, each SQL statement forms a single transaction on ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-plugin.html
The keyring_file keyring plugin stores keyring data in a file local to the server host. As of MySQL 8.0.34, this plugin is deprecated and subject to removal in a future release of MySQL. Instead, consider using the component_keyring_file component ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-parallel-data-nodes.html
If you are using large Disk Data tables, you may also need to increase DiskPageBufferMemory. To force creation of a single-threaded backup that can easily be imported by ndb_restore from an NDB release prior to 8.0, you can set ... It is possible in ...