https://dev.mysql.com/check-table.html
It does not validate the key pointer to a clustered record or follow the path for BLOB pointers. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views ...
https://dev.mysql.com/condition-pushdown-optimization.html
Columns used in comparisons cannot be of any of the BLOB or TEXT types. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage ...
https://dev.mysql.com/crashing.html
If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT columns), you can try to change all VARCHAR to CHAR with ALTER TABLE. Each MySQL version is tested on many platforms before it ...
https://dev.mysql.com/create-table-foreign-keys.html
One consequence of this is that BLOB and TEXT columns cannot be included in a foreign key because indexes on those columns must always include a prefix length. MySQL supports foreign keys, which let you cross-reference related data across tables, ...
https://dev.mysql.com/create-table-secondary-indexes.html
JSON columns and indirect indexing in NDB Cluster It is also possible to use indirect indexing of JSON columns in MySQL NDB Cluster, subject to the following conditions: NDB handles a JSON column value internally as a BLOB. A secondary index defined ...
https://dev.mysql.com/create-tablespace.html
All parts of an InnoDB table added to an InnoDB general tablespace reside in the general tablespace, including indexes and BLOB pages. The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces ...
https://dev.mysql.com/data-size.html
(InnoDB compressed tables are readable and writable, while MyISAM compressed tables are read-only.) For MyISAM tables, if you do not have any variable-length columns (VARCHAR, TEXT, or BLOB columns), a fixed-size row format is used. Design your ...
https://dev.mysql.com/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a little more complex than static ...
https://dev.mysql.com/error-lost-connection.html
If the cause is none of those just described, you may be experiencing a problem with BLOB values that are larger than max_allowed_packet, which can cause this error with some clients. Usually it indicates network connectivity trouble and you should ...
https://dev.mysql.com/extensions-to-ansi.html
Data types The MEDIUMINT, SET, and ENUM data types, and the various BLOB and TEXT data types. MySQL Server supports some extensions that you probably will not find in other SQL DBMSs. Be warned that if you use them, your code will not be portable ...
