PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/option-files.html
In an option file, you can have spaces around the = character, something that is not true on the command line. Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient ...
https://dev.mysql.com/doc/refman/9.7/en/option-modifiers.html
The “enabled” form of the option may be specified in any of these ways: --column-names --enable-column-names --column-names=1 The values ON, TRUE, OFF, and FALSE are also recognized for boolean options (not case-sensitive). Some options are ...
https://dev.mysql.com/doc/refman/9.7/en/order-by-optimization.html
For example, this is true for a HASH index in a MEMORY table. This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from ...
https://dev.mysql.com/doc/refman/9.7/en/pam-pluggable-authentication.html
Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use PAM (Pluggable Authentication Modules) to ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns-range.html
For example, when using a case-sensitive collation, 'and' sorts before 'Andersen', but when using a collation that is case-insensitive, the reverse is true. Range columns partitioning is similar to range partitioning, but enables you to define ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations.html
More specifically, this means that the following two statements are true: No definition of an InnoDB table employing user-defined partitioning may contain foreign key references; no InnoDB table whose definition contains foreign key references may ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-pruning.html
An INSERT statement also accesses only one partition per inserted row; this is true even for a table that is partitioned by HASH or KEY although this is not currently shown in the output of EXPLAIN. The optimization known as partition pruning is ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-range.html
(See Bug #42849.) Range partitioning is particularly useful when one or more of the following conditions is true: You want or need to delete “old” data. A table that is partitioned by range is partitioned in such a way that each partition ...
https://dev.mysql.com/doc/refman/9.7/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...