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/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause ...If column b is also unique, the INSERT is equivalent to this UPDATE statement instead: UPDATE t1 SET c=c+1 WHERE a=1 OR b=2 LIMIT 1; If a=1 OR b=2 matches several rows, only one row is ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The block_nested_loop and batched_key_access flags of the optimizer_switch system variable control how the optimizer ...The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html
After you gain experience using such files, consider obtaining certificate/key material from a registered certificate authority. Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension ...For some distribution types, such as RPM and DEB packages, mysql_ssl_rsa_setup invocation occurs during data directory ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-plugin-specific.html
For each keyring plugin-specific function, this section describes its purpose, calling sequence, and return value. For information about general-purpose keyring functions, see Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”.
https://dev.mysql.com/doc/refman/5.7/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password plugin. See Section 6.3.3.1, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
To prevent phantoms, InnoDB uses an algorithm called next-key locking that combines index-row locking with gap locking. In addition, a next-key lock on an index record also affects the “gap” before the index record. That is, a next-key lock is ... The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files.html
SSL certificate and key files enable MySQL to support encrypted connections using SSL. RSA key files enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password plugin. The ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-concepts.html
Document A Document is a set of key and value pairs, as represented by a JSON object. This section explains the concepts introduced as part of using MySQL as a document store. A Document is represented internally using the MySQL binary JSON object, ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
foreign_key_checks System Variable foreign_key_checks Scope Global, Session Dynamic Yes Type Boolean Default Value ON If set to 1 (the default), foreign key constraints are checked. If set to 0, foreign key constraints are ignored, with a couple of ...It controls whether the server autogenerates SSL key and certificate files in the data directory, if they do not already ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-syntax.html
Support for foreign key constraints in NDB 7.5 is comparable to that provided by InnoDB, subject to the following restrictions: Every column referenced as a foreign key requires an explicit unique key, if it is not the table's primary key. (Bug ...