lundi 1 décembre 2014

ALTER TABLE blocking in MySQL 5.6


I have a question with a MySQL 5.6 master-slave setup. If I were to modify the master's schema with an ALTER TABLE SQL query, then when the slave tries to execute that ALTER TABLE statement too, would it just block all reads to just that specific table until that query finishes executing? I assume for sure that not all tables would get blocked but I am concerned if the table being ALTER-ed itself is going to get blocked.


I did some research on my question and am referring to the online ALTER TABLE operation at http://ift.tt/1vL7cPY


I have heard from others that the slave does not block reads in this case if it were running 5.1 MySQL, but does it block for 5.6?


Thanks!





Aucun commentaire:

Enregistrer un commentaire