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:42:03 UTC
[GitHub] [shardingsphere] Qumans opened a new issue, #15543: Sharding-JDBC 5.1.0 startup time is too long
Qumans opened a new issue, #15543:
URL: https://github.com/apache/shardingsphere/issues/15543
### Which version of ShardingSphere did you use?
5.1.0
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
Does not take up too much startup time
### Actual behavior
Loading metadata consumes a lot of time
### Reason analyze (If you can)
The amount of metadata is too large, there are about 400,000 pieces, and it is increasing every day,v5.1.0 can only solve the immediate problem, there will still be problems in the future
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
datasource:
ds-0:
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
url:
username:
password:
maxWait: 60000
maxActive: 1000
maxIdle: 20
initialSize: 20
removeAbandoned: true
validationQuery: SELECT 1
testOnBorrow: false
testOnReturn: false
testWhileIdle: true
names: ds-0
rules:
sharding:
tables:
prod_gray_cloth_inventory:
actualDataNodes: ds-0.table_$->{0..31}
keyGenerateStrategy:
column: id
props:
worker:
id: 100
keyGeneratorName: SNOWFLAKE
tableStrategy:
standard:
shardingAlgorithmName: inventoryalg
shardingColumn:
sharding-algorithms:
inventoryalg:
type:
props:
strategy: STANDARD
algorithmClassName:
--
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] smoothbasterd commented on issue #15543: Sharding-JDBC 5.1.0 startup time is too long
Posted by "smoothbasterd (via GitHub)" <gi...@apache.org>.
smoothbasterd commented on issue #15543:
URL: https://github.com/apache/shardingsphere/issues/15543#issuecomment-1689310076
I use the 5.4.0,start up time takes ten minutes long.Is my meta data too large?Which meta data too large may take this situation.
--
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] systemview2018 commented on issue #15543: Sharding-JDBC 5.1.0 startup time is too long
Posted by GitBox <gi...@apache.org>.
systemview2018 commented on issue #15543:
URL: https://github.com/apache/shardingsphere/issues/15543#issuecomment-1220454590
any update on this issue?
--
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 #15543: Sharding-JDBC 5.1.0 startup time is too long
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15543:
URL: https://github.com/apache/shardingsphere/issues/15543#issuecomment-1220477571
@systemview2018 Can you try the latest version?
--
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 #15543: Sharding-JDBC 5.1.0 startup time is too long
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #15543:
URL: https://github.com/apache/shardingsphere/issues/15543#issuecomment-1272350348
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
Re: [I] Sharding-JDBC 5.1.0 startup time is too long [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #15543:
URL: https://github.com/apache/shardingsphere/issues/15543#issuecomment-2026579107
Please try the latest 5.4.1, this problem has been optimized.
--
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
Re: [I] Sharding-JDBC 5.1.0 startup time is too long [shardingsphere]
Posted by "jonaskahn (via GitHub)" <gi...@apache.org>.
jonaskahn commented on issue #15543:
URL: https://github.com/apache/shardingsphere/issues/15543#issuecomment-2026570480
This issue should be considered due performance enhancing.
--
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] closed issue #15543: Sharding-JDBC 5.1.0 startup time is too long
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #15543: Sharding-JDBC 5.1.0 startup time is too long
URL: https://github.com/apache/shardingsphere/issues/15543
--
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
Re: [I] Sharding-JDBC 5.1.0 startup time is too long [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #15543:
URL: https://github.com/apache/shardingsphere/issues/15543#issuecomment-2026021375
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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