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 2020/12/23 07:54:30 UTC

[GitHub] [shardingsphere] lhcxj576 opened a new issue #8733: Reading the first library in a transaction is very slow, taking approximately 500ms

lhcxj576 opened a new issue #8733:
URL: https://github.com/apache/shardingsphere/issues/8733


   ![1](https://user-images.githubusercontent.com/73157467/102963751-e353ef00-4524-11eb-9b9c-648e7cfbf444.png)
   ![2](https://user-images.githubusercontent.com/73157467/102963754-e64edf80-4524-11eb-9b93-dac2611116bd.png)
   ![image](https://user-images.githubusercontent.com/73157467/102972686-6a5d9300-4536-11eb-9557-c1b856ee731a.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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] lhcxj576 commented on issue #8733: Reading the first library in a transaction is very slow, taking approximately 500ms

Posted by GitBox <gi...@apache.org>.
lhcxj576 commented on issue #8733:
URL: https://github.com/apache/shardingsphere/issues/8733#issuecomment-750749583


   @yu199195 
   version=4.0.0
   
   sql:
   select id from table_name where id in (210032);


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] terrymanu closed issue #8733: Reading the first library in a transaction is very slow, taking approximately 500ms

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #8733:
URL: https://github.com/apache/shardingsphere/issues/8733


   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] tristaZero commented on issue #8733: Reading the first library in a transaction is very slow, taking approximately 500ms

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8733:
URL: https://github.com/apache/shardingsphere/issues/8733#issuecomment-751183978


   Hi @lhcxj576 I just wanna figure out which part of one execution took up the most of the time.
   That way, we can consider the improvement for that target part.


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] terrymanu commented on issue #8733: Reading the first library in a transaction is very slow, taking approximately 500ms

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #8733:
URL: https://github.com/apache/shardingsphere/issues/8733#issuecomment-753251519


   What is Reading the first `library`? 
   Can you correct your word first?


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] tristaZero commented on issue #8733: Reading the first library in a transaction is very slow, taking approximately 500ms

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #8733:
URL: https://github.com/apache/shardingsphere/issues/8733#issuecomment-750734694


   Hi @lhcxj576 ,
   
   Which SQL did you run? If possible, could you add some breakpoints at `parse()` of `ShardingSphereSQLParserEngine` to check whether the SQL parser pretty took time?


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] yu199195 commented on issue #8733: Reading the first library in a transaction is very slow, taking approximately 500ms

Posted by GitBox <gi...@apache.org>.
yu199195 commented on issue #8733:
URL: https://github.com/apache/shardingsphere/issues/8733#issuecomment-750216210


   show you sql and what version used?  
   @tristaZero  Can you give him some help?


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] terrymanu commented on issue #8733: Reading the first library in a transaction is very slow, taking approximately 500ms

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #8733:
URL: https://github.com/apache/shardingsphere/issues/8733#issuecomment-761765192


   Closed because of no response.


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] lhcxj576 commented on issue #8733: Reading the first library in a transaction is very slow, taking approximately 500ms

Posted by GitBox <gi...@apache.org>.
lhcxj576 commented on issue #8733:
URL: https://github.com/apache/shardingsphere/issues/8733#issuecomment-750750740


   @tristaZero 
   add some breakpoints And that, it seems, doesn't help, right


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org