<p dir="auto">springboot2.4.5, mybatis-plus3.4.1, shardingsphere-jdbc-core-spring-boot-starter5.1.2<br>
单库，20 张表，其中 1 张表分表<br>
11 代 I7， 16G 内存<br>
未分表前启动很快，10s 左右，分表后平均时间 6 分多钟</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="spring:
  shardingsphere:
    datasource:
      ds:
        driver-class-name: com.mysql.cj.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3306/test?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;autoReconnect=true&amp;zeroDateTimeBehavior=convertToNull&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=Asia/Shanghai&amp;rewriteBatchedStatements=true&amp;allowPublicKeyRetrieval=true
        password: 123456
        type: com.zaxxer.hikari.HikariDataSource
        username: root
        validation-timeout: 5000
        connection-timeout: 30000
        max-lifetime: 1800000
        maximum-pool-size: 20
        minimum-idle: 5
        idle-timeout: 600000
        auto-commit: true
        connection-test-query: SELECT 1
        pool-name: ${spring.application.name}-ds
      names: ds
    mode:
      type: Memory
    rules:
      sharding:
        key-generators:
          snowflake:
            type: SNOWFLAKE
        sharding-algorithms:
          local-date-time-inline:
            props:
              strategy: standard
              algorithmClassName: com.test.sharding.CustomLocalDateTimeStrategyShardingAlgorithm
            type: CLASS_BASED
        tables:
          test_bigdata_his:
            actual-data-nodes: ds.test_bigdata_his_202$-&gt;{201..912} # 按月分表
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
            table-strategy:
              standard:
                sharding-algorithm-name: local-date-time-inline
                sharding-column: data_time
    props:
      sql-show: true
      max:
        connections:
          size:
            per:
              query: 50"><pre class="notranslate"><code class="notranslate">spring:
  shardingsphere:
    datasource:
      ds:
        driver-class-name: com.mysql.cj.jdbc.Driver
        jdbc-url: jdbc:mysql://localhost:3306/test?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;autoReconnect=true&amp;zeroDateTimeBehavior=convertToNull&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=Asia/Shanghai&amp;rewriteBatchedStatements=true&amp;allowPublicKeyRetrieval=true
        password: 123456
        type: com.zaxxer.hikari.HikariDataSource
        username: root
        validation-timeout: 5000
        connection-timeout: 30000
        max-lifetime: 1800000
        maximum-pool-size: 20
        minimum-idle: 5
        idle-timeout: 600000
        auto-commit: true
        connection-test-query: SELECT 1
        pool-name: ${spring.application.name}-ds
      names: ds
    mode:
      type: Memory
    rules:
      sharding:
        key-generators:
          snowflake:
            type: SNOWFLAKE
        sharding-algorithms:
          local-date-time-inline:
            props:
              strategy: standard
              algorithmClassName: com.test.sharding.CustomLocalDateTimeStrategyShardingAlgorithm
            type: CLASS_BASED
        tables:
          test_bigdata_his:
            actual-data-nodes: ds.test_bigdata_his_202$-&gt;{201..912} # 按月分表
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
            table-strategy:
              standard:
                sharding-algorithm-name: local-date-time-inline
                sharding-column: data_time
    props:
      sql-show: true
      max:
        connections:
          size:
            per:
              query: 50
</code></pre></div>
<p dir="auto"><code class="notranslate">sharding-jdbc</code> : <code class="notranslate">5.1.2</code></p>
<div class="highlight highlight-text-xml notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="      &lt;dependency&gt;
            &lt;groupId&gt;org.apache.shardingsphere&lt;/groupId&gt;
            &lt;artifactId&gt;shardingsphere-jdbc-core-spring-boot-starter&lt;/artifactId&gt;
            &lt;version&gt;5.1.2&lt;/version&gt;
        &lt;/dependency&gt;"><pre class="notranslate">      &lt;<span class="pl-ent">dependency</span>&gt;
            &lt;<span class="pl-ent">groupId</span>&gt;org.apache.shardingsphere&lt;/<span class="pl-ent">groupId</span>&gt;
            &lt;<span class="pl-ent">artifactId</span>&gt;shardingsphere-jdbc-core-spring-boot-starter&lt;/<span class="pl-ent">artifactId</span>&gt;
            &lt;<span class="pl-ent">version</span>&gt;5.1.2&lt;/<span class="pl-ent">version</span>&gt;
        &lt;/<span class="pl-ent">dependency</span>&gt;</pre></div>
<p dir="auto"><code class="notranslate">tables</code> : <code class="notranslate">200+</code></p>
<p dir="auto">same config, with version <code class="notranslate">5.1.0</code> , application startup very fast</p>
<p dir="auto">change to version <code class="notranslate">5.1.2</code>  , application start very slow......</p>