create table user
(
    id   int auto_increment
        primary key,
    name varchar(255) null,
    age  int          null
);


insert into user (age, name) values (104, 'mai4')
insert into user (age, name values (103, 'mai3')

SELECT * FROM user;

+----+------+------+
| id | name | age  |
+----+------+------+
|  1 | mai4 |  104 |
|  2 | mai3 |  103 |
+----+------+------+
2 rows in set (0,00 sec)

CREATE SEQUENCE serial START WITH 1 INCREMENT BY 10;
insert into user (age, name,id) values (104, 'mai4',nextval(serial));
insert into user (age, name,id) values (103, 'mai3',nextval(serial));

SELECT * FROM user;

+----+------+------+
| id | name | age  |
+----+------+------+
|  1 | mai4 |  104 |
| 11 | mai3 |  103 |
+----+------+------+
2 rows in set (0,00 sec)

import lombok.Data;

import javax.persistence.*;

@Entity
@Table(name = "user")
@Data
public class User {
    @Id
    @GeneratedValue(
            strategy = GenerationType.SEQUENCE,
            generator = "serial"
    )
    @SequenceGenerator(
            name = "serial",
            sequenceName = "serial",
            allocationSize = 10
    )
    private int id;

    private String name;

    private int age;

}

    @PutMapping("/multi/user")
    String insertUser() {
        List<User> savedUser = new ArrayList<>();

        for (int i =0 ; i < 5 ; i ++){
            User user = new User();
            int index = count.addAndGet(1);
            user.setName("demtv" + index);
            user.setAge(index);
            savedUser.add(user);
        }
        repository.saveAll(savedUser);
        return "done";
    }

spring:
  application:
    name: user-service
    url: jdbc:mariadb://127.0.0.1:3307/blog?characterEncoding=utf8
    driver-class-name: org.mariadb.jdbc.Driver
    username: root
    password: demtv
  jpa:
    properties:
      hibernate:
        jdbc:
             batch_size : 5
        order_inserts : true

    show-sql : true

        <!-- https://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client -->
        <dependency>
            <groupId>org.mariadb.jdbc</groupId>
            <artifactId>mariadb-java-client</artifactId>
            <version>2.7.3</version>
        </dependency>

import org.aopalliance.intercept.MethodInterceptor;
import org.aopalliance.intercept.MethodInvocation;
import org.springframework.aop.framework.ProxyFactory;
import org.springframework.beans.BeansException;
import org.springframework.beans.factory.config.BeanPostProcessor;
import org.springframework.stereotype.Component;
import org.springframework.util.ReflectionUtils;
import net.ttddyy.dsproxy.support.ProxyDataSourceBuilder;


import javax.sql.DataSource;
import java.lang.reflect.Method;

@Component
public class DatasourceProxyBeanPostProcessor implements BeanPostProcessor {

    @Override
    public Object postProcessBeforeInitialization(final Object bean, final String beanName) throws BeansException {
        return bean;
    }

    @Override
    public Object postProcessAfterInitialization(final Object bean, final String beanName) throws BeansException {
        if (bean instanceof DataSource) {
            ProxyFactory factory = new ProxyFactory(bean);
            factory.setProxyTargetClass(true);
            factory.addAdvice(new ProxyDataSourceInterceptor((DataSource) bean));
            return factory.getProxy();
        }

        return bean;
    }

    private static class ProxyDataSourceInterceptor implements MethodInterceptor {

        private final DataSource dataSource;

        public ProxyDataSourceInterceptor(final DataSource dataSource) {
            this.dataSource = ProxyDataSourceBuilder.create(dataSource).name("Batch-Insert-Logger").asJson().countQuery().logQueryToSysOut().build();
        }

        @Override
        public Object invoke(final MethodInvocation invocation) throws Throwable {
            Method proxyMethod = ReflectionUtils.findMethod(dataSource.getClass(), invocation.getMethod().getName());
            if (proxyMethod != null) {
                return proxyMethod.invoke(dataSource, invocation.getArguments());
            }
            return invocation.proceed();
        }
    }
}

Hibernate: select nextval(serial)
{"name":"Batch-Insert-Logger", "time":1, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select nextval(serial)"], "params":[[]]}
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
{"name":"Batch-Insert-Logger", "time":2, "success":true, "type":"Prepared", "batch":true, "querySize":1, "batchSize":5, "query":["insert into user (age, name, id) values (?, ?, ?)"], "params":[["1","demtv1","12"],["2","demtv2","13"],["3","demtv3","14"],["4","demtv4","15"],["5","demtv5","16"]]}

SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';
select * from mysql.general_log a  order by event_time desc;

+----------------------------+----------------------------+-----------+-----------+--------------+----------------------------------------------------------------------------------------------------------------+
| event_time                 | user_host                  | thread_id | server_id | command_type | argument                                                                                                       |
+----------------------------+----------------------------+-----------+-----------+--------------+----------------------------------------------------------------------------------------------------------------+
| 2021-07-18 08:52:07.774988 | root[root] @  [172.17.0.1] |        49 |         1 | Query        | SHOW WARNINGS                                                                                                  |
| 2021-07-18 08:52:07.773198 | root[root] @  [172.17.0.1] |        49 |         1 | Query        | SELECT @@session.tx_isolation                                                                                  |
| 2021-07-18 08:51:56.061139 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | set autocommit=1                                                                                               |
| 2021-07-18 08:51:56.057017 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | COMMIT                                                                                                         |
| 2021-07-18 08:51:56.055347 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | insert into user (age, name, id) values (5, 'demtv5', 16)                                                      |
| 2021-07-18 08:51:56.055283 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | insert into user (age, name, id) values (4, 'demtv4', 15)                                                      |
| 2021-07-18 08:51:56.055213 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | insert into user (age, name, id) values (3, 'demtv3', 14)                                                      |
| 2021-07-18 08:51:56.055135 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | insert into user (age, name, id) values (2, 'demtv2', 13)                                                      |
| 2021-07-18 08:51:56.054717 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | insert into user (age, name, id) values (1, 'demtv1', 12)                                                      |
| 2021-07-18 08:51:56.031163 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | select nextval(serial)                                                                                         |
+----------------------------+----------------------------+-----------+-----------+--------------+----------------------------------------------------------------------------------------------------------------+

select * from user;

+----+--------+------+
| id | name   | age  |
+----+--------+------+
|  1 | mai4   |  104 |
| 11 | mai3   |  103 |
| 12 | demtv1 |    1 |
| 13 | demtv2 |    2 |
| 14 | demtv3 |    3 |
| 15 | demtv4 |    4 |
| 16 | demtv5 |    5 |
+----+--------+------+

import lombok.Data;

import javax.persistence.*;

@Entity
@Table(name = "user")
@Data
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    private String name;

    private int age;

}

spring:
  application:
    name: user-service
  config:
    import : optional:configserver:http://localhost:8888/
  profiles:
    active: dev
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/blog?characterEncoding=utf8
    driver-class-name: com.mysql.jdbc.Driver
    username: demtv
    password: Anhdem96!@
  jpa:
    properties:
      hibernate:
        jdbc:
          batch_size: 5
        order_inserts : true

    show-sql : true

server:
  port: 8082

        <dependency> 
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.22</version>
        </dependency>

Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":1, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["1","demtv1"]]}
Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["2","demtv2"]]}
Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["3","demtv3"]]}
Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":1, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["4","demtv4"]]}
Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":1, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["5","demtv5"]]}

