Is index creating a blocking operation in Mysql Aurora 5.6

0

We need to create an index in a table which has 53mln records. We don't know how much this operation may be executed.
In our case table can't be locked because it crashes application which can not take a place.

I want to execute this SQL: CREATE INDEX test_idx ON table_name(column(1), column2);
We are using: 5.6.mysql_autora.1.23.2 version

The question is: Will this SQL blocked read&write operations?

PawelN
demandé il y a 3 ans928 vues
1 réponse
0

I did tests and I can admit that creating index doesn't block SELECT & INSERT operation.

PawelN
répondu il y a 3 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions