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-performance.html
The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance issues due to sequential access to the NDB storage engine; it is also relatively more expensive to do many range ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-syntax.html
Using nullable columns in unique keys and primary keys means that queries using these columns are handled as full table scans. Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memoryusage.html
Querying this table provides information similar to that provided by the ALL REPORT MemoryUsage command in the ndb_mgm client, or logged by ALL DUMP 1000. The memoryusage table contains the following columns: node_id The node ID of this data node.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
NDB Cluster requires communication between data nodes and API nodes (including SQL nodes), as well as between data nodes and other data nodes, to execute queries and updates. Communication latency between these processes can directly affect the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
NDB Cluster supports distribution of MySQL users and privileges across all SQL nodes in an NDB Cluster. This support is not enabled by default; you should follow the procedure outlined in this section in order to do so. Normally, each MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-multi-source.html
It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of clusters. Each cluster has two SQL nodes, with SQL nodes A and B belonging to Cluster 1, SQL nodes C and ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
The server's binary log consists of files containing “events” that describe modifications to database contents. To display their contents in text format, use the mysqlbinlog utility. You can also use mysqlbinlog to display the contents of relay ...
https://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). 5.7.13 / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-benchmarking.html
To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of time. With simple tests, you usually test how ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
When a long-running transaction modifies a table, queries against that table from other transactions do not make use of the covering index technique. Queries that normally could retrieve all the result columns from a secondary index, instead look up ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...