select * from user;
+----+--------+------+
| id | name   | age  |
+----+--------+------+
|  1 | mai3   |  103 |
|  2 | demtv1 |    1 |
|  3 | demtv2 |    2 |
|  4 | demtv3 |    3 |
|  5 | demtv4 |    4 |
|  6 | demtv5 |    5 |
+----+--------+------+

    @PutMapping("/multi/user")
    String insertMultiUser() {
        List<User> savedUser = new ArrayList<>();
        for (int i = 1; i < 6; i++) {
            User user = new User();
            user.setId(1000 * i);
            int index = count.addAndGet(1);
            user.setName("demtv" + index);
            user.setAge(index);
            savedUser.add(user);
        }
        repository.saveAll(savedUser);
        return "done";
    }

{"name":"Batch-Insert-Logger", "time":1, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["1000"]]}
Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["1","demtv1"]]}
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["2000"]]}
Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["2","demtv2"]]}
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["3000"]]}
Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["3","demtv3"]]}
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
{"name":"Batch-Insert-Logger", "time":1, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["4000"]]}
Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["4","demtv4"]]}
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["5000"]]}
Hibernate: insert into user (age, name) values (?, ?)
{"name":"Batch-Insert-Logger", "time":1, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["insert into user (age, name) values (?, ?)"], "params":[["5","demtv5"]]}

mysql> select * from user;
+----+--------+------+
| id | name   | age  |
+----+--------+------+
|  1 | mai3   |  103 |
|  2 | demtv1 |    1 |
|  3 | demtv2 |    2 |
|  4 | demtv3 |    3 |
|  5 | demtv4 |    4 |
|  6 | demtv5 |    5 |
|  7 | demtv1 |    1 |
|  8 | demtv2 |    2 |
|  9 | demtv3 |    3 |
| 10 | demtv4 |    4 |
| 11 | demtv5 |    5 |
+----+--------+------+
11 rows in set (0,00 sec)

import lombok.Data;

import javax.persistence.*;

@Entity
@Table(name = "user")
@Data
public class User {
    @Id
    @GeneratedValue(
            strategy = GenerationType.SEQUENCE,
            generator = "serial"
    )
    @SequenceGenerator(
            name = "serial",
            sequenceName = "serial",
            allocationSize = 10
    )
    private int id;

