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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
Recall that, to maintain data consistency, an NDB Cluster shuts down when the last node in a node group fails. One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-security-procedures.html
In this section, we discuss MySQL standard security procedures as they apply to running NDB Cluster. In general, any standard procedure for running MySQL securely also applies to running a MySQL Server as part of an NDB Cluster. First and foremost, ...