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 2022/04/12 03:19:21 UTC
[GitHub] [shardingsphere] Even-sun opened a new issue, #16753: Shadingjdbc datasource initialization is too slowly
Even-sun opened a new issue, #16753:
URL: https://github.com/apache/shardingsphere/issues/16753
shadingjdbc version: 5.1.0
same issue: #10938
in my database it used one logic table . when initializing the datasource, read the metadata of all my tables. 8000+ tables takes 15 minutes. how can i resolved it.
<img width="1311" alt="image" src="https://user-images.githubusercontent.com/21055134/162872868-55ff1018-c1bd-4b3d-bb6f-a205b0b40dba.png">
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Even-sun commented on issue #16753: Shadingjdbc datasource initialization is too slowly
Posted by GitBox <gi...@apache.org>.
Even-sun commented on issue #16753:
URL: https://github.com/apache/shardingsphere/issues/16753#issuecomment-1096142644
> Hi, The metadata multi-threaded loading is only for data sources, and table-level multi-threaded loading not support now. Are you interested in enhancement to it?
i hope not to load all tables metadata, just process ShardingRule contained tables, SingleTableRule load all table it is too slowly.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Shadingjdbc datasource initialization is too slowly [shardingsphere]
Posted by "xjsunup (via GitHub)" <gi...@apache.org>.
xjsunup commented on issue #16753:
URL: https://github.com/apache/shardingsphere/issues/16753#issuecomment-1757297613
> <img alt="image" width="723" src="https://user-images.githubusercontent.com/16699508/274188228-259b6c9b-12d8-48c2-bfd4-7d3d61285d1b.png"> @xjsunup 排除这个，直接起飞，开发者不愿意搞配置，那就不用它也应该没啥影响。
当时也是覆盖了源码的部分实现。总之解决就好了😄
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin commented on issue #16753: Shadingjdbc datasource initialization is too slowly
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #16753:
URL: https://github.com/apache/shardingsphere/issues/16753#issuecomment-1097485558
@strongduanmu sure.
@Even-sun Can you help to position the slow code?
And 8000+ are all single tables one datasource?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #16753: Shadingjdbc datasource initialization is too slowly
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #16753: Shadingjdbc datasource initialization is too slowly
URL: https://github.com/apache/shardingsphere/issues/16753
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zjcnb commented on issue #16753: Shadingjdbc datasource initialization is too slowly
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #16753:
URL: https://github.com/apache/shardingsphere/issues/16753#issuecomment-1096073399
@Even-sun Hi, The metadata multi-threaded loading is only for data sources, and table-level multi-threaded loading not support now. Are you interested in enhancement to 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Shadingjdbc datasource initialization is too slowly [shardingsphere]
Posted by "echenchou (via GitHub)" <gi...@apache.org>.
echenchou commented on issue #16753:
URL: https://github.com/apache/shardingsphere/issues/16753#issuecomment-1757298273
您的邮件已收到！我会尽快查阅的！谢谢~
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] Even-sun commented on issue #16753: Shadingjdbc datasource initialization is too slowly
Posted by GitBox <gi...@apache.org>.
Even-sun commented on issue #16753:
URL: https://github.com/apache/shardingsphere/issues/16753#issuecomment-1098795965
> @strongduanmu sure. @Even-sun Can you help to position the slow code? And 8000+ are all single tables one datasource?
Yes, these tables are in the one datasource. but i only have one logic table need sharding,
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #16753: Shadingjdbc datasource initialization is too slowly
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #16753:
URL: https://github.com/apache/shardingsphere/issues/16753#issuecomment-1097466449
@tuichenchuxin Can you help check this issue?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Shadingjdbc datasource initialization is too slowly [shardingsphere]
Posted by "echenchou (via GitHub)" <gi...@apache.org>.
echenchou commented on issue #16753:
URL: https://github.com/apache/shardingsphere/issues/16753#issuecomment-1757079131
<img width="723" alt="image" src="https://github.com/apache/shardingsphere/assets/16699508/259b6c9b-12d8-48c2-bfd4-7d3d61285d1b">
@xjsunup 排除这个，直接起飞，开发者不愿意搞配置，那就不用它也应该没啥影响。
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org