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 <[email protected]> 于2020年1月20日周一 上午11:17写道： > 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 member where member_id = 'abc' > " on database 1 ,it cost 8s, > > > when i used proxy query on 16 databases by the same sql , it cost > 60s , as far as I know the proxy used threadpool to Parallel execution the > query , but the query is slow , why? > > >
