- 17.4 MySQL Cluster Programs
- 17.4.1 ndbd — The MySQL Cluster Data Node Daemon
- 17.4.2 ndb_mgmd — The MySQL Cluster Management Server Daemon
- 17.4.3 ndb_mgm — The MySQL Cluster Management Client
- 17.4.4 ndb_config — Extract MySQL Cluster Configuration Information
- 17.4.5 ndb_cpcd — Automate Testing for NDB Development
- 17.4.6 ndb_delete_all — Delete All Rows from an NDB Table
- 17.4.7 ndb_desc — Describe NDB Tables
- 17.4.8 ndb_drop_index — Drop Index from an NDB Table
- 17.4.9 ndb_drop_table — Drop an NDB Table
- 17.4.10 ndb_error_reporter — NDB Error-Reporting Utility
- 17.4.11 ndb_print_backup_file — Print NDB Backup File Contents
- 17.4.12 ndb_print_schema_file — Print NDB Schema File Contents
- 17.4.13 ndb_print_sys_file — Print NDB System File Contents
- 17.4.14 ndb_restore — Restore a MySQL Cluster Backup
- 17.4.15 ndb_select_all — Print Rows from an NDB Table
- 17.4.16 ndb_select_count — Print Row Counts for NDB Tables
- 17.4.17 ndb_show_tables — Display List of NDB Tables
- 17.4.18 ndb_size.pl — NDBCLUSTER Size Requirement Estimator
- 17.4.19 ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
- 17.4.20 Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs
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 -cconnect_stringtbl_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 MySQL Cluster programs (including ndb_delete_all), see Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”.
Table 17.14. ndb_delete_all Options and Variables: MySQL 5.0
| Format | Description | Added / Removed |
|---|---|---|
| Name of the database in which the table is found | All MySQL 5.0 based releases |
| Perform the delete in a single transaction (may run out of operations) | All MySQL 5.0 based releases | |
| Run tup scan | All MySQL 5.0 based releases |
| Run disk scan | All MySQL 5.0 based releases |
User Comments
Add your own comment.