List:Internals« Previous MessageNext Message »
From:Zardosht Kasheff Date:July 22 2010 2:15pm
Subject:index creation and concurrent reads
View as plain text  
Hello all,

About a year and a half ago, I filed the following bug:
http://bugs.mysql.com/bug.php?id=42230

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.

Thanks
-Zardosht
Thread
index creation and concurrent readsZardosht Kasheff22 Jul