Re: 2 days needed to build a spatial index !
Hi,
Could you please tell what is your data size in bytes, for example MYI, MYD files before you try to add the index ?
What is your key_buffer ?
During the index build is your load CPU bound or disk bound ? Well with 4CPUs it may be hard to tell as MySQL will only use one CPU for this operation.
You could paste "vmstat 10"
Subject
Views
Written By
Posted
2062
June 27, 2005 10:21AM
Re: 2 days needed to build a spatial index !
1485
July 21, 2005 01:32PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.