Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-shm-definition.html
SendBufferMemory Version (or later) NDB 8.4.0 Type or units integer Default 2M Range 256K - 4294967039 (0xFFFFFEFF) Restart Type Node Restart: Requires a rolling restart of the cluster. (NDB 8.4.0) When setting up shared memory segments, a node ID, ... Communications between NDB cluster nodes are normally handled using ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-indexes-create.html
The following example specifies an index named popul, defined against the Population field from the demographics object, indexed as an Integer numeric value. mysql-js> db.countryinfo.createIndex("popul", {fields: [{field: ... Indexes are used to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-index.html
The following example specifies an index named popul, defined against the Population field from the demographics object, indexed as an Integer numeric value. mysql-py> db.countryinfo.createIndex("popul", {fields: [{field: ... Indexes are used to ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
In addition, you can define the ranges using columns of types other than integer types. RANGE COLUMNS partitioning columns are not restricted to integer columns; string, DATE and DATETIME columns can also be used as partitioning columns. As stated ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns.html
In addition, both RANGE COLUMNS partitioning and LIST COLUMNS partitioning support the use of non-integer columns for defining value ranges or list members. The permitted data types are shown in the following list: All integer types: TINYINT, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
In the case of RANGE, LIST, and [LINEAR] HASH partitioning, the value of the partitioning column is passed to the partitioning function, which returns an integer value representing the number of the partition in which that particular record should ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
MAXVALUE represents an integer value that is always greater than the largest possible integer value (in mathematical language, it serves as a least upper bound). A table that is partitioned by range is partitioned in such a way that each partition ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-numbers.html
The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals. Exact-value numeric literals have an integer part or fractional part, or both.
https://dev.mysql.com/doc/refman/8.4/en/select.html
LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants, with these exceptions: Within prepared statements, LIMIT parameters can be specified using ? placeholder markers. Within stored programs, LIMIT parameters ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
For example, in NDB tables, the TINYINT, SMALLINT, MEDIUMINT, and INTEGER (INT) column types each require 4 bytes storage per record due to the alignment factor. Storage for the integer and fractional parts of each value are determined separately.