How to load large files safely into InnoDB with LOAD DATA INFILE
Заливаем сотни гигов в базу именно так. Не забудьте настроить конфиги, чтобы кодировка текста не полетела
JamES
10 years ago
while [ -e /tmp/my-fifo ]; do
time mysql -e "set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile '/tmp/my-fifo' into table load_test fields terminated by '\t' lines terminated by '\n' (col1, col2);"
sleep 1;
done
Ctrl + Enter
Recommendations
Sticker Actions
-
reacted like
26th Sep
-
reacted like
25th Sep
-
left comment to sticker
25th Sep
JamES
10 years agopt-fifo-split infile.txt --fifo /tmp/my-fifo --lines 1000000