Andreas,
- Original Message -
From: "Andreas Ahlenstorf" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, March 18, 2005 11:47 AM
Subject: Re: Problem: Slow "LOAD FILE" performance with innodb
Heikki Tuuri schrieb:
Creating the indexes
Heikki Tuuri schrieb:
> Creating the indexes after the import will only slow down the operation.
> MySQL recreates the whole table at CREATE INDEX.
That's new to me, but good to know (always this urban legends...).
Does that only apply to InnoDB or to MyISAM too?
Regards,
A.
--
MySQL General
ay, March 18, 2005 1:00 AM
Subject: Re: Problem: Slow "LOAD FILE" performance with innodb
My first guess is the indexes. Maybe create them after the import. It will
nonetheless take a bit of time!
--Original Message--
From: Jarle Aase
To: MySQL list
Sent: Mar 17, 2005 11:53
Jarle Aase schrieb:
> Is there a way to boost the performance? The database is idle, and while
> importing, performance is the key priority (record-locking,
> transaction-rollbacks and file-integrety/crash-recovery are not required
> until the data are imported).
- Disable the foreign key checks
My first guess is the indexes. Maybe create them after the import. It will
nonetheless take a bit of time!
--Original Message--
From: Jarle Aase
To: MySQL list
Sent: Mar 17, 2005 11:53 PM
Subject: Problem: Slow "LOAD FILE" performance with innodb
Hi list,
I'm trying to i
Hi list,
I'm trying to import some data into a MySQL database. The data-file is
5.5G, and consist of about 132 million rows. The machine is a P4 3GHz
with 1G RAM and a single 250 GB ATA-disk for data. The operating system
is Debian GNU Linux "testing" with kernel 2.6.8 with hyperthreading
support.