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/adding-collation.html
In this case, rebuild any such indexes to avoid problems such as incorrect query results. Additional Resources Example showing how to add a collation for full-text searches: Section 12.9.7, “Adding a User-Defined Collation for Full-Text ... A ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/charset-restrictions.html
However, you can perform IN BOOLEAN MODE searches on the column without an index. Identifiers are stored in mysql database tables (user, db, and so forth) using utf8, but identifiers can contain only characters in the Basic Multilingual Plane (BMP). The ucs2, utf16, utf16le, and utf32 character sets have the following restrictions: None of them can be used as the client character ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. This affects primarily Vietnamese, Yoruba, and some smaller languages such as Navajo. If this is acceptable for your application, you ...MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...