Re: Add index for mysql table with ndbcluster storage engine

[urgen sherpa]

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 use..here 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