PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
Enabling innodb_locks_unsafe_for_binlog does not disable the use of gap locking for foreign-key constraint checking or duplicate-key checking. For example, you might change the port that memcached listens on, reduce the maximum number of ... System ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Index Handling To ignore foreign key constraints during the load operation, execute a SET foreign_key_checks = 0 statement before executing LOAD DATA. Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the ...The ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
Use the private key to encrypt data and the public key to decrypt it This requires that the members of the key pair be RSA keys. SET @ciphertext = asymmetric_encrypt(@algo, 'My secret text', @priv); SET @plaintext = asymmetric_decrypt(@algo, ... To ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is 24710a27dc7a28fb7ee6d825129cd3cf. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
This is the case for transactions that have empty or partial write sets, transactions that update tables without primary or unique keys, and transactions that update parent tables in a foreign key relationship. If the table containing the row has a ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
Those syntaxes are still recognized for backward compatibility but partition and extended output is now enabled by default, so the PARTITIONS and EXTENDED keywords are superfluous and deprecated. You cannot use the deprecated PARTITIONS and EXTENDED ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
All numeric key values are stored with the high byte first to permit better index compression. For the case of a key longer than 250 bytes, a larger key block size than the default of 1024 bytes is used. When rows are inserted in sorted order (as ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
MEMORY tables can have up to 64 indexes per table, 16 columns per index and a maximum key length of 3072 bytes. If a MEMORY table hash index has a high degree of key duplication (many index entries containing the same value), updates to the table ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
Important To connect to the server using an account that authenticates with the sha256_password plugin, you must use either a TLS connection or an unencrypted connection that supports password exchange using an RSA key pair, as described later in ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-ddl-operations.html
Foreign key constraints can make a TRUNCATE statement work like a regular DELETE statement, in which case a sequence of commands like DROP TABLE and CREATE TABLE might be fastest. Many DDL operations on tables and indexes (CREATE, ALTER, and DROP ...