MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

22.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.

Usage

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 22.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”.

Table 22.29 Command-line options for the ndb_delete_all program

Format Description Added, Deprecated, or Removed

--database=dbname,

-d

Name of the database in which the table is found

(Supported in all MySQL 8.0 based releases)

--transactional,

-t

Perform the delete in a single transaction (may run out of operations)

(Supported in all MySQL 8.0 based releases)

--tupscan

Run tup scan

(Supported in all MySQL 8.0 based releases)

--diskscan

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.