Search Results
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
The resulting fast database operations are then available to be reused by other queries, applications, and even code written in different programming languages. This section lists a number of miscellaneous tips for improving query processing speed: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
(NDB 8.4.0) For queries that are translated into full table scans or range scans on indexes, it is important for best performance to fetch records in properly sized batches. The speed at which queries are performed can vary by more than 40% ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
All memory allocation for a data node is performed when the node is started. This ensures that the data node can run in a stable manner without using swap memory, so that NDB can be used for latency-sensitive (realtime) applications. The reserved ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-storage-requirements.html
The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed amount of space. For each row, this is equal to the space required to store the largest possible value for that column. For ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/en/mysql-cluster-ps-tables.html
NDB provides information in the MySQL Performance Schema about ndbcluster plugin threads and instrumenting for transaction batch memory. These features are described in greater detail in the sections which follow. Thread names are shown in the name ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/mysql-releases.html
The MySQL release model is divided into two main tracks: LTS (Long-Term Support) and Innovation. All LTS and Innovation releases include bug and security fixes, and are considered production-grade quality. Figure 1.1 MySQL Release Schedule MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-indexes-create.html
If a collection is large and queries on a specific field are common, then consider creating an index on a specific field inside a document. Indexes are used to find documents with specific field values quickly. Without an index, MySQL must begin ...