Hi!
>>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Jeff Tanner writes:
>>
>> I running a test on mysql to test its performance of doing a bulk insert
>> into a table using LOAD DATA INFILE.
>>
>> The table is simple:
>>
>> CREAT TABLE test (
>> value CHAR(32) NOT NULL PRIMARY KEY
>> )
>>
>> The test is simple:
>> a) clear table
>> b) time performance of inserting X unique values into table from a
>> single file (each value on a new line)
>>
>> # of unique values time in seconds
>> 10 0.05
>> 100 0.05
>> 1K 0.10
>> 10K 0.75
>> 100K 10
>> 500K 125
>> 1M 500
>> 5M 55000
>>
>> My concern is the last entry of 5 million entries. Is there a mysql system
>> variable I should reset to improve performance?
>>
>> Thanks
>>
>> Jeff Tanner
>> Viathan
>> Seattle, WA
Sinisa> No, but you could crate a table without index and add primary key
Sinisa> after loading of data.
Actually MySQL is already doing this when you do LOAD DATA INFILE to
a table without any rows.
Jeff, what you can do is to start mysqld with a much bigger value for
'myisam_sort_buffer_size' and see if this helps.
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
