Hi!
>>>>> "Ramon" == Ramon Arias <[EMAIL PROTECTED]> writes: <cut> Ramon> I haven't done the big file yet... I did a smaller one that was 50 gigs, and Ramon> it loaded fine after a few hours. (about 3) in a pc with tons of ram and Ramon> scsi stripped drives. However each index take about 3-5 hours to create. For Ramon> some reason it seems faster to add the indexes after importing the data. I Ramon> don't understand why MySQL wants to copy the entire database over every time Ramon> I add an index... It seems to me that it spends most of the time and Ramon> resources coping the file over and relatively little processing time Ramon> creating the actual index. Hmmm... I wonder whether there is a to streamline Ramon> this process. The ALTER TABLE in MySQL is very flexible as it has a lot of non-standard but useful options. One drawback is that currently it's always doing a total reconstructions of the data and index. We plan to fix this in 4.1 (Maybe earlier if someone would like to sponsor this project). In other words, if you plan to create a lot of INDEX, you should do this with a single ALTER TABLE command. If you do a LOAD DATA INFILE into an empty file, MySQL will delay not unique index creation until all data is loaded. To get more speed for index creation, you can set the myisam_sort_buffer_size variable to a high value. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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
