From: Zardosht Kasheff Date: July 22 2010 2:15pm Subject: index creation and concurrent reads List-Archive: http://lists.mysql.com/internals/37993 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 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