CREATE INDEX is very slow
Posted by:
Sal Young
Date: June 17, 2005 01:58PM
Can someone tell me why it takes 28 1/2 minutes to create a one column index on a MyIsam table with 9.5 million rows? Or is this normal.
Would you need to see my server variables in order to help me out with this question? I'm currently running MySQL 5.0.6 on WindowsXP Professional on a Pentium 4 2.8Ghz with 512MB of RAM.
Subject
Views
Written By
Posted
CREATE INDEX is very slow
4932
June 17, 2005 01:58PM
3594
June 17, 2005 02:17PM
3631
June 20, 2005 07:51AM
3435
June 20, 2005 07:57AM
3516
June 20, 2005 08:19AM
10481
June 20, 2005 12:38PM
4226
June 20, 2005 04:22PM
3970
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.