SHOW GLOBAL VARIABLES LIKE 'local_infile';
SET GLOBAL local_infile = 'ON';
SHOW GLOBAL VARIABLES LIKE 'local_infile';

load data local infile '.txt' into table TABLENAME fields terminated by '-';

set sql_log_bin=0;
set unique_checks = 0;
set foreign_key_checks = 0;
set autocommit = 0;
LOAD DATA local INFILE '.txt' INTO TABLE TABLENAME;

SET UNIQUE_CHECKS = 1;
SET FOREIGN_KEY_CHECKS = 1;
COMMIT;

SET GLOBAL local_infile = 'ON';
SHOW GLOBAL VARIABLES LIKE 'local_infile';

alter table test1 add index(id);

mysql -u root -p --local-infile

sudo mysql –local-infile=1 -u root -p

sudo du -h /var/lib/mysql
sudo sh -c 'echo 3 > /proc/sys/vm/drop_caches'

export HISTTIMEFORMAT="%F %T "

nohup ./frpc -c ./frpc.ini &