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/creating-ssl-rsa-files.html
The following discussion describes how to create the files required for SSL and RSA support in MySQL. File creation can be performed using facilities provided by MySQL itself, or by invoking the openssl command directly. SSL certificate and key ...
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source distribution. The CSV storage engine stores data in text files using comma-separated ...
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 ...