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/mysql-cluster-programs-ndb-blob-tool.html
This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB ...If you need to specify a database, use the --database (-d) ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
A BLOB is a binary large object that can hold a variable amount of data. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT ...These differ only in the maximum length of the values they can ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-blobs.html
The part and (NDB 8.0.30 and later) inline sizes of NDB blob columns can be set using CREATE TABLE and ALTER TABLE statements containing NDB table column comments (see NDB_COLUMN Options); this can also be done in NDB API applications (see ...Parts ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table ...Do not use this technique when the entire table is compressed by InnoDB or ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. This works for BLOB, MEDIUMBLOB, LONGBLOB, TEXT, MEDIUMTEXT, LONGTEXT, and JSON columns. Beginning ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
A BLOB or TEXT column continues to use 264 bytes of this total, as before. Beginning with NDB 8.0.20, the ndb_blob_tool utility can detect missing blob parts for which inline parts exist and replace these with placeholder blob parts (consisting of ... The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
--ndb-blob-read-batch-bytes=bytes Command-Line Format --ndb-blob-read-batch-bytes System Variable ndb_blob_read_batch_bytes Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 65536 Minimum Value 0 Maximum Value ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
This figure excludes BLOB or TEXT columns, which contribute only 9 to 12 bytes toward this size. For BLOB and TEXT data, the information is stored internally in a different area of memory than the row buffer. VARCHAR, VARBINARY, and the BLOB and ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
BLOB and TEXT columns only contribute 9 to 12 bytes toward the row size limit because their contents are stored separately from the rest of the row. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
These differences can be combined with other schema differences supported by ndb_restore, including changes to blob and text columns requiring the use of staging tables. When converting between character data types and TEXT or BLOB, only conversions ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...