PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb
ndb_show_tables displays a list of allNDB database objects in the cluster. By default, this includes not only both user-created tables andNDB system tables, butNDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as well.
Options that can be used withndb_show_tables are shown in the following table. Additional descriptions follow the table.
Usage
ndb_show_tables [-cconnection_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 tondb_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 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.
Only user-created NDB Cluster tables may be accessed from MySQL; system tables such asSYSTAB_0 are not visible tomysqld. However, you can examine the contents of system tables usingNDB API applications such asndb_select_all (seeSection 25.5.25, “ndb_select_all — Print Rows from an NDB Table”).
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb