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/11 06:14:09 UTC
[GitHub] [shardingsphere] wangjiihao opened a new issue, #21482: max-connections-size-per-query not work
wangjiihao opened a new issue, #21482:
URL: https://github.com/apache/shardingsphere/issues/21482
配置 max-connections-size-per-query 结果没有效果，shardingsphere运行时 还是使用的默认值1
--
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] TeslaCN closed issue #21482: max-connections-size-per-query not work
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN closed issue #21482: max-connections-size-per-query not work
URL: https://github.com/apache/shardingsphere/issues/21482
--
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] wangjiihao commented on issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274277950
@TeslaCN 您好,就是配置max-connections-size-per-query: 100的时候没生效,局部配置如下:
props:
#sql打印
sql-show: true
max-connections-size-per-query: 100
--
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] wangjiihao commented on issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274169938
用的是springbootstarter的shardingsphere5.1.1版本
--
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] wangjiihao commented on issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274437657
At present, the efficiency of some simple queries is relatively low. After tracing the source code, we can see that the union all is automatically spliced, resulting in the low efficiency of some simple queries and queries using paging plug-ins when the data volume is large
--
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 #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274316141
For English only.
--
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 #21482: max-connections-size-per-query not work
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1407266171
Hi @wangjiihao
Please try the latest ShardingSphere 5.3.1. The ShardingSphere Spring Boot Starter has been deprecated and removed since 5.3.0.
About the `union all`, please file a new 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] wangjiihao commented on issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274432077
The dependencies used are as follows:
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.1.1</version>
</dependency>
--
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] wangjiihao commented on issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274137007
--
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] wangjiihao commented on issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274447871
@TeslaCN It is suggested that the user can configure the part of adding union all .In addition, I configure this parameter in the yml file, max connections size per query, which has never been recognized
--
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] wangjiihao commented on issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274166482
# 分片的配置
rules:
sharding:
# 表的分片策略
tables:
# 逻辑表的名称
asset_terminal_basic_seq:
# 数据节点配置，采用Groovy表达式
actual-data-nodes: master.asset_terminal_basic_seq$->{0..4}
#分表策略
table-strategy:
standard:
# 分片列名称
sharding-column: id
sharding-algorithm-name: alg-hash-mod
#分片算法配置
sharding-algorithms:
# 哈希取模分片算法
alg-hash-mod:
# 分片算法类型
type: HASH_MOD
# 分片算法属性配置
props:
sharding-count: '5'
--
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] wangjiihao commented on issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274167730
sql就是一些最简单的select查询没什么特别的东西
--
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 #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274163024
Please paste your rules and SQL.
--
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] wangjiihao commented on issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao commented on issue #21482:
URL: https://github.com/apache/shardingsphere/issues/21482#issuecomment-1274431028
Hello, the max-connections-size-per-query does not take effect. The local configuration is as follows:
props:
#Sql printing
sql-show: true
max-connections-size-per-query: 100
--
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] wangjiihao closed issue #21482: max-connections-size-per-query not work
Posted by GitBox <gi...@apache.org>.
wangjiihao closed issue #21482: max-connections-size-per-query not work
URL: https://github.com/apache/shardingsphere/issues/21482
--
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