You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "Huletian (via GitHub)" <gi...@apache.org> on 2023/03/09 02:03:19 UTC

[GitHub] [shardingsphere] Huletian opened a new issue, #24511: slow execution of sql

Huletian opened a new issue, #24511:
URL: https://github.com/apache/shardingsphere/issues/24511

   ## 	DistSQL is slow
   
   version:5.1.1 
   
   I will be very slow when executing sql .The sql is as follows 
   `
   
   add resource ds_xuexiao1 (
   	host=localhost,
   	port=3306,
   	db=xuexiao1,
   	user=root,
   	password=123456
   );
   
   
   
   	ALTER sharding TABLE rule ed_school (
   	datanodes ( "ds_${['xuexiao1','xuexiao2', 'xuexiao3']}.ed_school" ),
   	database_strategy (
   		type = standard,
   		sharding_column = school_code,
   		sharding_algorithm (
   			TYPE (
   				NAME = inline,
   			PROPERTIES ( "algorithm-expression" = "ds_${school_code}" )))) 
   );
   `
   


-- 
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] RaigorJiang closed issue #24511: Slow execution of DistSQL RDL

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #24511: Slow execution of DistSQL RDL
URL: https://github.com/apache/shardingsphere/issues/24511


-- 
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] RaigorJiang commented on issue #24511: slow execution of sql

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24511:
URL: https://github.com/apache/shardingsphere/issues/24511#issuecomment-1461311380

   @Huletian 
   Thanks for your feedback.
   Executing DistSQL will cause metadata refresh. If you have a large number of rules or tables, it will consume much time.
   Are there many rules in your logic database?


-- 
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] RaigorJiang commented on issue #24511: Slow execution of DistSQL RDL

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24511:
URL: https://github.com/apache/shardingsphere/issues/24511#issuecomment-1478854668

   This problem will be improved in the future, there are already many similar issues, so I close this one.


-- 
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] RaigorJiang commented on issue #24511: slow execution of sql

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24511:
URL: https://github.com/apache/shardingsphere/issues/24511#issuecomment-1461785840

   @Huletian 
   Ok, I heard that some contributors are designing solutions to optimize metadata refresh, looking forward to starting soon.


-- 
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] Huletian commented on issue #24511: slow execution of sql

Posted by "Huletian (via GitHub)" <gi...@apache.org>.
Huletian commented on issue #24511:
URL: https://github.com/apache/shardingsphere/issues/24511#issuecomment-1461590424

   > @Huletian Thanks for your feedback. Executing DistSQL will cause metadata refresh. If you have a large number of rules or tables, it will consume much time. Are there many rules in your logic database?
   
   Well, I do have a lot of rules and tables


-- 
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