About a year and a half ago, I filed the following bug:
In short, for storage engines that implement handler::add_index,
queries cannot be run on a table while an index is being created. This
affects the innodb plugin.
A comment at the bottom of the bug states that there is a "one line
fix". Does anyone have any ideas as to what that one line fix may be?
This bug seems important because storage engines that do NOT implement
handler::add_index do not have this problem.
|• index creation and concurrent reads||Zardosht Kasheff||22 Jul|