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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-spatial-analysis.html
The most typical operations are: Point queries that search for all objects that contain a given point Region queries that search for all objects that overlap a given region MySQL uses R-Trees with quadratic splitting for SPATIAL indexes on spatial ... For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL ...
https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html
Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use PAM (Pluggable Authentication Modules) to ...