[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

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/




More information about the dev mailing list