[GitHub] [shardingsphere] tuohai666 commented on issue #8942: Why the performance of interface stress test used by shardingjdbc-4.0.1 is low obviously than not using sub-meter middleware! What we do wrong!

[GitBox <gi...@apache.org>]

tuohai666 commented on issue #8942:
URL: https://github.com/apache/shardingsphere/issues/8942#issuecomment-763314967


   @danielzhou888 Can you provide more information?
   1. What is this host used for? When to use?
   ![image](https://user-images.githubusercontent.com/24643893/105124610-6ca31500-5b15-11eb-87f6-d4256a64653c.png)
   
   2. What is this host used for?
   ![image](https://user-images.githubusercontent.com/24643893/105124906-1b475580-5b16-11eb-95ab-b3590368aabc.png)
   
   3. Jmeter run in this host right? What's its hardware env?
   ![image](https://user-images.githubusercontent.com/24643893/105124732-b7bd2800-5b15-11eb-9a2f-1b4be0aa2e1c.png)
   
   4. What's the MySQL server's hardware env?
   5. Please provide the configuration file of shardingjdbc.
   6. Please provide the SQLs of all the test cases.
   7. Can you prove the test cases do used PreparedStatement in the 2nd scenario? (show codes, etc..)
   8. How you calculate mulit-shop tps when the switch turned 'off'? I mean if shardingjdbc route to 3 shops for 1  logic SQL, we count 1. Meanwhile, when the swith turend off, 3 actual SQLs to 3 shop count as 1 or 3?
   


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