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/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. Note There are easier ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
InnoDB mutexes and rw-locks are typically reserved for short intervals. On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. InnoDB minimizes ...If the mutex or rw-lock becomes available during this period, the thread can continue immediately, in the same time ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
Only use an innodb_force_recovery setting of 4 or greater on a production server instance after you have successfully tested the setting on a separate physical copy of your database. If you encounter a runaway rollback caused by a failing mass ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform their own processing on the data. For additional information about the differences between non-x$ and x$ views, see Section ...Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If statement-based binary logging format is in use on the source (binlog_format=STATEMENT), the replica evaluates the INSERT operation using the default database, which was set by the USE statement to db1 and has not been changed. The effect of the ... If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
SET forms of the statement insert rows based on explicitly specified values. For example, if you specify a column list that does not name all the columns in the table, unnamed columns are set to their default values. If both the column list and the ...[ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] SET assignment_list [ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
For a comparison of JSON_INSERT(), JSON_REPLACE(), and JSON_SET(), see the discussion of JSON_SET(). \ Please use JSON_MERGE_PRESERVE/JSON_MERGE_PATCH instead 1 row in set (0.00 sec) For additional examples, see the entry for JSON_MERGE_PRESERVE().
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-tcp-definition.html
Normally it is not necessary to define TCP/IP connections; NDB Cluster automatically sets up such connections for all data nodes, management nodes, and SQL or API nodes. It is also possible to change the default values for these parameters by ...To ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview.html
NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase”). See Section 4.5.4, “mysqldump — A Database Backup Program”, for more information. NDB Cluster is ...NDB Cluster is designed not to have any single point of ...