Hi!
On Aug 30, Mark kirkwood wrote:
> Dear List,
>
> I then LOAD 3000000 rows into it ( about 350Mb)
> This takes about 2m30s on my ( fairly old ) hardware ( I think this is quite
> fast ).
>
> CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
>
> Which unfortunatly takes about 20m ( which I think is a bit slow )
>
> any suggestions ? ( as I would love to create indexes faster ! )
I doubt you can do it much faster, but here're some hints:
Be sure that "SHOW PROCESSLIST" during index creation
shows "repair by sort" not "repair with keycache".
Increase myisam_max_sort_file_size otherwise.
The most important parameter for "repair by sort" is
myisam_sort_buffer_size. The more, the better.
Most of other variables don't matter here.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
