https://dev.mysql.com/innodb-compression-tuning.html
On the other hand, tables containing mostly binary data (integers or floating point numbers) or data that is previously compressed (for example JPEG or PNG images) may not generally compress well, significantly or at all. Most often, the internal ...
https://dev.mysql.com/innodb-locking-reads.html
Your application code can ensure referential integrity throughout this sequence of operations. For another example, consider an integer counter field in a table CHILD_CODES, used to assign a unique identifier to each child added to table CHILD. If ...
https://dev.mysql.com/insert.html
The value stored in the INT and YEAR columns is 1999 because the string-to-number conversion looks only at as much of the initial part of the string as may be considered a valid integer or year. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] ...
https://dev.mysql.com/json-search-functions.html
Two scalar values are comparable if they have the same JSON_TYPE() types, with the exception that values of types INTEGER and DECIMAL are also comparable to each other. The functions in this section perform search or comparison operations on JSON ...
https://dev.mysql.com/json-table-functions.html
Saving an object or array triggers the optional on error clause; this also occurs when an error takes place during coercion from the value saved as JSON to the table column, such as trying to save the string 'asd' to an integer column. This section ...
https://dev.mysql.com/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/key-space.html
Numbers are stored with the high byte first, so this helps when you have many integer keys that have an identical prefix. You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. This is for the worst case ...
https://dev.mysql.com/keywords-table.html
RESERVED An integer indicating whether the keyword is reserved (1) or nonreserved (0). The KEYWORDS table lists the words considered keywords by MySQL and, for each one, indicates whether it is reserved. Reserved keywords may require special ...
https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/locking-service-c-interface.html
lock_timeout: An integer number of seconds to wait to acquire the locks before giving up. This section describes how to use the locking service C language interface. To use the UDF interface instead, see Section 29.3.1.2, “The Locking Service UDF ...
