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/06/28 07:50:17 UTC
[GitHub] [shardingsphere] boot-vue opened a new issue, #18653: sharding-jdbc 5.1.2 startup very slow
boot-vue opened a new issue, #18653:
URL: https://github.com/apache/shardingsphere/issues/18653
`sharding-jdbc` : `5.1.2`
```xml
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.1.2</version>
</dependency>
```
`tables` : `200+`
same config, with version `5.1.0` , application startup very fast
change to version `5.1.2` , application start very slow......
--
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] terrymanu commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1175815636
> @terrymanu After I checked locally, I noticed that `spring.shardingsphere.rules` of ShardingSphere 5.1.2 does not have a similar module. Is this a specific configuration of the master branch? Also refer to https://shardingsphere.apache.org/document/5.1.2/en/user-manual/shardingsphere-jdbc/spring-boot-starter/rules/ .
>
> update: Update required https://github.com/apache/shardingsphere/blob/master/shardingsphere-jdbc/shardingsphere-jdbc-spring/shardingsphere-jdbc-core-spring/shardingsphere-jdbc-core-spring-boot-starter/src/main/resources/META-INF/additional-spring-configuration-metadata.json ?
If new issue, is it better to create a new one?
--
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] boot-vue closed issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
boot-vue closed issue #18653: sharding-jdbc 5.1.2 startup very slow
URL: 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] linghengqian commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1175844846
A new SpringBoot Starter related issue is located at https://github.com/apache/shardingsphere/issues/18889 .
--
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] terrymanu commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1172476006
I just update the doc to config SQL translator:
https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/sql-translator/
https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sql-translator/
--
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 #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1169986221
- JOOQ is actually related to https://github.com/apache/shardingsphere/issues/17619 and has not been raised to a higher version because the new version of JOOQ requires a JDK baseline version of `11`.
- I looked at the https://github.com/apache/shardingsphere/pull/17655 and noticed that it was using an older version of the `3.14.x` branch.
- @boot-vue If we adjusted its `jooq.version` to `3.14.16` (in line with https://github.com/spring-projects/spring-boot/issues/31429 ), would such a workable strategy in the `master` branch help this problem? I'm not sure how to define how fast or slow startup speed is.
--
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] newchendb commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
newchendb commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1172205402
I have the same problem. It starts slowly after upgrading from 5.1.1 to 5.1.2
--
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] boot-vue commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
boot-vue commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1170070479
![image](https://user-images.githubusercontent.com/36025992/176464716-a6217427-3ce4-47dc-96d5-c8a93d3ddc02.png)
--
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] terrymanu commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1175813614
@zoujianchao Hi, could you have a look for spring boot starter?
--
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] boot-vue commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
boot-vue commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1170066647
yes , version is `3.14.16` , I don't know why it becomes `3.12.3` , didn't find any conflict 😂😂😂
exclude `3.12.3` and add `3.14.16` , it still slow
`200+` tables, application start cost about ` 197.448 seconds`
---
previous change to version `3.17.1` , I still use `jdk 1.8` and application start cost about `61.109 seconds`
--
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] liuwenliang0632 commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
liuwenliang0632 commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1186820068
@boot-vue do u reslove the promblem?
--
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] boot-vue commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
boot-vue commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1188562962
> A new SpringBoot Starter related issue is located at #18889 .
🎃🎃
--
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 #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1170085980
> previous change to version 3.17.1 , I still use jdk 1.8 and application start cost about 61.109 seconds
- This is logically problematic because the minimum JDK baseline version for JOOQ 3.17.x is `17`, which is in https://blog.jooq.org/3-17-0-release-with-computed-columns-audit-columns-pattern-matching-reactive-transactions-and-kotlin-coroutine-support/ 's blog has been explained.
- ShardingSphere's own SQL dialect translation module I remember was not finished in ShardingSphere `5.1.2`, so the default implementation of SQL dialect translation SPI is JOOQ, which is a really tricky problem. 🌝🌝 If there is a self-implement, it should actually be able to replace the default SPI implementation.
- Or, add a switch within the Config configuration file to this module? Similar to `sql-translator-enabled`. But this module is part of the `database gateway`, and I'm not sure how to change it.
--
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 #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1174577884
@terrymanu After I checked locally, I noticed that `spring.shardingsphere.rules` of ShardingSphere 5.1.2 does not have a similar module. Is this a specific configuration of the master branch? Also refer to https://shardingsphere.apache.org/document/5.1.2/en/user-manual/shardingsphere-jdbc/spring-boot-starter/rules/ .
--
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] terrymanu commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1172415896
It looks like JooQ problem. I'd like to resolve this problem.
I just remove JooQ from default translator.
--
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] boot-vue commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
boot-vue commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1169471591
> What is your configuration and database type?
`mysql 8`
```yml
spring:
shardingsphere:
datasource:
names: node1,node2
node1:
type: com.zaxxer.hikari.HikariDataSource
jdbc-url: jdbc:mysql://xxxxxxx:3307/oooo?characterEncoding=utf8&useSSL=false&autoReconnect=true&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
username: root
password: vvvv
driver-class-name: com.mysql.cj.jdbc.Driver
hikari:
pool-name: ccc1
maximum-pool-size: 25
max-lifetime: 900000
validation-timeout: 2000
idle-timeout: 60000
minimum-idle: 15
node2:
type: com.zaxxer.hikari.HikariDataSource
jdbc-url: jdbc:mysql://oooooo:3308/oooo?characterEncoding=utf8&useSSL=false&autoReconnect=true&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
username: root
password: cccccc
driver-class-name: com.mysql.cj.jdbc.Driver
hikari:
pool-name: vvvvv2
maximum-pool-size: 25
max-lifetime: 900000
validation-timeout: 2000
idle-timeout: 60000
minimum-idle: 15
rules:
readwrite-splitting:
data-sources:
oooo:
type: Static
props:
write-data-source-name: node1
read-data-source-names: node2
load-balancer-name: random
load-balancers:
random:
type: RANDOM
```
--
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] boot-vue commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
boot-vue commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1169962764
> What if you could exclude JOOQ or specify a later version of JOOQ under JDK11+? New perspectives from #18691 .
upgrade jooq version from `3.12.3` to `3.17.1` ✔
or
exclude jooq dependence , start application both perform well ✔
don't know if there are other effects @linghengqian
--
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 #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1169766316
What if you could exclude JOOQ or specify a later version of JOOQ under JDK11+? New perspectives from https://github.com/apache/shardingsphere/issues/18691 .
--
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] shanrenxj commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
shanrenxj commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1168367360
yes, rolling back to 5.1.1 is very fast
--
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] terrymanu commented on issue #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1168793947
What is your configuration and database type?
--
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 #18653: sharding-jdbc 5.1.2 startup very slow
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #18653:
URL: https://github.com/apache/shardingsphere/issues/18653#issuecomment-1188522670
At the heart of this issue is actually a documentation issue, and I think this issue can 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