Re: Talk about graduation as TLP for Apache ShardingSphere(Incubator)

2020-01-19 Thread zhangli...@apache.org
> Got it, it means those threads are not block for our graduation, and could be done anytime. Yes -- Liang Zhang (John) Apache ShardingSphere & Dubbo Juan Pan 于2020年1月20日周一 上午10:14写道: > Got it, it means those threads are not block for our graduation, and could > be done

Re: Re: Split UI and java backend codes

2020-01-19 Thread zhangli...@apache.org
Done by issue[1]. [1] https://github.com/apache/incubator-shardingsphere/issues/4024 -- Liang Zhang (John) Apache ShardingSphere & Dubbo KimmKing 于2020年1月19日周日 下午8:45写道: > According to my test, splitting front-end and back-end project codes will > cut down half the time

Re: Re: use sharding-proxy, query is slow

2020-01-19 Thread Zhang Yonglun
Can you tell me how many hosts or how may MySQL instance there are first? I think the performance is not about the server.yaml configuration. -- Zhang Yonglun Apache ShardingSphere Daniel Yu 于2020年1月20日周一 下午12:39写道: > ok, we will checkout the env load,it may be some performance problem > >

Re: Re: use sharding-proxy, query is slow

2020-01-19 Thread Zhang Yonglun
The hostname xxx you omitted is what I want to see. Just tell me how many hosts or how may MySQL instance there are. Show me the 'load' on any host of MySQL instance when query. If a query with key costs 8s, the load will be very high. -- Zhang Yonglun Apache ShardingSphere Daniel Yu

Re: use sharding-proxy, query is slow

2020-01-19 Thread Zhang Yonglun
1. What's the cost when mysql client query database1 directly without sharding-proxy? (use member_id as where condition) 2. Is 'member_id' the primary key? 3. Please show me the config-sharding.yaml and server.yaml. -- Zhang Yonglun Apache ShardingSphere Daniel Yu 于2020年1月20日周一 上午11:17写道: >

use sharding-proxy, query is slow

2020-01-19 Thread Daniel Yu
Hi : we have a table 'member' with 160,000,000 rows , sharding key is member_id after sharding the database to 16 databases, the 'member' 's table struct is same in 16 databases, one database the 'member' table have 10,000,000 rows we query data by SQL "select * from

Re: Talk about graduation as TLP for Apache ShardingSphere(Incubator)

2020-01-19 Thread Juan Pan
Got it, it means those threads are not block for our graduation, and could be done anytime. Juan Pan (Trista) Senior DBA & PPMC of Apache ShardingSphere(Incubating) E-mail: panj...@apache.org On 01/19/2020 10:37,Sheng Wu wrote: As far as those docs and examples