PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Since there are typically two replicas, and assuming that this is so, each fragment_num value should appear twice in the table, on two different data nodes from the same node group. The operations_per_fragment table provides information about the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether table is currently being reorganized (1 if true) Notes The table_distribution_status table was added in NDB ...