0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
1 |
'\" t
|
1
by Chuck Short
Import upstream version 5.1.30 |
2 |
.\" Title: \fBndb_drop_index\fR |
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
3 |
.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author] |
0.2.4
by Norbert Tretkowski
Import upstream version 5.1.39 |
4 |
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/> |
0.2.6
by Norbert Tretkowski
Import upstream version 5.1.41 |
5 |
.\" Date: 11/04/2009 |
1
by Chuck Short
Import upstream version 5.1.30 |
6 |
.\" Manual: MySQL Database System |
7 |
.\" Source: MySQL 5.1 |
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
8 |
.\" Language: English |
1
by Chuck Short
Import upstream version 5.1.30 |
9 |
.\" |
0.2.6
by Norbert Tretkowski
Import upstream version 5.1.41 |
10 |
.TH "\FBNDB_DROP_INDEX\FR" "1" "11/04/2009" "MySQL 5\&.1" "MySQL Database System" |
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
11 |
.\" ----------------------------------------------------------------- |
12 |
.\" * set default formatting |
|
13 |
.\" ----------------------------------------------------------------- |
|
1
by Chuck Short
Import upstream version 5.1.30 |
14 |
.\" disable hyphenation |
15 |
.nh
|
|
16 |
.\" disable justification (adjust text to left margin only) |
|
17 |
.ad l |
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
18 |
.\" ----------------------------------------------------------------- |
19 |
.\" * MAIN CONTENT STARTS HERE * |
|
20 |
.\" ----------------------------------------------------------------- |
|
21 |
.\" ndb_drop_index |
|
1
by Chuck Short
Import upstream version 5.1.30 |
22 |
.SH "NAME" |
1.1.1
by Mathias Gug
Import upstream version 5.1.31 |
23 |
ndb_drop_index \- drop index from an NDB table
|
1
by Chuck Short
Import upstream version 5.1.30 |
24 |
.SH "SYNOPSIS" |
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
25 |
.HP \w'\fBndb_drop_index\ \fR\fB\fIoptions\fR\fR\ 'u |
1
by Chuck Short
Import upstream version 5.1.30 |
26 |
\fBndb_drop_index \fR\fB\fIoptions\fR\fR |
27 |
.SH "DESCRIPTION" |
|
28 |
.PP
|
|
29 |
\fBndb_drop_index\fR |
|
30 |
drops the specified index from an |
|
31 |
NDB |
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
32 |
table\&.
|
1
by Chuck Short
Import upstream version 5.1.30 |
33 |
\fIIt is recommended that you use this utility only as an example for writing NDB API applications\fR |
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
34 |
\(em see the Warning later in this section for details\&. |
1
by Chuck Short
Import upstream version 5.1.30 |
35 |
.PP
|
36 |
\fBUsage\fR: |
|
37 |
.sp
|
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
38 |
.if n \{\ |
39 |
.RS 4 |
|
40 |
.\}
|
|
1
by Chuck Short
Import upstream version 5.1.30 |
41 |
.nf
|
42 |
ndb_drop_index \-c \fIconnect_string\fR \fItable_name\fR \fIindex\fR \-d \fIdb_name\fR |
|
43 |
.fi
|
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
44 |
.if n \{\ |
1
by Chuck Short
Import upstream version 5.1.30 |
45 |
.RE
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
46 |
.\}
|
1
by Chuck Short
Import upstream version 5.1.30 |
47 |
.PP
|
48 |
The statement shown above drops the index named |
|
49 |
\fIindex\fR |
|
50 |
from the |
|
51 |
\fItable\fR |
|
52 |
in the |
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
53 |
\fIdatabase\fR\&. |
1
by Chuck Short
Import upstream version 5.1.30 |
54 |
.PP
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
55 |
\fBAdditional Options\fR: None that are specific to this application\&. |
56 |
.if n \{\ |
|
1
by Chuck Short
Import upstream version 5.1.30 |
57 |
.sp
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
58 |
.\}
|
59 |
.RS 4 |
|
1
by Chuck Short
Import upstream version 5.1.30 |
60 |
.it 1 an-trap |
61 |
.nr an-no-space-flag 1 |
|
62 |
.nr an-break-flag 1 |
|
63 |
.br
|
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
64 |
.ps +1 |
1
by Chuck Short
Import upstream version 5.1.30 |
65 |
\fBWarning\fR |
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
66 |
.ps -1 |
67 |
.br
|
|
1
by Chuck Short
Import upstream version 5.1.30 |
68 |
.PP
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
69 |
\fIOperations performed on Cluster table indexes using the NDB API are not visible to MySQL and make the table unusable by a MySQL server\fR\&. 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: |
70 |
.sp .5v |
|
71 |
.RE
|
|
1
by Chuck Short
Import upstream version 5.1.30 |
72 |
.sp
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
73 |
.if n \{\ |
74 |
.RS 4 |
|
75 |
.\}
|
|
1
by Chuck Short
Import upstream version 5.1.30 |
76 |
.nf
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
77 |
shell> \fB\&./ndb_drop_index \-c localhost dogs ix \-d ctest1\fR |
78 |
Dropping index dogs/idx\&.\&.\&.OK |
|
1
by Chuck Short
Import upstream version 5.1.30 |
79 |
NDBT_ProgramExit: 0 \- OK
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
80 |
shell> \fB\&./mysql \-u jon \-p ctest1\fR |
1
by Chuck Short
Import upstream version 5.1.30 |
81 |
Enter password: ******* |
82 |
Reading table information for completion of table and column names |
|
83 |
You can turn off this feature to get a quicker startup with \-A
|
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
84 |
Welcome to the MySQL monitor\&. Commands end with ; or \eg\&. |
85 |
Your MySQL connection id is 7 to server version: 5\&.1\&.12\-beta\-20060817 |
|
86 |
Type \'help;\' or \'\eh\' for help\&. Type \'\ec\' to clear the buffer\&. |
|
1
by Chuck Short
Import upstream version 5.1.30 |
87 |
mysql> SHOW TABLES; |
88 |
+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
|
|
89 |
| Tables_in_ctest1 | |
|
90 |
+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
|
|
91 |
| a | |
|
92 |
| bt1 | |
|
93 |
| bt2 | |
|
94 |
| dogs | |
|
95 |
| employees | |
|
96 |
| fish | |
|
97 |
+\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-+
|
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
98 |
6 rows in set (0\&.00 sec)
|
1
by Chuck Short
Import upstream version 5.1.30 |
99 |
mysql> SELECT * FROM dogs; |
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
100 |
ERROR 1296 (HY000): Got error 4243 \'Index not found\' from NDBCLUSTER |
1
by Chuck Short
Import upstream version 5.1.30 |
101 |
.fi
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
102 |
.if n \{\ |
1
by Chuck Short
Import upstream version 5.1.30 |
103 |
.RE
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
104 |
.\}
|
1
by Chuck Short
Import upstream version 5.1.30 |
105 |
.PP
|
106 |
In such a case, your |
|
107 |
\fIonly\fR |
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
108 |
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 |
1
by Chuck Short
Import upstream version 5.1.30 |
109 |
or the |
110 |
\fBndb_drop_table\fR |
|
111 |
utility (see |
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
112 |
\fBndb_drop_table\fR(1)) to drop the table\&. |
1
by Chuck Short
Import upstream version 5.1.30 |
113 |
.SH "COPYRIGHT" |
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
114 |
.br
|
1
by Chuck Short
Import upstream version 5.1.30 |
115 |
.PP
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
116 |
Copyright 2007-2008 MySQL AB, 2009 Sun Microsystems, Inc. |
1
by Chuck Short
Import upstream version 5.1.30 |
117 |
.PP
|
0.2.1
by Norbert Tretkowski
Import upstream version 5.1.34 |
118 |
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. |
1
by Chuck Short
Import upstream version 5.1.30 |
119 |
.PP
|
120 |
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. |
|
121 |
.PP
|
|
0.2.3
by Norbert Tretkowski
Import upstream version 5.1.37 |
122 |
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. |
123 |
.sp
|
|
1
by Chuck Short
Import upstream version 5.1.30 |
124 |
.SH "SEE ALSO" |
125 |
For more information, please refer to the MySQL Reference Manual, |
|
126 |
which may already be installed locally and which is also available |
|
127 |
online at http://dev.mysql.com/doc/. |
|
128 |
.SH AUTHOR |
|
0.2.2
by Christian Hammers
Import upstream version 5.1.36 |
129 |
Sun Microsystems, Inc. (http://www.mysql.com/). |