Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-11 Thread Zhang Yonglun
t; query cost 25s with 16databases, why? > > 发件人: Zhang Yonglun > 发送时间: 2020年6月4日 17:27 > 收件人: dev > 主题: Re: About count query in sharding-proxy 4.0.0-RC2 > > Get it. What about the cost use Proxy to route to only one database? > Actually merging just consume little t

回复: About count query in sharding-proxy 4.0.0-RC2

2020-06-11 Thread Kai Yu
st 25s with 16databases, why? 发件人: Zhang Yonglun 发送时间: 2020年6月4日 17:27 收件人: dev 主题: Re: About count query in sharding-proxy 4.0.0-RC2 Get it. What about the cost use Proxy to route to only one database? Actually merging just consume little time. -- Zhang Yonglun

Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-04 Thread Zhang Yonglun
t; db8 (5.37 sec) > > db9 (5.66 sec) > > db9 (5.75 sec) > > db10 (5.49 sec) > > db11 (5.11 sec) > > db12 (4.98 sec) > > db13 (5.72 sec) > > db14 (5.33 sec) > > db15 (5.15 sec) > ________ > 发件人: Zhang Yonglun > 发送时

回复: About count query in sharding-proxy 4.0.0-RC2

2020-06-04 Thread Kai Yu
.03 sec) > db8 (5.37 sec) > db9 (5.66 sec) > db9 (5.75 sec) > db10 (5.49 sec) > db11 (5.11 sec) > db12 (4.98 sec) > db13 (5.72 sec) > db14 (5.33 sec) > db15 (5.15 sec) 发件人: Zhang Yonglun 发送时间: 2020年6月4日 14:03 收件人: dev 主题: Re: About count

Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-04 Thread Zhang Yonglun
unt query sql cost 25s > > I changed props ,increase to 128 or 256 ,the count query sql cost still > between 24-26s > > > Is this situation normal ? > > Is there a way to continue improve this ? thanks > ________ > 发件人: Kai Yu > 发送时间: 2020年6

Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-04 Thread Zhang Yonglun
> > Is there a way to continue improve this ? thanks > > 发件人: Kai Yu > 发送时间: 2020年6月3日 15:16 > 收件人: dev@shardingsphere.apache.org > 主题: About count query in sharding-proxy 4.0.0-RC2 > > Hi ALL : > we have a project used 16 data

回复: About count query in sharding-proxy 4.0.0-RC2

2020-06-03 Thread Kai Yu
(25s-5s)? we really want to know what the proxy do after the count query ? why cost another 20s+? thanks 发件人: Kai Yu 发送时间: 2020年6月3日 17:23 收件人: dev@shardingsphere.apache.org 主题: 回复: About count query in sharding-proxy 4.0.0-RC2 Hi: before i send last

回复: About count query in sharding-proxy 4.0.0-RC2

2020-06-03 Thread Kai Yu
24-26s Is this situation normal ? Is there a way to continue improve this ? thanks 发件人: Kai Yu 发送时间: 2020年6月3日 15:16 收件人: dev@shardingsphere.apache.org 主题: About count query in sharding-proxy 4.0.0-RC2 Hi ALL : we have a project used 16 databases (db0

Re: About count query in sharding-proxy 4.0.0-RC2

2020-06-03 Thread Zhang Yonglun
In server.yaml, followling props effect the concurrency, you can have a try. max.connections.size.per.query: 64 acceptor.size: 64 executor.size: 64 -- Zhang Yonglun Apache ShardingSphere Kai Yu 于2020年6月3日周三 下午3:16写道： > Hi ALL : > we have a project used 16 databases (db0 ...db15)，we used

About count query in sharding-proxy 4.0.0-RC2

2020-06-03 Thread Kai Yu
Hi ALL : we have a project used 16 databases (db0 ...db15)，we used sharding-proxy 4.0.0-RC2 , and config the sharding.xml like this: schemaName: ty-basic-member dataSources: db0: url: jdbc:mysql://xxx:3306/db0?useSSL=false username: root password: root