MySQL 9.0 Reference Manual Including MySQL NDB Cluster 9.0
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 -cconnection_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
Options that can be used with ndb_delete_all are shown in the following table. Additional descriptions follow the table.
| Command-Line Format | --character-sets-dir=path |
|---|
Directory containing character sets.
| Command-Line Format | --connect-retries=# |
|---|---|
| Type | Integer |
| Default Value | 12 |
| Minimum Value | 0 |
| Maximum Value | 12 |
Number of times to retry connection before giving up.
| Command-Line Format | --connect-retry-delay=# |
|---|---|
| Type | Integer |
| Default Value | 5 |
| Minimum Value | 0 |
| Maximum Value | 5 |
Number of seconds to wait between attempts to contact management server.
| Command-Line Format | --connect-string=connection_string |
|---|---|
| Type | String |
| Default Value | [none] |
Same as
--ndb-connectstring.
| Command-Line Format | --core-file |
|---|
Write core file on error; used in debugging.
--database,
-d
| Command-Line Format | --database=name |
|---|---|
| Type | String |
| Default Value | TEST_DB |
Name of the database containing the table to delete from.
| Command-Line Format | --defaults-extra-file=path |
|---|---|
| Type | String |
| Default Value | [none] |
Read given file after global files are read.
| Command-Line Format | --defaults-file=path |
|---|---|
| Type | String |
| Default Value | [none] |
Read default options from given file only.
| Command-Line Format | --defaults-group-suffix=string |
|---|---|
| Type | String |
| Default Value | [none] |
Also read groups with concat(group, suffix).
| Command-Line Format | --diskscan |
|---|
Run a disk scan.
| Command-Line Format | --help |
|---|
Display help text and exit.
| Command-Line Format | --login-path=path |
|---|---|
| Type | String |
| Default Value | [none] |
Read given path from login file.
| Command-Line Format | --no-login-paths |
|---|
Skips reading options from the login path file.
| Command-Line Format | --ndb-connectstring=connection_string |
|---|---|
| Type | String |
| Default Value | [none] |
Set connection string for connecting to
ndb_mgmd. Syntax:
[nodeid=.
Overrides entries in id;][host=]hostname[:port]NDB_CONNECTSTRING
and my.cnf.
| Command-Line Format | --ndb-mgm-tls=level |
|---|---|
| Type | Enumeration |
| Default Value | relaxed |
| Valid Values |
|
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.
| Command-Line Format | --ndb-mgmd-host=connection_string |
|---|---|
| Type | String |
| Default Value | [none] |
Same as
--ndb-connectstring.
| Command-Line Format | --ndb-nodeid=# |
|---|---|
| Type | Integer |
| Default Value | [none] |
Set node ID for this node, overriding any ID set by
--ndb-connectstring.
--ndb-optimized-node-selection
| Command-Line Format | --ndb-optimized-node-selection |
|---|
Enable optimizations for selection of nodes for
transactions. Enabled by default; use
--skip-ndb-optimized-node-selection to
disable.
| Command-Line Format | --ndb-tls-search-path=list |
|---|---|
| Type | Path name |
| Default Value (Unix) | $HOME/ndb-tls |
| Default Value (Windows) | $HOMEDIR/ndb-tls |
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.
| Command-Line Format | --no-defaults |
|---|
Do not read default options from any option file other than login file.
| Command-Line Format | --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.
With very large tables, using this option may cause the number of operations available to the cluster to be exceeded.
Run a tuple scan.
| Command-Line Format | --usage |
|---|
Display help text and exit; same as
--help.
| Command-Line Format | --version |
|---|
Display version information and exit.