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/controlling-query-plan-evaluation.html
A more flexible method for query optimization enables the user to control how exhaustive the optimizer is in its search for an optimal query evaluation plan. The task of the query optimizer is to find an optimal plan for executing an SQL query.
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
If the directory specified does not exist, NDB attempts to create it; the system user account under which the data node process is running must have the appropriate permissions to do so. The precise syntax and semantics depend on the storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/creating-rsa-files-using-openssl.html
The private key should be readable only by the server, whereas the public key can be freely distributed to client users: chmod 400 private_key.pem chmod 444 public_key.pem . This section describes how to use the openssl command to set up the RSA ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory.html
Information managed by the MySQL server is stored under a directory known as the data directory. The following list briefly describes the items typically found in the data directory, with cross references for additional information: Data directory ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
This is useful when you want to store a “possibly wrong” value which the user has specified (for example, in a web form) in the database for future processing. The date and time data types for representing temporal values are DATE, TIME, ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
There are no user-configurable server options or variables associated with this file. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table partitioning, such as ALTER TABLE t3 DROP ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
For example, the following statement finds rows matching the WHERE clause, sorts them by timestamp_column, and deletes the first (oldest) one: DELETE FROM somelog WHERE user = 'jcole' ORDER BY timestamp_column LIMIT 1; ORDER BY also helps to delete ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/5.7/en/deploy-mysql-nonlinux-docker.html
Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. Warning The MySQL Docker images provided by Oracle are built specifically for Linux platforms. This section discusses ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution plans.
https://dev.mysql.com/doc/refman/5.7/en/downgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. This section describes the steps to downgrade a MySQL ...