MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6
ndb_delete_all deletes all rows from the
given NDB table. In some cases,
this can be much faster than
DELETE or even
TRUNCATE TABLE.
ndb_delete_all -cconnection_stringtbl_name-ddb_name
This deletes all rows from the table named
tbl_name in the database named
db_name. It is exactly equivalent to
executing TRUNCATE
in MySQL.
db_name.tbl_name
Options that can be used with ndb_delete_all are shown in the following table. Additional descriptions follow the table.
Table 21.28 Command-line options used with the program ndb_delete_all
| 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 the database in which the 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) |
|
|
Perform disk scan | (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) |
|
| Perform delete in one single transaction; possible to run out of operations when used | (Supported in all NDB releases based on MySQL 5.7) |
|
|
Perform tuple scan | (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 containing the table to delete from.
| 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 | --diskscan |
|---|
Run a disk scan.
| 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.
Use of this option causes the delete operation to be performed as a single transaction.
With very large tables, using this option may cause the number of operations available to the cluster to be exceeded.
Run a tuple scan.
| Command-Line Format | --usage |
|---|
Display help text and exit; same as --help.
| Command-Line Format | --version |
|---|
Display version information and exit.