[OSM-dev] GPX Tables and InnoDB

Martijn van Oosterhout kleptog at gmail.com
Wed Sep 5 12:30:02 BST 2007


On 9/5/07, Ray Booysen <raybooysen at rjb.za.net> wrote:
> Hey all
>
> Is there any reason we don't immediately convert the gpx tables into
> InnoDB to alleviate the locking issue?

I think someone pointed out that in their experience the conversion
would take days, maybe weeks. And in that time it will be completely
locked (no reads or writes). I think the most promising idea was to
create a new table and copy the data over slowly. But there's no code
for that.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/




More information about the dev mailing list