代码拉取完成,页面将自动刷新
上面这个执行Select 1 from Dual的频率太快了,建议设置成15秒。太快了以至于反应不过来了。
通过停止前端请求查看出来的。
可以考虑查看源码,然后修改这个查询的频率,等待10s左右再发起第二次查询。这个连接池使用的是druid。
Consume Time:3387 ms 2023-01-05 11:44:56
Execute SQL:SELECT 1 FROM DUAL
Consume Time:5387 ms 2023-01-05 11:44:58
Execute SQL:SELECT 1 FROM DUAL
Consume Time:7387 ms 2023-01-05 11:45:00
Execute SQL:SELECT 1 FROM DUAL
Consume Time:9388 ms 2023-01-05 11:45:02
Execute SQL:SELECT 1 FROM DUAL
Consume Time:11388 ms 2023-01-05 11:45:04
Execute SQL:SELECT 1 FROM DUAL
Consume Time:13388 ms 2023-01-05 11:45:06
Execute SQL:SELECT 1 FROM DUAL
Consume Time:15389 ms 2023-01-05 11:45:08
Execute SQL:SELECT 1 FROM DUAL
Consume Time:17389 ms 2023-01-05 11:45:10
Execute SQL:SELECT 1 FROM DUAL
Consume Time:19389 ms 2023-01-05 11:45:12
Execute SQL:SELECT 1 FROM DUAL
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b2601a2] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.8181818181818182
Consume Time:2812 ms 2023-01-05 11:45:16
Execute SQL:SELECT 1 FROM DUAL
Consume Time:4812 ms 2023-01-05 11:45:18
Execute SQL:SELECT 1 FROM DUAL
Consume Time:6812 ms 2023-01-05 11:45:20
Execute SQL:SELECT 1 FROM DUAL