https://dev.mysql.com/innodb-file-space.html
LONGBLOB and LONGTEXT columns must be less than 4GB, and the total row length, including BLOB and TEXT columns, must be less than 4GB. The data files that you define in the configuration file using the innodb_data_file_path configuration option ...
https://dev.mysql.com/innodb-memcached-developing.html
The data stored through the daemon_memcached plugin goes into VARCHAR, TEXT, or BLOB columns, and must be converted to do numeric operations. Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or ...
https://dev.mysql.com/innodb-memcached-internals.html
value_columns: Must be mapped to a CHAR, VARCHAR, or BLOB column. The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded InnoDB. InnoDB API functions are passed to the InnoDB memcached ...
https://dev.mysql.com/innodb-multiple-tablespaces.html
You can enable more efficient storage for tables with large BLOB or TEXT columns using the dynamic row format. This monolithic approach was targeted at machines dedicated to database processing, with carefully planned data growth, where any disk ...
https://dev.mysql.com/innodb-online-ddl-operations.html
When you add a primary key using the ALGORITHM=COPY clause, MySQL converts NULL values in the associated columns to default values: 0 for numbers, an empty string for character-based columns and BLOBs, and 0000-00-00 00:00:00 for DATETIME. Online ...
https://dev.mysql.com/innodb-parameters.html
It does not apply to external pages used for TEXT or BLOB entries. System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- prefix. For example, to enable or disable the InnoDB adaptive ...
https://dev.mysql.com/insert.html
Inserting a string into a string column (CHAR, VARCHAR, TEXT, or BLOB) that exceeds the column's maximum length. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name ...
https://dev.mysql.com/keyring-udfs-general-purpose.html
MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...
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/load-data.html
Some cases are not supported by LOAD DATA: Fixed-size rows (FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty) and BLOB or TEXT columns. INTO Syntax”.) To write data from a table to a file, use SELECT ... To read the file back into a table, ...
