java - MySQL批量插入插入速度非常慢

Question

try (BufferedReader br = new BufferedReader(new FileReader("LoadData.txt"))){
        final Connection connection = DriverManager.getConnection("jdbc:mysql://ipAddress:port/database?user=username&password=password&useServerPrepStmts=false&rewriteBatchedStatements=true");
        String sCurrentLine;
        final PreparedStatement ps = connection.prepareStatement("insert ignore into emails (email) value (?)");
        int count = 0;
        final int batchSize = 1000;
        while ((sCurrentLine = br.readLine()) != null) {
            ps.setString(1, sCurrentLine);
            ps.addBatch();
            if(++count % batchSize == 0) {
                ps.executeBatch();
            }
        }
        ps.executeBatch();
        ps.close();
        connection.close();
    } catch (final IOException e) {
        e.printStackTrace();
}

即使使用上面的代码，批量插入也非常慢，每 1000 行需要几分钟。有谁知道出了什么问题吗？

Answer 1

发布答案，以防将来给其他人带来麻烦:

我的 SQL 查询包含关键字“value”。关键字必须是“值”才能使批量插入起作用。