Actually, that buffer is only for sorting queries that use an ORDER BY.
Only MyISAM tables can build an index via sorting, and the
configuration parameter for that is myisam_sort_buffer_size.
If the table is InnoDB, let it complete, no matter how long it takes.
If you kill it, it will have to
Hi Before creating the index.
set this at you mysql prompt.
set sort_buffer_size=1;
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 o
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 com
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 !
___
