MySQL Forums
Forum List  »  Performance

Re: 2 days needed to build a spatial index !
Posted by: Peter Zaitsev
Date: July 21, 2005 01:32PM

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"

Options: ReplyQuote


Subject
Views
Written By
Posted
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.