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/identifier-case-sensitivity.html
In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server internally generates a name derived from the associated table name. For example, internally ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
This includes (but is not limited to) SELECT lists, WHERE and HAVING clauses, and ORDER BY and GROUP BY clauses. The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
ORDER BY and GROUP BY for JSON values works according to these principles: Ordering of scalar JSON values uses the same rules as in the preceding discussion. Non-NULL values are converted to a numeric type and aggregated, except for MIN(), MAX(), ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
DISTINCT with ORDER BY does not work inside GROUP_CONCAT() if you do not use all and only those columns that are in the DISTINCT list. This means that values cannot reliably be used in GROUP BY, ORDER BY, or DISTINCT if they differ only after the ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
Use of a column with RAND() values in an ORDER BY or GROUP BY clause may yield unexpected results because for either clause a RAND() expression can be evaluated multiple times for the same row, each time returning a different result. ABS(X) Returns ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. Memory instruments have ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
The transporter's group number can be based on which availability domain is used, such that also SQL and other API nodes communicate with local data nodes in the same availability domain whenever possible. The [mysqld] and [api] sections in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-rpm.html
The RPM installer should take care of general configuration issues (such as creating the mysql user and group, if needed) automatically. This section covers the steps necessary to install the correct executables for each type of NDB Cluster node ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-definition.html
The transporter's group number can be based on which availability domain is used, such that also SQL and other API nodes communicate with local data nodes in the same availability domain whenever possible. The [ndb_mgmd] section is used to ...