MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
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_string
tbl_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
The following table includes options that are specific to ndb_delete_all. Additional descriptions follow the table. For options common to most NDB Cluster programs (including ndb_delete_all), see Section 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”.
Table 23.30 Command-line options for the ndb_delete_all program
Format | Description | Added, Deprecated, or Removed |
---|---|---|
|
Name of the database in which the table is found | (Supported in all MySQL 8.0 based releases) |
Perform the delete in a single transaction (may run out of operations) | (Supported in all MySQL 8.0 based releases) |
|
|
Run tup scan | (Supported in all MySQL 8.0 based releases) |
|
Run disk scan | (Supported in all MySQL 8.0 based releases) |
Prior to NDB 8.0.18, this program printed
NDBT_ProgramExit -
upon completion of
its run, due to an unnecessary dependency on the
status
NDBT
testing library. This dependency has
been removed, eliminating the extraneous output.