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
```
新值
```java
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
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b2601a2] was not registered for synchronization because synchronization is not active
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b2601a2] was not registered for synchronization because synchronization is not active
上面这个执行Select 1 from Dual的频率太快了,建议设置成15秒。太快了以至于反应不过来了。
通过停止前端请求查看出来的。
# 问题
```java
Consume Time:3387 ms 2023-01-05 11:44:56
Execute SQL:SELECT 1 FROM DUAL
Consume Time:5387 ms2023-01-05 11:44:58
Execute SQL:SELECT 1 FROM DUAL
Consume Time:7387 ms2023-01-05 11:45:00
Execute SQL:SELECT 1 FROM DUAL
Consume Time:9388 ms2023-01-05 11:45:02
Execute SQL:SELECT 1 FROM DUAL
Consume Time:11388ms 2023-01-05 11:45:04
Execute SQL:SELECT 1 FROM DUAL
Consume Time:13388ms 2023-01-05 11:45:06
Execute SQL:SELECT 1 FROM DUAL
Consume Time:15389ms 2023-01-05 11:45:08
Execute SQL:SELECT 1 FROM DUAL
Consume Time:17389ms 2023-01-05 11:45:10
Execute SQL:SELECT 1 FROM DUAL
Consume Time:19389ms 2023-01-05 11:45:12
Execute SQL:SELECT 1 FROM DUAL
Creatinga 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 ms2023-01-05 11:45:18
Execute SQL:SELECT 1 FROM DUAL
Consume Time:6812 ms2023-01-05 11:45:20
Execute SQL:SELECT 1 FROM DUAL
```
新值
# 2023/06/10
上面这个执行Select 1 from Dual的频率太快了,建议设置成15秒。太快了以至于反应不过来了。
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b2601a2] was not registered for synchronization because synchronization is not active