Hi Before creating the index. set this at you mysql prompt.
set sort_buffer_size=100000000; This will enable ordering of index happen in the memory and index creation will be faster. regards anandkl On 8/11/07, Mike Zupan <[EMAIL PROTECTED]> wrote: > > Yes it will take a long time depending on the size of the index also > > On 8/10/07, x x <[EMAIL PROTECTED]> wrote: > > > > I'm attempting to add an index to a table with 70 > > million rows. > > > > DB server running on a reasonably fast Intel Mac on a > > relatively slow drive. > > > > Should this take hours to complete ? > > > > So far it's taken 5 hours and counting. I'm afraid > > it's going to destroy my drive ! > > > > > > > > > > > ____________________________________________________________________________________ > > Need a vacation? Get great deals > > to amazing places on Yahoo! Travel. > > http://travel.yahoo.com/ > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > >
