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/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/engine-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/doc/refman/8.0/en/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/doc/refman/8.0/en/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 are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
Priot to NDB 8.0, the maximum size for a table row is 14 kilobytes, not counting BLOB values. In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage engine. Which versions of the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
For example, creating a FEDERATED table fails if the table uses an index prefix on any VARCHAR, TEXT or BLOB columns. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a ...
https://dev.mysql.com/doc/refman/8.0/en/fetching-spatial-data.html
SELECT ST_AsText(g) FROM geom; Fetching spatial data in WKB format: The ST_AsBinary() function converts a geometry from internal format to a BLOB containing the WKB value. Geometry values stored in a table can be fetched in internal format.
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
For the end state, the following operations could be happening: Writing an event to the binary log Freeing memory buffers, including for blobs executing The thread has begun executing a statement. The following list describes thread State values ...