MySQL 8.3 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 25.47 Command-line options used with the program ndb_show_tables
| Format | Description | Added, Deprecated, or Removed |
|---|---|---|
| Number of times to retry connection before giving up |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Number of seconds to wait between attempts to contact management server |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Same as --ndb-connectstring |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Specifies database in which table is found; database name must be followed by table name |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Read given file after global files are read |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Read default options from given file only |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Also read groups with concat(group, suffix) |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Read given path from login file |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Do not read login paths from the login path file |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Number of times to repeat output |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Display help text and exit |
(Supported in all NDB releases based on MySQL 8.3) |
|
| 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.3) |
|
| ndb_mgm client TLS requirement level |
ADDED: 8.3.0 |
|
| Same as --ndb-connectstring |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Set node ID for this node, overriding any ID set by --ndb-connectstring |
(Supported in all NDB releases based on MySQL 8.3) |
|
| List of directories containing TLS keys and certificates |
ADDED: 8.3.0 |
|
| Do not read default options from any option file other than login file |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Return output suitable for MySQL LOAD DATA statement |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Print program argument list and exit |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Show table temporary flag |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Limit output to objects of this type |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Do not qualify table names |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Display help text and exit; same as --help |
(Supported in all NDB releases based on MySQL 8.3) |
|
| Display version information and exit |
(Supported in all NDB releases based on MySQL 8.3) |
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.
-
--database,-dSpecifies 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.
-
Command-Line Format --no-login-pathsSkips reading options from the login path file.
-
--loops,-lSpecifies 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 connection string for connecting to ndb_mgmd. Syntax:
[nodeid=. Overrides entries inid;][host=]hostname[:port]NDB_CONNECTSTRINGandmy.cnf. -
Command-Line Format --ndb-mgm-tls=levelType Enumeration Default Value relaxedValid Values relaxedstrictSets the level of TLS support required to connect to the management server; one of
relaxedorstrict.relaxed(the default) means that a TLS connection is attempted, but success is not required;strictmeans that TLS is required to connect. -
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 --ndb-tls-search-path=listType Path name Default Value (Unix) $HOME/ndb-tlsDefault Value (Windows) $HOMEDIR/ndb-tlsSpecify a list of directories to search for a CA file. On Unix platforms, the directory names are separated by colons (
:); on Windows systems, the semicolon character (;) is used as the separator. A directory reference may be relative or absolute; it may contain one or more environment variables, each denoted by a prefixed dollar sign ($), and expanded prior to use.Searching begins with the leftmost named directory and proceeds from left to right until a file is found. An empty string denotes an empty search path, which causes all searches to fail. A string consisting of a single dot (
.) indicates that the search path limited to the current working directory.If no search path is supplied, the compiled-in default value is used. This value depends on the platform used: On Windows, this is
\ndb-tls; on other platforms (including Linux), it is$HOME/ndb-tls. This can be overridden by compiling NDB Cluster using-DWITH_NDB_TLS_SEARCH_PATH. -
Command-Line Format --no-defaultsDo not read default options from any option file other than login file.
-
--parsable,-pUsing 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.
-
--type,-tCan 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
NDBdatabase objects to be listed (the default). -
-
--unqualified,-uIf 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 25.5.25, “ndb_select_all — Print Rows from an NDB Table”).