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/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. | ...The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html
In this case, the MySQL distribution need not have been compiled using OpenSSL as long as the openssl command is available. Automatic SSL and RSA File Generation Manual SSL and RSA File Generation Using mysql_ssl_rsa_setup SSL and RSA File ...For ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
The location of this default directory is the same as for the keyring_file_data system variable. See the description of that variable for details, as well as for considerations to take into account if you create the directory manually. The location ...These variables are unavailable unless the appropriate keyring plugin is installed (see Section 6.4.4.1, “Keyring Plugin ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
MySQL supports automatic function loading during server startup and manual loading thereafter. Installing Loadable Functions Uninstalling Loadable Functions Reinstalling or Upgrading Loadable Functions Installing Loadable Functions To load a ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
You should also read the OS-specific section in this manual for problems that may be unique to your environment. This command also provides some useful information even if you have not compiled MySQL for debugging! If the problem is that some tables ... If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. To execute RENAME TABLE, there must be no active ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
This clause is for use under these conditions: It is intended when upgrading MySQL to 5.1 or later from older versions. Use UPGRADE DATA DIRECTORY NAME in this case to explicitly tell the server to re-encode the database directory name to the ...
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-example.html
Information about this recovery process is conveyed to the user through the MySQL error log. This means that MySQL fails to start successfully because some blocks of disk data are no longer readable. In this case, it is necessary to reformat the ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
In the mysql command-line client, this is handled with the delimiter command. This means that no transactional savepoint is set at the start of the instruction block and the BEGIN clause used in this context has no effect on the current transaction.
https://dev.mysql.com/doc/refman/5.7/en/binary-log-formats.html
You can cause this format to be used by starting the server with --binlog-format=STATEMENT. This helps to eliminate issues when replicating certain statements between a source and replica which are using different storage engines. If MySQL cannot ...