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 2020/12/08 04:54:59 UTC
[GitHub] [shardingsphere] mygitdds opened a new issue #8527: sharding-proxy performance
mygitdds opened a new issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527
Since it is the agent provided, I read the source code. When I connect to MySQL, I still use the driver provided by mysql, and the overall implementation is in Java. In this way, I / O interaction with MySQL will cause thread blocking in kernel mode, which leads to low performance. I suggest go, or vertx.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #8527: sharding-proxy performance
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527#issuecomment-741510607
@mygitdds MySQL's Vertx API, right? Yep, I like this idea! But we do not have a lot of knowledge about it, look forward to your article. :)
English communication is necessary for GitHub, but your article in Chinese is ok. Just leave its link here.
Thanks,
Trista
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] mygitdds commented on issue #8527: sharding-proxy performance
Posted by GitBox <gi...@apache.org>.
mygitdds commented on issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527#issuecomment-740679397
Tomorrow find time to write an article to explain the problem, and their own decision, how to solve 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #8527: sharding-proxy performance
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527#issuecomment-740428701
Hi @mygitdds
I see your concern, and thanks for your issue. Could you provide some links or docs to elaborate on your idea?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] mygitdds commented on issue #8527: sharding-proxy performance
Posted by GitBox <gi...@apache.org>.
mygitdds commented on issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527#issuecomment-740678050
@tristaZero Vertx's performance is comparable to go。Now, with the improvement of technology, we hope to do more with less resources.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #8527: sharding-proxy performance
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527#issuecomment-742280291
Hi @mygitdds
Thanks for sharing. Actually, I want to know more about MySQL VertX, since this issue is to discuss how to improve the performance of ShardingProxy by VertX, doesn't it? That will be great If you can also share some of your thoughts concerning ShardingProxy and MySQL vertx.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] mygitdds commented on issue #8527: sharding-proxy performance
Posted by GitBox <gi...@apache.org>.
mygitdds commented on issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527#issuecomment-740677037
When sharding proxy calls mysql, the corresponding time of MySQL will be blocked. In Java, the thread model is that a user thread corresponds to a kernel thread, so the concurrency is high. If more threads are blocked, the effective utilization rate of CPU will be very low. If vertx is used, MySQL asynchronous driver will be used, and the performance will be many orders of magnitude higher For an introduction to vertx, you can go to Google for some information. I suggest that it is important to improve the performance of sharding proxy proxy layer
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] mygitdds commented on issue #8527: sharding-proxy performance
Posted by GitBox <gi...@apache.org>.
mygitdds commented on issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527#issuecomment-741538034
https://blog.csdn.net/weixin_35997672/article/details/110920659
@tristaZero
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] mygitdds commented on issue #8527: sharding-proxy performance
Posted by GitBox <gi...@apache.org>.
mygitdds commented on issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527#issuecomment-740378439
There is also an asynchronous driver for MySQL on vertx
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] mygitdds commented on issue #8527: sharding-proxy performance
Posted by GitBox <gi...@apache.org>.
mygitdds commented on issue #8527:
URL: https://github.com/apache/shardingsphere/issues/8527#issuecomment-741533574
https://blog.csdn.net/weixin_35997672/article/details/110920396
@tristaZero
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org