SpringBoot + Mybatis + MySQL 批量新增数据如何避免 OOM？

for (int i = 0; i < max; i += count) {
    list<integer> list1 = list.sublist(i, math.min(i + count, max));
    usermapper.insert(list1);
}

// 创建临时表
CREATE TABLE tmp_user (
    id INT NOT NULL,
    name VARCHAR(255) NOT NULL
);

// 批量插入数据到临时表
List<Integer> idList = new ArrayList<>();
List<String> nameList = new ArrayList<>();
for (User user : list) {
    idList.add(user.getId());
    nameList.add(user.getName());
}
String sql = "INSERT INTO tmp_user (id, name) VALUES (?, ?)";
jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {
    @Override
    public void setValues(PreparedStatement ps, int i) throws SQLException {
        ps.setInt(1, idList.get(i));
        ps.setString(2, nameList.get(i));
    }

    @Override
    public int getBatchSize() {
        return idList.size();
    }
});

// 将临时表数据导入目标表
sql = "INSERT INTO user (id, name) SELECT id, name FROM tmp_user";
jdbcTemplate.execute(sql);

// 删除临时表
DROP TABLE tmp_user;