![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961654.webp)
ndb_drop_table
— Drop an NDB Table
1634
Usage
ndb_drop_index -c
connect_string
table_name
index
-d
db_name
The statement shown above drops the index named
index
from the
table
in the
database
.
The following table includes options that are specific to
ndb_drop_index
. Additional descriptions
follow the table. For options common to most MySQL Cluster programs (including
ndb_drop_index
),
see
Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL
Cluster Programs”
.
Table 17.16.
ndb_drop_index
Options and Variables: MySQL 5.0
Format
Description
Added / Removed
--database=dbname
,
-d
Name of the database in which the
table is found
All MySQL 5.0
based releases
Warning
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:
shell>
./ndb_drop_index -c localhost dogs ix -d ctest1
Dropping index dogs/idx...OK
NDBT_ProgramExit: 0 - OK
shell>
./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.0.96
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 statement
DROP TABLE
or the
ndb_drop_table
utility (see
Section 17.4.9, “
ndb_drop_table
— Drop an NDB Table”
) to drop the table.
17.4.9.
ndb_drop_table
— Drop an NDB Table
ndb_drop_table
drops the specified
NDB
table. (If you try to use this on a table created with a
storage engine other than
NDB
, the attempt fails with the error
723: No such table exists
.) This
operation is extremely fast; in some cases, it can be an order of magnitude faster than using a MySQL
DROP TABLE
statement on an
NDB
table.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...