系统性能优化几个着手点(根据实际遇到业务场景)

1.很久才拿到数据库连接问题:

1)可能原因

INFO  1234qw[2018-01-17 15:32:44,300][http-apr-0.0.0.0-42245-exec-2][] com.pingan.property.icore.pap.common.util.PAPLogger:90 - 通过mobileDTO查找或者注册uuid入参DTOMobileDTO [mobileNo=13534141202, isDefault=Y, registerSource=ICORE_VOOSP, uuidTypeName=自然人, forceRegister=Y, thirdPartyUserId=9996602, userName=null, gender=null, birthday=null, idCredentials=null, credentialsType=null]

DEBUG 1234qw[2018-01-17 15:32:44,301][http-apr-0.0.0.0-42245-exec-2][] org.springframework.transaction.support.AbstractPlatformTransactionManager:367 - Creating new transaction with name [com.pingan.property.icore.pap.uid.service.impl.ThirdUserInfoServiceImpl.insertUserInfo]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''

DEBUG 1234qw[2018-01-17 15:32:58,407][http-apr-0.0.0.0-42245-exec-2][] org.springframework.jdbc.datasource.DataSourceTransactionManager:248 - Acquired Connection [101746043, URL=jdbc:oracle:thin:@t0eshop.dbstg.paic.com.cn:1597:t0eshop, UserName=PAPOPR, Oracle JDBC driver] for JDBC transaction

DEBUG 1234qw[2018-01-17 15:32:58,407][http-apr-0.0.0.0-42245-exec-2][] org.springframework.jdbc.datasource.DataSourceTransactionManager:265 - Switching JDBC Connection [101746043, URL=jdbc:oracle:thin:@t0eshop.dbstg.paic.com.cn:1597:t0eshop, UserName=PAPOPR, Oracle JDBC driver] to manual commit

2.接口慢问题:1)增加异步线程处理,2)增加缓存,去cache里拿数据。

 

原文地址:https://www.cnblogs.com/panxuejun/p/8303671.html