PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
Metadata contention increases the more that multiple queries attempt to access the same objects. MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. Metadata locking applies not just to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-api-definition.html
(NDB 8.0.13) 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.0/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.0/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.0/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.0/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.0/en/mysql-cluster-ps-tables.html
NDB 8.0 provides information in the MySQL Performance Schema about threads and transaction memory usage; NDB 8.0.29 adds ndbcluster plugin threads, and NDB 8.0.30 adds instrumenting for transaction batch memory. These features are described in ...
https://dev.mysql.com/doc/refman/8.0/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 ...