[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