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/optimizing-myisam-bulk-data-loading.html
Use myisamchk --keys-used=0 -rq /path/to/db/tbl_name to remove all use of indexes for the table. To increase performance for MyISAM tables, for both LOAD DATA and INSERT, enlarge the key cache by increasing the key_buffer_size system variable.
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. The IGNORE keyword has no effect when used with ALTER TABLE ... There are no rows in nt that lie outside the boundaries of the partition ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
An INSERT statement also accesses only one partition per inserted row; this is true even for a table that is partitioned by HASH or KEY although this is not currently shown in the output of EXPLAIN. For tables that are partitioned by HASH or ... The ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
Syntax for Persisting System Variables These SET syntax options are available for persisting system variables: To persist a global system variable to the mysqld-auto.cnf option file in the data directory, precede the variable name by the PERSIST ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
REFERENCES Creation of a foreign key constraint requires the REFERENCES privilege for the parent table. The related system variable binlog_rotate_encryption_master_key_at_startup, which rotates the binary log master key automatically when the server ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.0/en/programs-overview.html
This program creates the SSL certificate and key files and RSA key-pair files required to support secure connections, if those files are missing. mysql_migrate_keyring A utility for migrating keys between one keyring component and another. Later ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
Sorting of non-Chinese characters is based on the order of the original sort key. In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set”, which is ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-encrypted-data.html
The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the network. Tablespace keys are decrypted at the donor before transport and re-encrypted at the ...An error is reported if an encrypted connection is not available or the REQUIRE NO SSL clause is used in the CLONE INSTANCE ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-options-variables.html
clone_ssl_cert Command-Line Format --clone-ssl-cert=file_name Introduced 8.0.14 System Variable clone_ssl_cert Scope Global Dynamic Yes SET_VAR Hint Applies No Type File name Default Value empty string Specifies the path to the public key ... This ...
https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html
syntax: a BEFORE INSERT trigger activates for every row, followed by either an AFTER INSERT trigger or both the BEFORE UPDATE and AFTER UPDATE triggers, depending on whether there was a duplicate key for the row. CREATE [DEFINER = user] TRIGGER [IF ...