| List: | Internals | « Previous MessageNext Message » | |
| From: | Zardosht Kasheff | Date: | April 8 2011 11:36pm |
| Subject: | allowing other threads to write to a table during "create index" | ||
| View as plain text | |||
Hello all, In MySQL 5.1, a storage engine can allow other threads to write to a table while an index (via handler::add_index) is being created. To do so, one can set the lock_type to TL_WRITE_ALLOW_WRITE when handler::store_lock is called. In MySQL 5.5, this does not work, because a "metadata lock", or MDL has been added to the system. Is there any way to get this to work in MySQL 5.5? Thanks -Zardosht
| Thread | ||
|---|---|---|
| • allowing other threads to write to a table during "create index" | Zardosht Kasheff | 9 Apr |
| • Re: allowing other threads to write to a table during "createindex" | Dmitry Lenev | 11 Apr |
| • Re: allowing other threads to write to a table during "create index" | Zardosht Kasheff | 16 Apr |
