17.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 connect_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 MySQL Cluster programs (including ndb_delete_all), see Section 17.4.25, "Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs".

Table 17.15. ndb_delete_all Options and Variables: MySQL ClusterNDB 7.3

Format	Description	Added / Removed
`--database=dbname`, `-d`	Name of the database in which the table is found	All MySQL 5.6 based releases
`--transactional`, `-t`	Perform the delete in a single transaction (may run out of operations)	All MySQL 5.6 based releases
`--tupscan`	Run tup scan	All MySQL 5.6 based releases
`--diskscan`	Run disk scan	All MySQL 5.6 based releases

--transactional, -t

Use of this option causes the delete operation to be performed as a single transaction.

Warning

With very large tables, using this option may cause the number of operations available to the cluster to be exceeded.