关于mysql大批量数据导入相关my.cnf参数设置

//wait_timeout=2880000
//interactive_timeout = 2880000
//sql = "set interactive_timeout=24*3600";
//set max_allowed_packet = 10M
//ERROR 2006 (HY000): MySQL server has gone away
//[mysqld]
//max_allowed_packet = 16M 修改值很关键 插入1秒时间
//read_buffer_size
//read_rnd_buffer_size
//max_allowed_packet=1G
//wait_timeout = 288000
//key_buffer_size = 1024
//interactive_timeout = 288000
//show variables like ‘%timeout’;
//show variables like ‘%max_allowed_packet’;
//max_connections=800
//FLUSH TABLES;

 

注:大数据(10G以上)导入及迁移需要将要迁移数据需按业务逻辑提前生成*.txt或*.sql批量处理，单独用insert按条插入不可行.