MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
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_stringtbl_name-ddb_name
Options that can be used with ndb_drop_table are shown in the following table. Additional descriptions follow the table.
Table 25.33 Command-line options used with the program ndb_drop_table
| 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 |
|
|
Name of database in which table is found | (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) |
|
| Display help text and exit | (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) |
|
| 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) |
|
| Print program argument list and exit | (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) |
| 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
| 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 |
|---|---|
| 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.
| 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.