Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.3Kb
Man Pages (Zip) - 402.5Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

25.6.16.4 The ndbinfo blobs Table

This table provides about blob values stored inNDB. Theblobs table has the columns listed here:

  • table_id

    Unique ID of the table containing the column

  • database_name

    Name of the database in which this table resides

  • table_name

    Name of the table

  • column_id

    The column's unique ID within the table

  • column_name

    Name of the column

  • inline_size

    Inline size of the column

  • part_size

    Part size of the column

  • stripe_size

    Stripe size of the column

  • blob_table_name

    Name of the blob table containing this column's blob data, if any

Rows exist in this table for thoseNDB table columns that storeBLOB,TEXT values taking up more than 255 bytes and thus require the use of a blob table. Parts ofJSON values exceeding 4000 bytes in size are also stored in this table. For more information about how NDB Cluster stores columns of such types, seeString Type Storage Requirements.

The part and (NDB 8.0.30 and later) inline sizes ofNDB blob columns can be set usingCREATE TABLE andALTER TABLE statements containingNDB table column comments (seeNDB_COLUMN Options); this can also be done in NDB API applications (seeColumn::setPartSize() andsetInlineSize()).

Theblobs table was added in NDB 8.0.29.