MySQLデータベースで数百万件のデータを10秒間で挿入

[root@hailiang 2.6.27.5-117.fc10.i686]# make menuconfig
scripts/kconfig/mconf arch/x86/Kconfig
# make menuconfig
# configuration written to .config
# configuration written to .config

*** End of Linux kernel configuration.
*** Execute 'make' to build the kernel or try 'make help'.

[root@hailiang 2.6.27.5-117.fc10.i686]# make 
scripts/kconfig/conf -s arch/x86/Kconfig
  CHK include/linux/version.h
  CHK include/linux/utsrelease.h
make[1]: *** No rule to make target `missing-syscalls'.  Stop.
make: *** [prepare0] Error 2

/* Because the database is incredibly fast, the single throughput is very high and the execution is very efficient.
    addBatch() loads a number of sql statements together and sends them to the database for execution one at a time, which takes a very short time to execute
    while preparedStatement.executeUpdate() is sent to the database one by one for execution time is consumed in the database connection transfer *public static void main(String[] args) {
    long start = System.currentTimeMillis(); // Get the current time of the system, before the method begins to execute the record
    Connection conn = BaseDao.getConn(); // call the static tool class just written to get the connection to the database object
    String sql = "insert into mymilliontest values(null,? ,? ,? ,NOW())"; // the sql statement to be executed
    PreparedStatement ps = null;
    try {
        ps = conn.prepareStatement(sql); // get PreparedStatement object
        // keep generating sql
        for (int i = 0; i < 1000000; i++) {
            ps.setString(1, Math.ceil(Math.random() * 1000000) + "");
            ps.setString(2, Math.ceil(Math.random() * 1000000) + "");
            ps.setString(3, UUID.randomUUID().toString()); // UUID This class is used to generate a random string that will not be repeated
            ps.addBatch(); // Add a set of parameters to the batch command of this PreparedStatement object.
        }
        int[] ints = ps.executeBatch(); // submits a batch of commands to the database for execution and returns an array of update counts if all commands are executed successfully.
        // If the length of the array is not 0, then the sql statement is executed successfully, i.e. millions of data are added successfully!
        if (ints.length > 0) {
            System.out.println("One million pieces of data have been successfully added! ");
        "); }
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    } finally {
        BaseDao.closeAll(conn, ps); // call the static tool class just written to release resources
    }
    long end = System.currentTimeMillis(); // get the system time again
    System.out.println("duration:" + (end - start) / 1000 + "seconds"); // subtract the two times to be the duration of the method execution
}

<! -- mysql-connector-java dependencies used to connect to the database -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.27</version>
</dependency>