Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The TPS (Transactions Per Second) of the proxy has decreased by half. #33443

Open
dobet opened this issue Oct 28, 2024 · 0 comments
Open

The TPS (Transactions Per Second) of the proxy has decreased by half. #33443

dobet opened this issue Oct 28, 2024 · 0 comments

Comments

@dobet
Copy link

dobet commented Oct 28, 2024

Question

For English only, other languages will not accept.

Before asking a question, make sure you have:

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
image

my module only litte
image

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant