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/mysql-cluster-limitations-exclusive-to-cluster.html
NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a binary log for tables having BLOB columns but no primary key. The following are limitations specific to the NDB storage engine: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-performance.html
Unique hash indexes created with USING HASH cannot be used for accessing a table if NULL is given as part of the key. The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-operations.html
The cluster_operations table provides a per-operation (stateful primary key op) view of all activity in the NDB Cluster from the point of view of the local data management (LQH) blocks (see The DBLQH Block). The state column can have any one of the ...(Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) The operation_type column can take any one of the values READ, READ-SH, READ-EX, INSERT, UPDATE, DELETE, WRITE, UNLOCK, REFRESH, SCAN, SCAN-SH, SCAN-EX, or ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-transactions.html
The cluster_transactions table shows information about all ongoing transactions in an NDB Cluster. (Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) block_instance refers to an instance of a kernel ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-transporters.html
This information is shown in the table's status column, which can have any one of the following values: CONNECTING, CONNECTED, DISCONNECTING, or DISCONNECTED. Connections to API and management nodes which are configured but not currently connected ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-other.html
ShmKey: Shared memory key; when set to 1, this is calculated by NDB. The listings in this section provide information about parameters used in the [computer], [tcp], and [shm] sections of a config.ini file for configuring NDB Cluster. For detailed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
Using ndbmtd differs from using ndbd in two key respects: Because ndbmtd runs by default in single-threaded mode (that is, it behaves like ndbd), you must configure it to use multiple threads. ndbmtd is a multithreaded version of ndbd, the process ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-shm-definition.html
ShmKey Version (or later) NDB 7.5.0 Type or units unsigned Default 0 Range 0 - 4294967039 (0xFFFFFEFF) Restart Type Node Restart: Requires a rolling restart of the cluster. If UseShm is enabled, the shared memory key is calculated automatically by ... Communications between NDB cluster nodes are normally handled using ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
The -S option to less can make the result set much more readable because you can scroll it horizontally using the left-arrow and right-arrow keys. mysql sends each SQL statement that you issue to the server to be executed. There is also a set of ...