MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6
ndb_drop_table drops the specified
NDB
table. (If you try to use this
on a table created with a storage engine other than
NDB
, the attempt fails with the
error 723: No such table exists.) This
operation is extremely fast; in some cases, it can be an order
of magnitude faster than using a MySQL DROP
TABLE
statement on an NDB
table.
ndb_drop_table -cconnection_string
tbl_name
-ddb_name
Options that can be used with ndb_drop_table are shown in the following table. Additional descriptions follow the table.
Table 21.31 Command-line options used with the program ndb_drop_table
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) |
|
|
Name of database in which table is found | (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) |
|
Display help text and exit | (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) |
|
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) |
|
Print program argument list and exit | (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) |
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.
Command-Line Format | --database=name |
---|---|
Type | String |
Default Value | TEST_DB |
Name of the database in which the table resides.
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.
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.
Command-Line Format | --print-defaults |
---|
Print program argument list and exit.
Command-Line Format | --usage |
---|
Display help text and exit; same as
--help
.
Command-Line Format | --version |
---|
Display version information and exit.