Re: [Maria-discuss] 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 https://dev.mysql.com/doc/refman/5.5/en/insert-speed.html