MySQL Forums
Forum List  »  Performance

Re: CREATE INDEX is very slow
Posted by: Jay Pipes
Date: June 20, 2005 04:22PM

Sal,

I can sense your frustration, however, I wouldn't say that the 21 minutes is particularly horrible, particularly on a Windows XP machine (not a server) with only 512MB RAM. The memory required to sort 8.5 M unique records of a CHAR(10) field and allocate record identifiers across a b-tree is not insignificant. The MyISAM storage engine attempts to fill b-tree pages (1KB blocks) around 15/16th full, at most, so I wouldn't be surprised if what is occurring in your situation is a thrashing between the computer swapping in your virtual RAM space to make more room for the sort buffers.

Ulf makes an excellent suggestion for adjusting those buffers, however, if the memory on the machine is only 512MB, there may be little that you can do, considering Windows XP and other programs on the computer already consume ~100MB of RAM.

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
4905
June 17, 2005 01:58PM
3584
June 17, 2005 02:17PM
3622
June 20, 2005 07:51AM
3423
June 20, 2005 07:57AM
3500
June 20, 2005 08:19AM
10466
June 20, 2005 12:38PM
Re: CREATE INDEX is very slow
4207
June 20, 2005 04:22PM
3952
June 20, 2005 12:23PM


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.