25.5.8 ndb_delete_all — Delete All Rows from an NDB Table

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

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

Options that can be used with ndb_delete_all are shown in the following table. Additional descriptions follow the table.

• --character-sets-dir

Directory containing character sets. - --connect-retries

Number of times to retry connection before giving up. - --connect-retry-delay

Number of seconds to wait between attempts to contact management server. - --connect-string

Same as --ndb-connectstring. - --core-file

Write core file on error; used in debugging. - --database, -d

Name of the database containing the table to delete from. - --defaults-extra-file

Read given file after global files are read. - --defaults-file

Read default options from given file only. - --defaults-group-suffix

Also read groups with concat(group, suffix). - --diskscan

Run a disk scan. - --help

Display help text and exit. - --login-path

Read given path from login file. - --no-login-paths

Skips reading options from the login path file. - --ndb-connectstring

Set connection string for connecting to ndb_mgmd. Syntax: [nodeid=id;][host=]hostname[:port]. Overrides entries in NDB_CONNECTSTRING and my.cnf. - --ndb-mgm-tls

Sets the level of TLS support required to connect to the management server; one of relaxed or strict. relaxed (the default) means that a TLS connection is attempted, but success is not required; strict means that TLS is required to connect. - --ndb-mgmd-host

Same as --ndb-connectstring. - --ndb-nodeid

Set node ID for this node, overriding any ID set by --ndb-connectstring. - --ndb-optimized-node-selection

Enable optimizations for selection of nodes for transactions. Enabled by default; use --skip-ndb-optimized-node-selection to disable. - --ndb-tls-search-path

Specify a list of directories to search for a CA file. On Unix platforms, the directory names are separated by colons (:); on Windows systems, the semicolon character (;) is used as the separator. A directory reference may be relative or absolute; it may contain one or more environment variables, each denoted by a prefixed dollar sign ($), and expanded prior to use.

Searching begins with the leftmost named directory and proceeds from left to right until a file is found. An empty string denotes an empty search path, which causes all searches to fail. A string consisting of a single dot (.) indicates that the search path limited to the current working directory.

If no search path is supplied, the compiled-in default value is used. This value depends on the platform used: On Windows, this is \ndb-tls; on other platforms (including Linux), it is $HOME/ndb-tls. This can be overridden by compiling NDB Cluster using -DWITH_NDB_TLS_SEARCH_PATH. - --no-defaults

Do not read default options from any option file other than login file. - --print-defaults

Print program argument list and exit. - --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. - --tupscan

Run a tuple scan. - --usage

Display help text and exit; same as --help. - --version

Display version information and exit.