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/server-option-variable-reference.html
For a version of this table that is specific to NDB Cluster, see Section 21.4.2.5, “NDB Cluster mysqld Option and Variable Reference”. This option is dynamic, but should be set only by server. The following table lists all command-line options, ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
Typically, you do this using options on the CMake command line. This value is used as the parent location for several of the installation subdirectories. NDB 8.0.31 and later: Deprecated; use WITH_NDB instead ON WITH_NDBCLUSTER_STORAGE_ENGINE Prior ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/windows-choosing-package.html
This format does not include an automated installer, and must be manually installed and configured. The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images Program Database (PDB) files ...
https://dev.mysql.com/doc/refman/5.7/en/charset-we-sets.html
DIN-1 is called the “dictionary collation” and DIN-2 is called the “phone book collation.” For an example of the effect this has in comparisons or when doing searches, see Section 10.8.6, “Examples of the Effect of Collation”. This means ... Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
If this column is short, reasonably unique, and indexed, it might be faster than a “wide” index on many columns. It can also be used for queries that specify just a last_name value because that column is a leftmost prefix of the index (as ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-null.html
All columns in the following example return NULL: mysql> SELECT NULL, 1+NULL, CONCAT('Invisible',NULL); To search for column values that are NULL, you cannot use an expr = NULL test. The exception to this is COUNT(*), which counts rows and not ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache.html
This is a typical situation for many Web servers that generate many dynamic pages based on database content. Searches for a single row in a single-row table are 238% faster with the query cache than without it. This can be regarded as close to the ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
This section describes the syntax for account names, including special values and wildcard rules. Because IP wildcard values are permitted in host values (for example, '198.51.100.%' to match every host on a subnet), someone could try to exploit ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
(See Section 16.1.6, “Replication and Binary Logging Options and Variables”.) This filtered log is provided to the replica. This type of setup can be repeated with additional replication replicas. This should be borne in mind when considering ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. Complex collations for ...It is a case-insensitive collation, so the uppercase and lowercase versions of a character have the same weights and they compare as ...