ndb_show_tables displays a list of all NDB database objects in the cluster. By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as well.
Options that can be used with ndb_show_tables are shown in the following table. Additional descriptions follow the table.
Table 23.47 Command-line options used with the program ndb_show_tables
| Format | Description | Added, Deprecated, or Removed |
|---|---|---|
| Directory containing character sets | (Supported in all NDB releases based on MySQL 8.0) |
|
| Number of times to retry connection before giving up | (Supported in all NDB releases based on MySQL 8.0) |
|
| Number of seconds to wait between attempts to contact management server | (Supported in all NDB releases based on MySQL 8.0) |
|
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 8.0) |
|
| Write core file on error; used in debugging | (Supported in all NDB releases based on MySQL 8.0) |
|
| Specifies database in which table is found; database name must be followed by table name | (Supported in all NDB releases based on MySQL 8.0) |
|
| Read given file after global files are read | (Supported in all NDB releases based on MySQL 8.0) |
|
| Read default options from given file only | (Supported in all NDB releases based on MySQL 8.0) |
|
| Also read groups with concat(group, suffix) | (Supported in all NDB releases based on MySQL 8.0) |
|
| Read given path from login file | (Supported in all NDB releases based on MySQL 8.0) |
|
| Number of times to repeat output | (Supported in all NDB releases based on MySQL 8.0) |
|
| Display help text and exit | (Supported in all NDB releases based on MySQL 8.0) |
|
| Set connect string for connecting to ndb_mgmd. Syntax: "[nodeid=id;][host=]hostname[:port]". Overrides entries in NDB_CONNECTSTRING and my.cnf | (Supported in all NDB releases based on MySQL 8.0) |
|
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 8.0) |
|
| Set node ID for this node, overriding any ID set by --ndb-connectstring | (Supported in all NDB releases based on MySQL 8.0) |
|
| Enable optimizations for selection of nodes for transactions. Enabled by default; use --skip-ndb-optimized-node-selection to disable | (Supported in all NDB releases based on MySQL 8.0) |
|
| Do not read default options from any option file other than login file | (Supported in all NDB releases based on MySQL 8.0) |
|
| Return output suitable for MySQL LOAD DATA statement | (Supported in all NDB releases based on MySQL 8.0) |
|
| Print program argument list and exit | (Supported in all NDB releases based on MySQL 8.0) |
|
| Show table temporary flag | (Supported in all NDB releases based on MySQL 8.0) |
|
| Limit output to objects of this type | (Supported in all NDB releases based on MySQL 8.0) |
|
| Do not qualify table names | (Supported in all NDB releases based on MySQL 8.0) |
|
| Display help text and exit; same as --help | (Supported in all NDB releases based on MySQL 8.0) |
|
| Display version information and exit | (Supported in all NDB releases based on MySQL 8.0) |
ndb_show_tables [-c connection_string]
| Command-Line Format | --character-sets-dir=path |
|---|
Directory containing character sets.
| Command-Line Format | --connect-retries=# |
|---|---|
| Type | Integer |
| Default Value | 12 |
| Minimum Value | 0 |
| Maximum Value | 12 |
Number of times to retry connection before giving up.
| Command-Line Format | --connect-retry-delay=# |
|---|---|
| Type | Integer |
| Default Value | 5 |
| Minimum Value | 0 |
| Maximum Value | 5 |
Number of seconds to wait between attempts to contact management server.
| Command-Line Format | --connect-string=connection-string |
|---|---|
| Type | String |
| Default Value | [none] |
Same as --ndb-connectstring.
| Command-Line Format | --core-file |
|---|
Write core file on error; used in debugging.
Specifies the name of the database in which the desired table is found. If this option is given, the name of a table must follow the database name.
If this option has not been specified, and no tables are found in the TEST_DB database, ndb_show_tables issues a warning.
| Command-Line Format | --defaults-extra-file=path |
|---|---|
| Type | String |
| Default Value | [none] |
Read given file after global files are read.
| Command-Line Format | --defaults-file=path |
|---|---|
| Type | String |
| Default Value | [none] |
Read default options from given file only.
| Command-Line Format | --defaults-group-suffix=string |
|---|---|
| Type | String |
| Default Value | [none] |
Also read groups with concat(group, suffix).
| Command-Line Format | --help |
|---|
Display help text and exit.
| Command-Line Format | --login-path=path |
|---|---|
| Type | String |
| Default Value | [none] |
Read given path from login file.
Specifies the number of times the utility should execute. This is 1 when this option is not specified, but if you do use the option, you must supply an integer argument for it.
| Command-Line Format | --ndb-connectstring=connection-string |
|---|---|
| Type | String |
| Default Value | [none] |
Set connect string for connecting to ndb_mgmd. Syntax: "[nodeid=id;][host=]hostname[:port]". Overrides entries in NDB_CONNECTSTRING and my.cnf.
| Command-Line Format | --ndb-mgmd-host=connection-string |
|---|---|
| Type | String |
| Default Value | [none] |
Same as --ndb-connectstring.
| Command-Line Format | --ndb-nodeid=# |
|---|---|
| Type | Integer |
| Default Value | [none] |
Set node ID for this node, overriding any ID set by --ndb-connectstring.
--ndb-optimized-node-selection
| Command-Line Format | --ndb-optimized-node-selection |
|---|
Enable optimizations for selection of nodes for transactions. Enabled by default; use --skip-ndb-optimized-node-selection to disable.
| Command-Line Format | --no-defaults |
|---|
Do not read default options from any option file other than login file.
Using this option causes the output to be in a format suitable for use with LOAD DATA.
| Command-Line Format | --print-defaults |
|---|
Print program argument list and exit.
If specified, this causes temporary tables to be displayed.
Can be used to restrict the output to one type of object, specified by an integer type code as shown here:
1: System table
2: User-created table
3: Unique hash index
Any other value causes all NDB database objects to be listed (the default).
If specified, this causes unqualified object names to be displayed.
| Command-Line Format | --usage |
|---|
Display help text and exit; same as --help.
| Command-Line Format | --version |
|---|
Display version information and exit.
Only user-created NDB Cluster tables may be accessed from MySQL; system tables such as SYSTAB_0 are not visible to mysqld. However, you can examine the contents of system tables using NDB API applications such as ndb_select_all (see Section 23.4.24, “ndb_select_all — Print Rows from an NDB Table”).
Prior to NDB 8.0.20, this program printed NDBT_ProgramExit - upon completion of its run, due to an unnecessary dependency on the statusNDBT testing library. This dependency has been removed, eliminating the extraneous output.