ndb_drop_index drops the specified index from
an NDB
table. It is
recommended that you use this utility only as an example for
writing NDB API applications—see the Warning
later in this section for details.
Usage
ndb_drop_index -c connection_string table_name index -d db_name
The statement shown above drops the index named
index
from the
table
in the
database
.
Options that can be used with ndb_drop_index are shown in the following table. Additional descriptions follow the table.
Table 5.9 Command-line options used with the program ndb_drop_index
Format | Description | Added, Deprecated, or Removed |
---|---|---|
Directory containing character sets | (Supported in all NDB releases based on MySQL 5.7) |
|
Number of times to retry connection before giving up | (Supported in all NDB releases based on MySQL 5.7) |
|
Number of seconds to wait between attempts to contact management server | (Supported in all NDB releases based on MySQL 5.7) |
|
Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) |
|
Write core file on error; used in debugging | (Supported in all NDB releases based on MySQL 5.7) |
|
|
Name of database in which table is found | (Supported in all NDB releases based on MySQL 5.7) |
Read given file after global files are read | (Supported in all NDB releases based on MySQL 5.7) |
|
Read default options from given file only | (Supported in all NDB releases based on MySQL 5.7) |
|
Also read groups with concat(group, suffix) | (Supported in all NDB releases based on MySQL 5.7) |
|
Display help text and exit | (Supported in all NDB releases based on MySQL 5.7) |
|
Read given path from login file | (Supported in all NDB releases based on MySQL 5.7) |
|
Set connect string for connecting to ndb_mgmd. Syntax: "[nodeid=id;][host=]hostname[:port]". Overrides entries in NDB_CONNECTSTRING and my.cnf | (Supported in all NDB releases based on MySQL 5.7) |
|
Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) |
|
Set node ID for this node, overriding any ID set by --ndb-connectstring | (Supported in all NDB releases based on MySQL 5.7) |
|
Enable optimizations for selection of nodes for transactions. Enabled by default; use --skip-ndb-optimized-node-selection to disable | (Supported in all NDB releases based on MySQL 5.7) |
|
Do not read default options from any option file other than login file | (Supported in all NDB releases based on MySQL 5.7) |
|
Print program argument list and exit | (Supported in all NDB releases based on MySQL 5.7) |
|
Display help text and exit; same as --help | (Supported in all NDB releases based on MySQL 5.7) |
|
Display version information and exit | (Supported in all NDB releases based on MySQL 5.7) |
-
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.
-
Command-Line Format --database=name
Type String Default Value TEST_DB
Name of the database in which the table resides.
-
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 --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 --ndb-connectstring=connection_string
Type String Default Value [none]
Set connect string for connecting to ndb_mgmd. Syntax: "[nodeid=id;][host=]hostname[:port]". Overrides entries in NDB_CONNECTSTRING and my.cnf.
-
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 --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.
-
Command-Line Format --usage
Display help text and exit; same as
--help
. -
Command-Line Format --version
Display version information and exit.
Operations performed on Cluster table indexes using the NDB API are not visible to MySQL and make the table unusable by a MySQL server. If you use this program to drop an index, then try to access the table from an SQL node, an error results, as shown here:
$> ./ndb_drop_index -c localhost dogs ix -d ctest1
Dropping index dogs/idx...OK
NDBT_ProgramExit: 0 - OK
$> ./mysql -u jon -p ctest1
Enter password: *******
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.7.44-ndb-7.5.35
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW TABLES;
+------------------+
| Tables_in_ctest1 |
+------------------+
| a |
| bt1 |
| bt2 |
| dogs |
| employees |
| fish |
+------------------+
6 rows in set (0.00 sec)
mysql> SELECT * FROM dogs;
ERROR 1296 (HY000): Got error 4243 'Index not found' from NDBCLUSTER
In such a case, your only option for making
the table available to MySQL again is to drop the table and
re-create it. You can use either the SQL
statementDROP TABLE
or the
ndb_drop_table utility (see
Section 5.12, “ndb_drop_table — Drop an NDB Table”) to drop
the table.