Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
For example, consider a table with 5 attributes: one 64-bit attribute, one 32-bit attribute, two 16-bit attributes, and one array of 64 8-bit attributes. Return value The number of table fragments, as a 32-bit unsigned integer. Return value The ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
MySQL bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types) and return a value of like type, which enables them to take arguments and produce return values larger than 64 bits. For discussion about ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
mysql> SELECT BIN(12); -> '1100' BIT_LENGTH(str) Returns the length of the string str in bits. mysql> SELECT ELT(1, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Aa' mysql> SELECT ELT(4, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Dd' ...For functions that operate on string ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
The following example illustrates how an error can occur when a lock request causes a deadlock. Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbdictionary.html
NdbDictionary Class Overview NdbDictionary::AutoGrowSpecification NdbDictionary::getEmptyBitmask() NdbDictionary::getFirstAttrId() NdbDictionary::getNextAttrId() NdbDictionary::getNullBitOffset() NdbDictionary::getOffset() ... This section provides ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
Time: The “old” version of this type is stored as a 24-bit signed int value stored in little-endian format (lowest order byte in lowest order address). The integer part is encoded as shown in the following table: Table 2.3 Time2 encoding Bits ...
https://dev.mysql.com/doc/internals/en/date-and-time-data-type-representation.html
The following table shows the storage requirements for date and time data types. Storage for these types is big endian (for memcmp() compatibility purposes), with the nonfractional part followed by the fractional part. FSP Storage 0 0 bytes 1,2 1 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
When gtid_mode is not ON, the maximum recommended value is 4GB, due to the fact that, in this case, MySQL cannot work with binary log positions greater than 4GB; when gtid_mode is ON, this limitation does not apply, and the server can work with ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
Each bit of this variable represents a table, and is set to 1 if the corresponding table is to be updated by the statement. The low-order five bits are 1 to indicate an empty option (has a length of 0) or 0 to indicate a non-empty option (has a ...
https://dev.mysql.com/doc/internals/en/innodb-extra-bytes.html
If you're just trying to read the record, the key bit in the Extra Bytes is 1byte_offs_flag — you need to know if 1byte_offs_flag is 1 (that is, "short 1-byteoffsets") or 0 (that is, "2-byte offsets"). Given a pointer to the Origin, InnoDB finds ...