[OSM-dev] GPX Tables and InnoDB

Tom Hughes tom at compton.nu
Wed Sep 5 13:09:14 BST 2007

In message <46DE9B71.2020307 at stockill.net>
        Jon Stockill <lists at stockill.net> wrote:

> Tom Hughes wrote:
>> In message <46DE8D3B.3050102 at rjb.za.net>
>>         Ray Booysen <raybooysen at rjb.za.net> wrote:
>>> Is there any reason we don't immediately convert the gpx tables into 
>>> InnoDB to alleviate the locking issue? 
>> Well Inno tables are generally a lot slower to start with.
> The speed is pretty much identical to myiasm tables *if* (and it's a 
> pretty big if) the system it's running on has enough memory to store all 
> the indexes in RAM. There are a lot of parameters which can be tuned to 
> ensure that the right number of connections are available (and you've 
> not reserved buffers which are never used), and that the resources are 
> allocated in a way that's optimal for the system concerned. Get these 
> things wrong, and performance will suffer.

Believe me when I say that we don't have enough memory to store all
the indexes. Nor are we ever likely to have.


Tom Hughes (tom at compton.nu)

More information about the dev mailing list