PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-limits.html
LONGBLOB and LONGTEXT columns must be less than 4GB, and the total row size, including BLOB and TEXT columns, must be less than 4GB. This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/innodb-memcached-internals.html
value_columns: Must be mapped to a CHAR, VARCHAR, or BLOB column. InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded InnoDB. InnoDB API ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/innodb-parameters.html
It does not apply to external pages used for TEXT or BLOB entries. InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- prefix. For ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
Inserting a string into a string column (CHAR, VARCHAR, TEXT, or BLOB) that exceeds the column maximum length. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. MySQL Server also includes an SQL interface for keyring key management, implemented as a set of ...
https://dev.mysql.com/doc/refman/8.0/en/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. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/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. The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-optimization-tips.html
If you have data that does not conform well to a rows-and-columns table structure, you can pack and store data into a BLOB column. This section lists a number of miscellaneous tips for improving query processing speed: If your application makes ...