You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:31:27 UTC
[GitHub] [shardingsphere] cherrishccl opened a new issue, #20945: Startup is too slow
cherrishccl opened a new issue, #20945:
URL: https://github.com/apache/shardingsphere/issues/20945
springboot2.4.5, mybatis-plus3.4.1, shardingsphere-jdbc-core-spring-boot-starter5.1.2
单库,20 张表,其中 1 张表分表
11 代 I7, 16G 内存
未分表前启动很快,10s 左右,分表后平均时间 6 分多钟
```
spring:
shardingsphere:
datasource:
ds:
driver-class-name: com.mysql.cj.jdbc.Driver
jdbc-url: jdbc:mysql://localhost:3306/test?useSSL=false&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true&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$->{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
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #20945: Startup is too slow
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20945: Startup is too slow
URL: https://github.com/apache/shardingsphere/issues/20945
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] linghengqian commented on issue #20945: Startup is too slow
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #20945:
URL: https://github.com/apache/shardingsphere/issues/20945#issuecomment-1246185622
- I think this issue is a duplicate of https://github.com/apache/shardingsphere/issues/18653.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #20945: Startup is too slow
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #20945:
URL: https://github.com/apache/shardingsphere/issues/20945#issuecomment-1248870049
Can you translate this issue to English?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] guoxiaowei001 commented on issue #20945: Startup is too slow
Posted by GitBox <gi...@apache.org>.
guoxiaowei001 commented on issue #20945:
URL: https://github.com/apache/shardingsphere/issues/20945#issuecomment-1244837600
分片键使用了吗
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #20945: Startup is too slow
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20945:
URL: https://github.com/apache/shardingsphere/issues/20945#issuecomment-1272348463
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN closed issue #20945: Startup is too slow
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #20945: Startup is too slow
URL: https://github.com/apache/shardingsphere/issues/20945
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #20945: Startup is too slow
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #20945:
URL: https://github.com/apache/shardingsphere/issues/20945#issuecomment-1364895238
Close due to no response.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org