maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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

https://dev.mysql.com/doc/refman/5.5/en/insert-speed.html

Attachment: signature.asc
Description: OpenPGP digital signature