PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-transactional-storage.html
Data dictionary tables are located in the mysql database together with non-data dictionary system tables. Data dictionary tables are created in a single InnoDB tablespace named mysql.ibd, which resides in the MySQL data directory. The mysql.ibd ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
MySQL 8.0.16 and higher includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. If ddl_rewriter rewrites a statement, it generates a warning: mysql> CREATE TABLE t (i INT) DATA ...The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when restoring tables from SQL dump files created from databases that are encrypted or that have their tables stored outside the data ...
https://dev.mysql.com/doc/refman/8.0/en/distinct-optimization.html
Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. When combining LIMIT row_count with DISTINCT, MySQL stops as soon as it finds row_count unique rows. If ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
The CREATE SERVER statement updates the rows in the mysql.servers table. See the following table for information on the correspondence between parameters in a connection string, options in the CREATE SERVER statement, and the columns in the ... If ...
https://dev.mysql.com/doc/refman/8.0/en/gpg-key-archived-packages.html
The following GPG public build key (keyID 3A79BD29) can be used to verify the authenticity and integrity of MySQL packages versions 8.0.28 through 8.0.35, 8.1.0, and 8.2.0. For signature checking instructions, see Section 2.1.4.2, “Signature ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-securing.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied ...When a member joins the group, distributed recovery is carried out using a combination of a remote cloning operation, if available and appropriate, and an asynchronous replication ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schemata-extensions-table.html
The SCHEMATA_EXTENSIONS table (available as of MySQL 8.0.22) augments the SCHEMATA table with information about schema options. The SCHEMATA_EXTENSIONS table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. If ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-spatial-reference-systems-table.html
Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, except for SRID 0, which corresponds to a special SRS used in MySQL that represents an infinite flat Cartesian plane with no units ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-plugin.html
As of MySQL 8.0.34, this plugin is deprecated and subject to removal in a future release of MySQL. The keyring_file plugin supports the functions that comprise the standard MySQL Keyring service interface. The keyring_file keyring plugin stores ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-service.html
MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later retrieval. MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL level, as ...As a C language interface, callable as a plugin service from server plugins or loadable ...