You can also set the bulk_insert_buffer_size=, based
on available RAM.
This would improve bulk insert on myisam tables.
regards
anandkl
On 7/26/08, mos <[EMAIL PROTECTED]> wrote:
>
> At 06:46 PM 7/25/2008, you wrote:
>
>> List,
>>
>> I am bulk inserting a huge amount of data into a MyISAM table
At 06:46 PM 7/25/2008, you wrote:
List,
I am bulk inserting a huge amount of data into a MyISAM table (a
wikipedia page dump).
Before I issued SOURCE filename.sql; I did an ALTER TABLE page DISABLE
KEYS; LOCK TABLES page WRITE;
The dump consists of about 1,200 bulk INSERT statements with roughly
