Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.6Mb
PDF (A4) - 35.6Mb
PDF (RPM) - 34.6Mb
EPUB - 8.7Mb
HTML Download (TGZ) - 8.4Mb
HTML Download (Zip) - 8.5Mb
HTML Download (RPM) - 7.3Mb
Eclipse Doc Plugin (TGZ) - 9.3Mb
Eclipse Doc Plugin (Zip) - 11.4Mb
Man Pages (TGZ) - 202.1Kb
Man Pages (Zip) - 307.5Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  ndb_delete_all — Delete All Rows from an NDB Table

19.4.9 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 MySQL Cluster programs (including ndb_delete_all), see Section 19.4.27, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”.

Table 19.91 This table describes command-line options for the ndb_delete_all program

Format Description Added or Removed



Name of the database in which the table is found

All MySQL 5.7 based releases



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

All MySQL 5.7 based releases


Run tup scan

All MySQL 5.7 based releases


Run disk scan

All MySQL 5.7 based releases

  • --transactional, -t

    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.

User Comments
Sign Up Login You must be logged in to post a comment.