Hi!
>>>>> "Sergei" == Sergei Golubchik <[EMAIL PROTECTED]> writes: <cut> Sergei> Ok, mysqlimport uses LOAD DATA INFILE. >> > Yes, but they are simply convenient shortcuts to >> > myisamchk --keys-used=0 -rq >> > You can enable/disable keys from command line in 3.23. >> >> Ok, what is the suggested usage? >> create w/ index >> disable >> load >> enable >> >> Or something else? Sergei> Just create without index, and then ALTER TABLE. Sergei> When ALTER TABLE is running check with SHOW PROCESSLIST Sergei> that it does 'repair by sorting', not 'repair with keycache' Sergei> DISABLE/ENABLE sequence is useful when one want to add data to non-empty Sergei> table. Note that if you are using LOAD DATA into an empty table, you will not get any additional speed by using ALTER TABLE to disable/enable the keys; In this case MySQL will automaticly use the same method as REPAIR TABLE or ALTER TABLE to generate the keys.. Regards, Monty --------------------------------------------------------------------- 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
