PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a key lookup. This is common for tables with fewer than 10 rows and a short row length. In this case, MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
This directory should be in a disk-based file system (not a memory-based file system) so that the temporary files used to replicate LOAD DATA can survive machine restarts. On platforms that support it (such as Unix), this is done by unlinking the ...
https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html
This section describes how to use mysqldump to produce dump files, and how to reload dump files. This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
This section discusses optimizations that can be made for processing WHERE clauses. Because MySQL does similar optimizations automatically, you can often avoid this work, and leave the query in a more understandable and maintainable form. This is ...The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/windows-and-ssh.html
This section describes how to get an encrypted connection to a remote MySQL server with SSH. This userid value might not be the same as the user name of your MySQL account. At this point, you should have an ODBC connection to MySQL, encrypted using ...Either do a remote forward (Set local_port: 3306, remote_host: yourmysqlservername_or_ip, remote_port: 3306 ) or a local forward (Set port: 3306, host: localhost, remote port: ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-encrypted-connections.html
This section explains how to configure X Plugin to use encrypted connections. To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx system variables, which can have different values from the ssl_xxx system variables ...
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/file-permissions.html
If this is unsuitable, create the error file manually with the desired access mode prior to executing mysqld_safe. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
This process can be captured in the binary log and then you can rely on distributed recovery to replicate the statements used to create the user. Alternatively, you can disable binary logging using SET SQL_LOG_BIN=0; and then create the user ...