[GitHub] [incubator-shardingsphere] lcx1989210 commented on issue #3515: Full GC occured Frequently in production environment

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

lcx1989210 commented on issue #3515: Full GC occured Frequently in production environment
URL: https://github.com/apache/incubator-shardingsphere/issues/3515#issuecomment-553753037
 
 
   This problem makes me very  confused. After I restart the application server, The first few requests may cause this problem(full gc ),after which the request will be normal，and the memory normal. 
   
   My  SQL, sharding rule configuration as follows：
   ![QQ图片20191114144910](https://user-images.githubusercontent.com/21120592/68833664-ffb11580-06ee-11ea-9cb6-62920ca26700.png)
   
   
   and my sql is :
   
    select 
           o.id id, o.source_order_code source_order_code, o.user_id user_id, o.source_order_type source_order_type,  o.price price,o.created_at created_at, o.modified_at modified_at, o.mer_id mer_id, o.pay_id pay_id,o.extension1 extension1,o.extension2 extension2,
           b.status status,b.begin_at begin_at, b.end_at end_at, b.amount amount, b.amount_left amount_left, b.product_code product_code, b.categorys categorys, b.citys citys, b.owner_id owner_id,b.is_city is_city,b.is_cate is_cate,b.priority priority
           from order o
           inner join balance b
           on o.id = b.order_id
           where o.user_id = ?
           and b.user_id = ?
           and b.user_type = ?
           and o.user_type = ?
           and b.product_code= ?
           and b.status = ?       
           and b.is_city = ?
           and    b.begin_at < unix_timestamp(current_timestamp(3))*1000  
           and    b.end_at > unix_timestamp(current_timestamp(3))*1000  
           and    b.amount_left > 0  
   
   To solve this problem, what should I do now?

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


With regards,
Apache Git Services