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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
