Hi Sheng, Weijie I found that after executing DistSQL in 5.3.1, it takes a lot of time to refresh metadata. After executing a large amount of DistSQL, each refresh can take tens of seconds. In comparison, executing the same SQL script only takes hundreds of milliseconds for a refresh in the previous version. Now Jinchao and I are locating this problem.
Regards, Longtao ----------------------------------------------- Longtao Jiang Apache ShardingSphere Committer GitHub@RaigorJiang On 2023/01/05 01:57:42 Sheng Wu wrote: > I think Longtao is working on that. > The last update from today morning is, there is a performance impact > when updating metadata. > The attachment is the profiling result. > > > Sheng Wu 吴晟 > Twitter, wusheng1108 > > 吴伟杰 <wuwei...@apache.org> 于2023年1月5日周四 09:40写道： > > > > Hi Sheng > > > > Is there any details about the performance impact? How could we reproduce > > it? > > > > Regards, > > Weijie > > ----------------------------------------------- > > > > Wu Weijie 吴伟杰 > > Apache ShardingSphere PMC > > GitHub@TeslaCN > > > > Sheng Wu <wu.sheng.841...@gmail.com> 于2023年1月4日周三 18:42写道： > > > > > > There is under doing about bumping version of ShardingSphere in SkyWalking > > > storage. > > > From last sync, there are some unclear performance impact. > > > > > > I want to check whether that could be located and fixed before the > > > release? > > > > > > Hongsheng Zhong <zhonghongsh...@apache.org>于2023年1月4日 周三18:28写道： > > > > > > > Hi community, > > > > > > > > > > > > > > > > > > > > After the release of 5.3.0 version, we have received a lot of feedback > > > > > > > > from users and developers. Now we plan to release the ShardingSphere > > > > 5.3.1 > > > > > > > > version these days, which has made a lot of optimization and improvement > > > > for > > > > > > > > these feedback. > > > > > > > > > > > > > > > > > > > > Please refer to this release notes[1] to confirm whether it contains the > > > > > > > > features you expect. If I missed anything, please remind me ASAP. If > > > > there > > > > > > > > are any suggestions, please feel free to tell us. > > > > > > > > > > > > > > > > > > > > [1] https://github.com/apache/shardingsphere/discussions/23328 > > > > > > > > > > > > > > > > > > > > Best regards, > > > > > > > > Hongsheng > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > Hongsheng Zhong (zhonghongsh...@apache.org) > > > > Apache ShardingSphere Committer > > > > GitHub@sandynz > > > > > > -- > > > Sheng Wu 吴晟 > > > > > > Apache SkyWalking > > > Apache Incubator > > > Apache ShardingSphere, ECharts, DolphinScheduler podlings > > > Zipkin > > > Twitter, wusheng1108 >
