MySQL Forums
Forum List  »  NDB clusters

Re: Add index for mysql table with ndbcluster storage engine
Posted by: urgen sherpa
Date: June 10, 2016 05:32AM

Thank jon,

i am (ssh)logged into the sqlnode itself. I dont know why im not able to run ddl statement on database thats in to be more specific "add index to a table". when i create a new database and dump the sql from working db i can successfully create indexes.

mysql> show databases;
| Database |
| information_schema |
| prod_db |
| prod_db_test_new |

mysql> use prod_db_test_new;

mysql> alter table `sks_staff_office` add index `pid_index` (pid);
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.