Search Results
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
For example, the following commands configure MySQL for 32-bit or 64-bit builds, respectively: $> cmake .. To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, ...
https://dev.mysql.com/doc/refman/8.4/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
BLOB BIT OPAQUE DATETIME TIME DATE BOOLEAN ARRAY OBJECT STRING INTEGER, DOUBLE NULL For JSON values of the same precedence, the comparison rules are type specific: BLOB The first N bytes of the two values are compared, where N is the number of bytes ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-debian.html
Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux systems. The packages are available through two different channels: The MySQL APT Repository. This is the preferred method for installing MySQL on Debian-like ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
sizeof(char*) is 4 on 32-bit machines and 8 on 64-bit machines. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to crashes, hardware issues, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-database-objects.html
The maximum combined width for all BIT columns used in a given NDB table is 4096. Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Number of database objects. The maximum number ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Also see Section 25.2.7.6, “Unsupported or Missing Features in NDB Cluster”, for additional information.) BIT columns. A BIT column cannot be a primary key, unique key, or index, nor can it be part of a composite primary key, unique key, or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
server_id_bits: Number of least significant bits in server_id actually used for identifying server, permitting NDB API applications to store application data in most significant bits. The following list includes command-line options, system ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-mta.html
(See Section 19.1.4.1, “Replication Mode Concepts”.) The writeset implementation employed by MySQL (and NDB Cluster) uses hash-based conflict detection based on matching 64-bit row hashes of relevant table and index values. This detects reliably ...To use this functionality with NDB Cluster, it is necessary that the replica be configured to use multiple worker ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-types.html
The BIT data type stores bit values and is supported for MyISAM, MEMORY, InnoDB, and NDB tables. These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, ...