PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/compatibility.html
We continue to support transactional and nontransactional databases to satisfy both mission-critical 24/7 usage and heavy Web or logging usage. This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL Server has many extensions ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html
Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 extension), the extended key usage must include client authentication (clientAuth). There is no extendedKeyUsage ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
(In-memory data resource usage is reported by the DATA_LENGTH column.) For partitioned tables, this value is only an estimate and may not be absolutely correct. (In-memory data resource usage is reported by the DATA_LENGTH column.) For MEMORY ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
To view change buffer metrics and a description of each, issue the following query: mysql> SELECT NAME, COMMENT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME LIKE '%ibuf%'\G For INNODB_METRICS table usage information, see Section 14.16.6, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory. Those reasons might include space management, I/O optimization, or placing tables on a storage device with particular ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
About Data-at-Rest Encryption Encryption Prerequisites Enabling File-Per-Table Tablespace Encryption Master Key Rotation Encryption and Recovery Exporting Encrypted Tablespaces Encryption and Replication Identifying Encrypted Tablespaces Encryption ...When a tablespace is encrypted, a tablespace key is encrypted and stored in the tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
The Transportable Tablespaces feature is described under the following topics in this section: Prerequisites Importing Tables Importing Partitioned Tables Importing Table Partitions Limitations Usage Notes Internals Prerequisites The ... This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration-overview.html
This is especially true with regard to those parameters that relate to memory usage and disk space, such as MaxNoOfTables, MaxNoOfOrderedIndexes, and MaxNoOfUniqueHashIndexes. In addition, it is the generally the case that configuration parameters ...Each of the node parameter tables lists the parameters for a given type (ndbd, ndb_mgmd, mysqld, computer, tcp, or ...