← Back to team overview

maria-discuss team mailing list archive

Re: Very slow insert with load data infile


Am 10.02.2014 13:45, schrieb Pierre:
> Mariadb is getting slower and slower when I'm inserting a massive amout of data. I'm trying to insert 166 507 066
> rows (12go) using load data infile '' into an empty table. I splitted my file in 13 parts of the same size because
> it was too long to insert in one shot. When I inserted more than 100M rows, it starts to be extremely slow.

he reason are the permamently updated keys
in general for large inserts on a new table

  UNIQUE KEY `p1` (`p1`),
  UNIQUE KEY `p2` (`p2`),

* remove keyes
* insert data
* add kyes


Attachment: signature.asc
Description: OpenPGP digital signature

Follow ups