import java.sql.DriverManager;
import java.sql.SQLException;
* Mysql千万等级数据批量刺进
* 1）装备my.ini文件
* bulk_insert_buffer_size=120M 或许更大
* max_allowed_packet=1M
* 保存
* SHOW VARIABLES; --bulk_insert_buffer_size默许是8M，咱们要把它调成100M或百兆以上，也不要太大。
* 将以上Mysql刺进形式用java言语字符串拼接SQL办法如下
public class Main {
Connection conn;
String driver = "com.mysql.jdbc.Driver";
String user = "root";
//String sql = "insert into test values (?,?,?)";
Class.forName(driver);
stmt = (PreparedStatement) conn.prepareStatement(sql);
// ------ 5000,000条 ----------
// Sat Jul 27 16:21:13 CST 2019
/*for (int i = 10; i < 5000000; i++) {
stmt.setString(2, "test_" + i);
stmt.executeUpdate();
/* —————————————————————————— */
// Sat Jul 27 18:49:57 CST 2019
// 耗时;550秒 均匀1818条/秒
stmt.setString(1, i + "_n");
stmt.setString(3, "西城区" + i + "号路");
stmt.setString(5, "jack_" + ((i + 1)));
stmt.setString(7, (i + 2) + "_n");
stmt.setString(9, "丰台区" + (i + 2) + "号场");
}
if (stmt != null) {
}
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
A8站源码交易平台
