From e7b3a5e891287b1291d2ac38f7c83d5d73bc7906 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期六, 08 十月 2022 08:49:01 +0800 Subject: [PATCH] 1 --- src/main/resources/application.yml | 109 +++++++++++++++++++++++++++++++++++++++++++----------- 1 files changed, 87 insertions(+), 22 deletions(-) diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml index 70a161e..09d5061 100644 --- a/src/main/resources/application.yml +++ b/src/main/resources/application.yml @@ -3,40 +3,95 @@ uri-encoding: UTF-8 max-connections: 1000 port: 12316 - #servlet: - # context-path: /land +# servlet: +# context-path: /land application: name: land spring: session: timeout: PT20M # 20鍒嗛挓 + datasource: + name: prod + # JDBC 鍩烘湰閰嶇疆 + url: jdbc:postgresql://127.0.0.1:5432/langfang username : postgres password: postgres - url : jdbc:postgresql://192.168.20.39:5433/langfang driver-class-name: org.postgresql.Driver - type: com.alibaba.druid.pool.DruidDataSource # 鑷畾涔夋暟鎹簮 - #druid 鏁版嵁婧愪笓鏈夐厤缃� - initialSize: 5 - minIdle: 5 - maxActive: 20 - maxWait: 60000 - timeBetweenEvictionRunsMillis: 60000 - minEvictableIdleTimeMillis: 300000 - validationQuery: SELECT 1 FROM now() - testWhileIdle: true - testOnBorrow: false - testOnReturn: false - poolPreparedStatements: true - #閰嶇疆鐩戞帶缁熻鎷︽埅鐨刦ilters锛宻tat:鐩戞帶缁熻銆乴og4j锛氭棩蹇楄褰曘�亀all锛氶槻寰ql娉ㄥ叆 - #濡傛灉鍏佽鏃舵姤閿� java.lang.ClassNotFoundException: org.apache.log4j.Priority + type: com.alibaba.druid.pool.DruidDataSource + # 閰嶇疆鐩戞帶缁熻鎷︽埅鐨刦ilters锛宻tat:鐩戞帶缁熻銆乴og4j锛氭棩蹇楄褰曘�亀all锛氶槻寰ql娉ㄥ叆 filters: stat,wall,log4j - maxPoolPreparedStatementPerConnectionSize: 20 - useGlobalDataSourceStat: true + # 閫氳繃connectProperties灞炴�ф潵鎵撳紑mergeSql鍔熻兘锛涙參SQL璁板綍 connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500 + # 瓒呰繃鏃堕棿闄愬埗鏄惁鍥炴敹 + removeAbandoned: true + # 瓒呮椂鏃堕棿锛涘崟浣嶄负绉掋��180绉�=3鍒嗛挓 + removeAbandonedTimeout: 180 + # 鍏抽棴 abanded 杩炴帴鏃惰緭鍑洪敊璇棩蹇� + logAbandoned: true + + # 閰嶇疆杩炴帴姹犱俊鎭� + druid: + ## 鍒濆鍖栧ぇ灏忥紝鏈�灏忥紝鏈�澶� + initial-size: 5 + min-idle: 5 + max-active: 50 + ## 閰嶇疆鑾峰彇杩炴帴绛夊緟瓒呮椂鐨勬椂闂� + max-wait: 60000 + # 閰嶇疆闂撮殧澶氫箙鎵嶈繘琛屼竴娆℃娴嬶紝妫�娴嬮渶瑕佸叧闂殑绌洪棽杩炴帴锛屽崟浣嶆槸姣 + time-between-eviction-runs-millis: 60000 + # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�灏忕敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣 + min-evictable-idle-time-millis: 300000 + max-pool-prepared-statement-per-connection-size: 50 + pool-prepared-statements: true + # 鐢ㄦ潵娴嬭瘯杩炴帴鏄惁鍙敤鐨凷QL璇彞 + validation-query: SELECT 1 + # 搴旂敤鍚戣繛鎺ユ睜鐢宠杩炴帴锛屽苟涓攖estOnBorrow涓篺alse鏃讹紝杩炴帴姹犲皢浼氬垽鏂繛鎺ユ槸鍚﹀浜庣┖闂茬姸鎬侊紝濡傛灉鏄紝鍒欓獙璇佽繖鏉¤繛鎺ユ槸鍚﹀彲鐢� + test-while-idle: true + # 濡傛灉涓簍rue锛岄粯璁ゆ槸false锛屽簲鐢ㄥ悜杩炴帴姹犵敵璇疯繛鎺ユ椂锛岃繛鎺ユ睜浼氬垽鏂繖鏉¤繛鎺ユ槸鍚︽槸鍙敤鐨� + test-on-borrow: false + # 濡傛灉涓簍rue锛堥粯璁alse锛夛紝褰撳簲鐢ㄤ娇鐢ㄥ畬杩炴帴锛岃繛鎺ユ睜鍥炴敹杩炴帴鐨勬椂鍊欎細鍒ゆ柇璇ヨ繛鎺ユ槸鍚﹁繕鍙敤 + test-on-return: false + + stat-view-servlet: + # sql鐩戞帶寮�鍏� + enabled: true + # 璁块棶鍐呯疆鐩戞帶椤甸潰鐨勮矾寰勶紝鍐呯疆鐩戞帶椤甸潰鐨勯椤垫槸/druid/index.html + url-pattern: /druid/* + # 鏄惁鍏佽娓呯┖缁熻鏁版嵁锛岄噸鏂拌绠� true:鍏佽 false:涓嶅厑璁� + reset-enable: false + # 閰嶇疆鐩戞帶椤甸潰璁块棶璐﹀彿瀵嗙爜 + login-username: druid_mg + login-password: ad_DruId!_min + # 鍏佽璁块棶鐨勫湴鍧�锛屽鏋渁llow娌℃湁閰嶇疆鎴栬�呬负绌猴紝鍒欏厑璁告墍鏈夎闂� + allow: 127.0.0.1 + # 鎷掔粷璁块棶鐨勫湴鍧�锛宒eny浼樺厛浜巃llow锛屽鏋滃湪deny鍒楄〃涓紝灏辩畻鍦╝llow鍒楄〃涓紝涔熶細琚嫆缁� + deny: + # 閰嶇疆WebStatFilter锛岀敤浜庨噰闆唚eb鍏宠仈鐩戞帶鐨勬暟鎹� + web-stat-filter: + # web url鐩戞帶 + enabled: true + # session鐩戞帶 + session-stat-enable: true + # session鐨勬渶澶т釜鏁帮紝榛樿100 + session-stat-max-count: 1000 + # 杩囨护鎵�鏈塽rl + url-pattern: /* + # 鎺掗櫎涓�浜涗笉蹇呰鐨剈rl + exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*" + # 鑷繁閰嶇疆鐩戞帶缁熻鎷︽埅鐨刦ilter + filter: + # 寮�鍚疍ruidDataSource鐨勭姸鎬佺洃鎺� + stat: + enabled: true + db-type: postgresql + # 寮�鍚參sql鐩戞帶锛岃秴杩�2s 灏辫涓烘槸鎱ql锛岃褰曞埌鏃ュ織涓� + log-slow-sql: true + slow-sql-millis: 2000 + redis: - host: 192.168.20.39 + host: 127.0.0.1 port: 6379 password: database: 1 @@ -61,4 +116,14 @@ # 绯荤粺閰嶇疆 sys: - path: E:\\Test\\LF\\ + path: + # 瀵煎叆鐩綍 + import: D:\LF\import + # 鍑哄浘鐩綍 + export: D:\LF\export + # 涓婁紶鐩綍 + upload: D:\LF\upload + # 鍏变韩鐩綍 + share: D:\LF\share + # 涓存椂鐩綍 + temp: D:\LF\temp \ No newline at end of file -- Gitblit v1.9.3