    private String name;

    private int age;

}


config
spring:
  application:
    name: user-service
  config:
    import : optional:configserver:http://localhost:8888/
  profiles:
    active: dev
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/blog?characterEncoding=utf8
    driver-class-name: com.mysql.jdbc.Driver
    username: demtv
    password: Anhdem96!@
  jpa:
    properties:
      hibernate:
        jdbc:
          batch_size: 5
        order_inserts : true
        ddl-auto : create
    generate-ddl : true
    show-sql : true

Hibernate: select next_val as id_val from serial for update
{"name":"Batch-Insert-Logger", "time":1, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select next_val as id_val from serial for update"], "params":[[]]}
Hibernate: update serial set next_val= ? where next_val=?
{"name":"Batch-Insert-Logger", "time":1, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["update serial set next_val= ? where next_val=?"], "params":[["11","1"]]}
Hibernate: select next_val as id_val from serial for update
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select next_val as id_val from serial for update"], "params":[[]]}
Hibernate: update serial set next_val= ? where next_val=?
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["update serial set next_val= ? where next_val=?"], "params":[["21","11"]]}
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
{"name":"Batch-Insert-Logger", "time":2, "success":true, "type":"Prepared", "batch":true, "querySize":1, "batchSize":5, "query":["insert into user (age, name, id) values (?, ?, ?)"], "params":[["1","demtv1","1"],["2","demtv2","2"],["3","demtv3","3"],["4","demtv4","4"],["5","demtv5","5"]]}

import lombok.Data;

import javax.persistence.*;

@Entity
@Table(name = "user")
@Data
public class User {
    @Id
    private int id;

    private String name;

    private int age;

}

    @PutMapping("/multi/user")
    String insertMultiUser() {
        List<User> savedUser = new ArrayList<>();
        for (int i = 1; i < 6; i++) {
            User user = new User();
            user.setId(1000 * (i + 1));
            int index = count.addAndGet(1);
            user.setName("demtv" + index);
            user.setAge(index);
            savedUser.add(user);
        }
        repository.saveAll(savedUser);
        return "done";
    }

Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["2000"]]}
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["3000"]]}
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["4000"]]}
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["5000"]]}
Hibernate: select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?
{"name":"Batch-Insert-Logger", "time":0, "success":true, "type":"Prepared", "batch":false, "querySize":1, "batchSize":0, "query":["select user0_.id as id1_0_0_, user0_.age as age2_0_0_, user0_.name as name3_0_0_ from user user0_ where user0_.id=?"], "params":[["6000"]]}
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
Hibernate: insert into user (age, name, id) values (?, ?, ?)
{"name":"Batch-Insert-Logger", "time":2, "success":true, "type":"Prepared", "batch":true, "querySize":1, "batchSize":5, "query":["insert into user (age, name, id) values (?, ?, ?)"], "params":[["1","demtv1","2000"],["2","demtv2","3000"],["3","demtv3","4000"],["4","demtv4","5000"],["5","demtv5","6000"]]}

spring:
  application:
    name: user-service
    url: jdbc:mariadb://127.0.0.1:3307/blog?characterEncoding=utf8&rewriteBatchedStatements=true
    driver-class-name: org.mariadb.jdbc.Driver
    username: root
    password: demtv
  jpa:
    properties:
      hibernate:
        jdbc:
             batch_size : 5
        order_inserts : true

    show-sql : true

select * from mysql.general_log a  order by event_time desc;

+----------------------------+----------------------------+-----------+-----------+--------------+----------------------------------------------------------------------------------------------------------------+
| event_time                 | user_host                  | thread_id | server_id | command_type | argument                                                                                                       |
+----------------------------+----------------------------+-----------+-----------+--------------+----------------------------------------------------------------------------------------------------------------+
| 2021-07-18 08:52:07.774988 | root[root] @  [172.17.0.1] |        49 |         1 | Query        | SHOW WARNINGS                                                                                                  |
| 2021-07-18 08:52:07.773198 | root[root] @  [172.17.0.1] |        49 |         1 | Query        | SELECT @@session.tx_isolation                                                                                  |
| 2021-07-18 08:51:56.061139 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | set autocommit=1                                                                                               |
| 2021-07-18 08:51:56.057017 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | COMMIT                                                                                                         |
| 2021-07-18 08:51:56.055347 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | insert into user (age, name, id) values (5, 'demtv5', 16),(4, 'demtv4', 15) ,(3, 'demtv3', 14),(2, 'demtv2', 13),(1, 'demtv1', 12)|
| 2021-07-18 08:51:56.031163 | root[root] @  [172.17.0.1] |        71 |         1 | Query        | select nextval(serial)                                                                                         |
+----------------------------+----------------------------+-----------+-----------+--------------+----------------------------------------------------------------------------------------------------------------+