MySQL 5.7 Release Notes
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 21.43 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 5.7) |
|
| Number of times to retry connection before giving up | (Supported in all NDB releases based on MySQL 5.7) |
|
| Number of seconds to wait between attempts to contact management server | (Supported in all NDB releases based on MySQL 5.7) |
|
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) |
|
| Write core file on error; used in debugging | (Supported in all NDB releases based on MySQL 5.7) |
|
| Specifies database in which table is found; database name must be followed by table name | (Supported in all NDB releases based on MySQL 5.7) |
|
| Read given file after global files are read | (Supported in all NDB releases based on MySQL 5.7) |
|
| Read default options from given file only | (Supported in all NDB releases based on MySQL 5.7) |
|
| Also read groups with concat(group, suffix) | (Supported in all NDB releases based on MySQL 5.7) |
|
| Read given path from login file | (Supported in all NDB releases based on MySQL 5.7) |
|
| Number of times to repeat output | (Supported in all NDB releases based on MySQL 5.7) |
|
| Display help text and exit | (Supported in all NDB releases based on MySQL 5.7) |
|
| 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 5.7) |
|
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) |
|
| Set node ID for this node, overriding any ID set by --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) |
|
| 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 5.7) |
|
| Do not read default options from any option file other than login file | (Supported in all NDB releases based on MySQL 5.7) |
|
| Return output suitable for MySQL LOAD DATA statement | (Supported in all NDB releases based on MySQL 5.7) |
|
| Print program argument list and exit | (Supported in all NDB releases based on MySQL 5.7) |
|
| Show table temporary flag | (Supported in all NDB releases based on MySQL 5.7) |
|
| Limit output to objects of this type | (Supported in all NDB releases based on MySQL 5.7) |
|
| Do not qualify table names | (Supported in all NDB releases based on MySQL 5.7) |
|
| Display help text and exit; same as --help | (Supported in all NDB releases based on MySQL 5.7) |
|
| Display version information and exit | (Supported in all NDB releases based on MySQL 5.7) |
Usage
ndb_show_tables [-c connection_string]-
Command-Line Format --character-sets-dir=pathDirectory containing character sets.
-
Command-Line Format --connect-retries=#Type Integer Default Value 12Minimum Value 0Maximum Value 12Number of times to retry connection before giving up.
-
Command-Line Format --connect-retry-delay=#Type Integer Default Value 5Minimum Value 0Maximum Value 5Number of seconds to wait between attempts to contact management server.
-
Command-Line Format --connect-string=connection_stringType String Default Value [none]Same as
--ndb-connectstring. -
Command-Line Format --core-fileWrite 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_DBdatabase, ndb_show_tables issues a warning.-
Command-Line Format --defaults-extra-file=pathType String Default Value [none]Read given file after global files are read.
-
Command-Line Format --defaults-file=pathType String Default Value [none]Read default options from given file only.
-
Command-Line Format --defaults-group-suffix=stringType String Default Value [none]Also read groups with concat(group, suffix).
-
Command-Line Format --helpDisplay help text and exit.
-
Command-Line Format --login-path=pathType 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_stringType 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_stringType 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-selectionCommand-Line Format --ndb-optimized-node-selectionEnable optimizations for selection of nodes for transactions. Enabled by default; use
--skip-ndb-optimized-node-selectionto disable.-
Command-Line Format --no-defaultsDo 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-defaultsPrint 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 table2: User-created table3: Unique hash index
Any other value causes all
NDBdatabase objects to be listed (the default).If specified, this causes unqualified object names to be displayed.
-
Command-Line Format --usageDisplay help text and exit; same as
--help. -
Command-Line Format --versionDisplay version information and exit.
Note
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 21.5.25, “ndb_select_all — Print Rows from an NDB Table”).
Prior to NDB 7.5.18 and 7.6.14, this program printed
NDBT_ProgramExit -
upon completion of
its run, due to an unnecessary dependency on the
statusNDBT testing library. This dependency is has
now been removed, eliminating the extraneous output.