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/alter-instance.html
For additional ALTER INSTANCE ROTATE INNODB MASTER KEY usage information, see Section 14.14, “InnoDB Data-at-Rest Encryption”. ALTER INSTANCE ROTATE INNODB MASTER KEY ALTER INSTANCE, introduced in MySQL 5.7.11, defines actions applicable to a ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
For usage information and examples, see Section 22.3.3, “Exchanging Partitions and Subpartitions with Tables”. Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
(Examples are the PAM and simple LDAP authentication plugins; see Section 6.4.1.7, “PAM Pluggable Authentication”, and Section 6.4.1.9, “LDAP Pluggable Authentication”.) The following discussion provides usage information specific to ... A ...
https://dev.mysql.com/doc/refman/5.7/en/compressed-format.html
This minimizes disk usage, which is helpful when using slow disks (such as CD-ROMs). Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables ...
https://dev.mysql.com/doc/refman/5.7/en/connectors-apis.html
Basic information on their usage and abilities is provided here for reference purposes only. MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to MySQL resources using either the classic ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
row *************************** Table: child Create Table: CREATE TABLE `child` ( `id` int(11) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, KEY `par_ind` (`parent_id`), CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
An attempt to use more or fewer values in a VALUES LESS THAN clause than there are in the COLUMNS clause causes the statement to fail with the error Inconsistency in usage of column lists for partitioning.... | {FULLTEXT | SPATIAL} [INDEX | KEY] ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
Keycache usage indicates when data is read or written from the index files into the cache, and can be used to monitor how efficient the memory allocated to the keycache is being used. MySQL supports the following static probes, organized into ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
The command mysqladmin debug dumps some information about locks in use, used memory and query usage to the MySQL log file. If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which ...