can't alter table to create index
Posted by: Anthony Esposito
Date: March 21, 2018 12:14PM

AWS RDS MySQL 5.6.35

When attempting to create an index with the following SQL

ALTER TABLE `mytable` ADD INDEX `ix_myindex` USING BTREE(`columnID`);

the command never returns or creates the index nor gives an error.

The table in question has 6000 rows.

What could be the issue? Where can I look for error messages?

In the AWS console I have looked at the error log but it says IP address / resource not resolved. However, I do not get an error to the command-line mysql client nor via MySQL Workbench.

Options: ReplyQuote

Written By
can't alter table to create index
March 21, 2018 12:14PM

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.