MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
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 25.48 Command-line options used with the program ndb_show_tables
Format | Description | Added, Deprecated, or Removed |
---|---|---|
Directory containing character sets | REMOVED: 8.0.31 |
|
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 | REMOVED: 8.0.31 |
|
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 | REMOVED: 8.0.31 |
|
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 |
---|---|
Removed | 8.0.31 |
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 |
---|---|
Removed | 8.0.31 |
Write core file on error; used in debugging.
--database
,
-d
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.
--loops
,
-l
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 |
---|---|
Removed | 8.0.31 |
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.
--parsable
,
-p
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.
--type
,
-t
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).
--unqualified
,
-u
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 25.5.25, “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
status
NDBT
testing library. This dependency has
been removed, eliminating the extraneous output.