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/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/alter-table.html
This is a MySQL extension to standard SQL, which permits only one of each clause per ALTER TABLE statement. For example, to drop multiple columns in a single statement, do this: ALTER TABLE t2 DROP COLUMN c, DROP COLUMN d; If a storage engine does ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
For information about the conditions under which this occurs for the server logs and how to control it, see Section 6.1.2.3, “Passwords and Logging”. In one case only, the account may be specified with the USER() function: ALTER USER USER() ...
https://dev.mysql.com/doc/refman/5.7/en/apis-php-info.html
The MySQL PHP API manual is now published in standalone form, not as part of the MySQL Reference Manual.
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
You should not manually edit this file while mysqld is running; doing so would confuse mysqld. However, the benefits of the binary log in enabling you to set up replication and for restore operations generally outweigh this minor performance ... The ...