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.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

25.6.16.23 The ndbinfo dictionary_tables Table

This table providesNDB dictionary information forNDB tables.dictionary_tables contains the columns listed here:

  • table_id

    The table' unique ID

  • database_name

    Name of the database containing the table

  • table_name

    Name of the table

  • status

    The table status; one ofNew,Changed,Retrieved,Invalid, orAltered. (SeeObject::Status, for more information about object status values.)

  • attributes

    Number of table attributes

  • primary_key_cols

    Number of columns in the table's primary key

  • primary_key

    A comma-separated list of the columns in the table's primary key

  • storage

    Type of storage used by the table; one ofmemory,disk, ordefault

  • logging

    Whether logging is enabled for this table

  • dynamic

    1 if the table is dynamic, otherwise0; the table is considered dynamic iftable->getForceVarPart() is true, or if at least one table column is dynamic

  • read_backup

    1 if read from any replica (READ_BACKUP option is enabled for this table, otherwise0; seeSection 15.1.20.12, “Setting NDB Comment Options”)

  • fully_replicated

    1 ifFULLY_REPLICATED is enabled for this table (each data node in the cluster has a complete copy of the table),0 if not; seeSection 15.1.20.12, “Setting NDB Comment Options”

  • checksum

    If this table uses a checksum, the value in this column is1; if not, it is0

  • row_size

    The amount of data, in bytes that can be stored in one row, not including any blob data stored separately in blob tables; seeTable::getRowSizeInBytes(), in the API documentation, for more information

  • min_rows

    Minimum number of rows, as used for calculating partitions; seeTable::getMinRows(), in the API documentation, for more information

  • max_rows

    Maximum number of rows, as used for calculating partitions; seeTable::getMaxRows(), in the API documentation, for more information

  • tablespace

    ID of the tablespace to which the table belongs, if any; this is0, if the table does not use data on disk

  • fragment_type

    The table's fragment type; one ofSingle,AllSmall,AllMedium,AllLarge,DistrKeyHash,DistrKeyLin,UserDefined,unused, orHashMapPartition; for more information, seeObject::FragmentType, in the NDB API documentation

  • hash_map

    The hash map used by the table

  • fragments

    Number of table fragments

  • partitions

    Number of partitions used by the table

  • partition_balance

    Type of partition balance used, if any; one ofFOR_RP_BY_NODE,FOR_RA_BY_NODE,FOR_RP_BY_LDM,FOR_RA_BY_LDM,FOR_RA_BY_LDM_X_2,FOR_RA_BY_LDM_X_3, orFOR_RA_BY_LDM_X_4; seeSection 15.1.20.12, “Setting NDB Comment Options”

  • contains_GCI

    1 if the table includes a global checkpoint index, otherwise0

  • single_user_mode

    Type of access allowed to the table when single user mode is in effect; one oflocked,read_only, orread_write; these are equivalent to the valuesSingleUserModeLocked,SingleUserModeReadOnly, andSingleUserModeReadWrite, respectively, of theTable::SingleUserMode type in the NDB API

  • force_var_part

    This is1 iftable->getForceVarPart() is true for this table, and0 if it is not

  • GCI_bits

    Used in testing

  • author_bits

    Used in testing

Thedictionary_tables table was added in NDB 8.0.29.