You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "dobet (via GitHub)" <gi...@apache.org> on 2024/10/28 12:16:04 UTC
[I] The TPS (Transactions Per Second) of the proxy has decreased by half. [shardingsphere]
dobet opened a new issue, #33443:
URL: https://github.com/apache/shardingsphere/issues/33443
## Question
**For English only**, other languages will not accept.
Before asking a question, make sure you have:
- Googled your question.
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
use proxy 5.5.0 add a new module.
test
sysbench --> proxy --> mysql
sysbench --> mysql
TPS，QPS decreased by half.
place help me see why ?
this is firegrpah, most in
my module only litte
this is global.yaml
```
props:
system-log-level: INFO
max-connections-size-per-query: 5
kernel-executor-size: 16 # Infinite by default.
proxy-frontend-flush-threshold: 128 # The default value is 128.
# sql-show is the same as props in logger ShardingSphere-SQL, and its priority is lower than logging rule
sql-show: false
check-table-metadata-enabled: false
# Proxy backend query fetch size. A larger value may increase the memory usage of ShardingSphere Proxy.
# The default value is -1, which means set the minimum value for different JDBC drivers.
proxy-backend-query-fetch-size: -1
proxy-frontend-executor-size: 0 # Proxy frontend executor size. The default value is 0, which means let Netty decide.
proxy-frontend-max-connections: 0 # Less than or equal to 0 means no limitation.
proxy-default-port: 3307 # Proxy default port.
proxy-netty-backlog: 1024 # Proxy netty backlog.
```
this is config.yaml datasources config
```
connectionTimeoutMilliseconds: "30000"
idleTimeoutMilliseconds: "60000"
maxLifetimeMilliseconds: "1800000"
maxPoolSize: 1000
minPoolSize: 1000
```
--
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
Re: [I] The TPS (Transactions Per Second) of the proxy has decreased by half. [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #33443:
URL: https://github.com/apache/shardingsphere/issues/33443#issuecomment-2470698194
Can you find which specific method is slow, and whether the slowdown is due to the method itself being slow or due to lots of invocations?
--
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] The TPS (Transactions Per Second) of the proxy has decreased by half. [shardingsphere]
Posted by "dobet (via GitHub)" <gi...@apache.org>.
dobet commented on issue #33443:
URL: https://github.com/apache/shardingsphere/issues/33443#issuecomment-2469756729
I test single table ,readwrite_splitting, and sharding feature. From the result that single only reduce %2, but other reduce 50%. I want to known why ? but I don't how to do
--
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] The TPS (Transactions Per Second) of the proxy has decreased by half. [shardingsphere]
Posted by "dobet (via GitHub)" <gi...@apache.org>.
dobet commented on issue #33443:
URL: https://github.com/apache/shardingsphere/issues/33443#issuecomment-2469756459
> 我相信这不是一个简单的问题。性能问题通常涉及一长串需要调查的问题。很抱歉，但根据您的描述，我无法提供相应的帮助。
>
> 如果需要进一步的帮助，您能否提供额外的分析结论以供讨论和参考？
I test single table ,readwrite_splitting, and sharding feature. From the result that single only reduce %2, but other reduce 50%. I want to known why ? but I don't how to do
--
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] The TPS (Transactions Per Second) of the proxy has decreased by half. [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #33443: The TPS (Transactions Per Second) of the proxy has decreased by half.
URL: https://github.com/apache/shardingsphere/issues/33443
--
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] The TPS (Transactions Per Second) of the proxy has decreased by half. [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #33443:
URL: https://github.com/apache/shardingsphere/issues/33443#issuecomment-2486645191
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
Re: [I] The TPS (Transactions Per Second) of the proxy has decreased by half. [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #33443:
URL: https://github.com/apache/shardingsphere/issues/33443#issuecomment-2466237401
I believe this is not a simple issue.
Performance issue often involves a long list of issues that need to be investigated.
I'm sorry, but based on your description, I am unable to provide the corresponding help.
If further assistance is needed, could you please provide additional analysis conclusions for discussion and reference?
--
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