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/subquery-optimization-with-exists.html
This section discusses these optimizations, particularly with regard to the challenges that NULL values present. This is done by pushing down an appropriate equality into the subquery's WHERE clause to make it more restrictive. The converted ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
This is preferable in a production deployment to installing the plugin manually. This is important when setting up Group Replication as it ensures you can configure the server before manually starting the plugin. This section explains the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
For instructions to do this, see Section 7.5, “Point-in-Time (Incremental) Recovery”. Does the transaction that stopped replication need to be applied on the replica? If so, either make the appropriate corrections and reapply the transaction, or ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
This section provides a conceptual overview of partitioning in MySQL 5.7. In MySQL, the InnoDB storage engine has long supported the notion of a tablespace, and the MySQL Server, even prior to the introduction of partitioning, could be configured ...For information on partitioning restrictions and feature limitations, see Section 22.6, “Restrictions and Limitations on ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-backups.html
In this case, you must determine which file this is and supply the name in the next step manually or by parsing the output with a script. This section discusses making backups and restoring from them using NDB Cluster replication. This having been ...We assume that the replication servers have already been configured as covered previously (see Section 21.7.5, “Preparing the NDB Cluster for Replication”, and the sections immediately ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
In this case, you cannot establish MySQL connections that use TLSv1 or TLSv1.1, even though MySQL is configured to permit them, because the host system does not permit them. Workarounds for this issue include: Change the system-wide host ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
This section describes how to configure MySQL Enterprise Firewall using SQL statements. By default, this variable is enabled when the firewall is installed. This section describes how the firewall accomplishes the task of accepting or rejecting ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-nodes-groups.html
This section discusses the manner in which NDB Cluster divides and duplicates data for storage. A number of concepts central to an understanding of this topic are discussed in the next few paragraphs. An ndbd or ndbmtd process, which stores one or ...While it is also possible to host multiple data node processes on a single computer, such a configuration is not usually ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
Because this is insecure, you might want to use --skip-grant-tables in conjunction with enabling the skip_networking system variable to prevent remote clients from connecting. This plugin is used in conjunction with server-side plugins that require ... When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system ...