MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

23.4.8 ndb_delete_all — Delete All Rows from an NDB Table

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 -c connection_string tbl_name -d db_name

This deletes all rows from the table named tbl_name in the database named db_name. It is exactly equivalent to executing TRUNCATE db_name.tbl_name in MySQL.

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 - status upon completion of its run, due to an unnecessary dependency on the NDBT testing library. This dependency has been removed, eliminating the extraneous output.