获取数据库连接数调整

whycxzp

2024-11-01 3434eb8149587fe26760c9e6a623501035f0d78b

获取数据库连接数调整

 src/main/java/com/whyc/service/ServerStateService.java

@@ -102,10 +102,10 @@

    public List getDBConnectionInfo(){
        ArrayList<Integer> list = new ArrayList<>();
        ShowDTO obj1 = mapper.threadsConnected();
        ShowDTO obj2 = mapper.maxConnections();
        list.add(obj2.getValue());
        list.add(obj1.getValue());
        int obj1 = mapper.threadsConnected();
        int obj2 = mapper.maxConnections();
        list.add(obj2);
        list.add(obj1);
        return list;
    }


 src/main/resources/config/application-dev.yml

@@ -25,8 +25,8 @@
    username: SYSDBA
    password: SYSDBA
    maxIdle: 60
    initialPoolSize: 5
    maxPoolSize: 500
    initialPoolSize: 20
    maxPoolSize: 2000
  servlet:
    multipart:
      max-file-size: 200MB

 src/main/resources/config/application-prod.yml

@@ -29,10 +29,9 @@
#    password: ENC(0BFKp+nuSlmBu4YAB8U7rn5PoV2QVyGu)
    username: whyc
    password: ENC(8p3TZ3hhiQ04WSfRs4qWEu+8uvnGKC1z)
    maxIdel: 60
    initialPoolSize: 2
    minPoolSize: 2
    maxPoolSize: 500
    maxIdle: 60
    initialPoolSize: 20
    maxPoolSize: 2000
  servlet:
    multipart:
      max-file-size: 200MB

 src/main/resources/mapper/ServerStateMapper.xml

@@ -7,11 +7,11 @@
        select num,server_version,server_datetime,max_mem,total_mem,free_men,total_disc_space,free_disc_space,db_conn_max,db_conn_count
        ,app_conn_max,app_busy_conn_cnt,app_idle_conn_cnt,server_cpu_rate,server_network_rate from db_ram_db.tb_server_state limit 1
    </select>
    <select id="threadsConnected" resultType="com.whyc.dto.ShowDTO">
<!--        show status like '%Threads_connected%'-->
    <select id="threadsConnected" resultType="Integer">
        select count(*) from V$THREADS
    </select>
    <select id="maxConnections" resultType="com.whyc.dto.ShowDTO">
        show variables like '%max_connections%'
    <select id="maxConnections" resultType="Integer">
        SELECT para_value FROM V$DM_INI WHERE "V$DM_INI".PARA_NAME LIKE 'MAX_SESSIONS';
    </select>

</mapper>