diff options
| author | LazyDBA247-Anyvision <yonin@anyvision.co> | 2021-01-14 09:48:12 +0200 |
|---|---|---|
| committer | LazyDBA247-Anyvision <yonin@anyvision.co> | 2021-01-14 09:48:12 +0200 |
| commit | 5581d087021560a4b83cf6434726c00c668abb75 (patch) | |
| tree | 37d165d0ba5c8bb27efd2097599286b469eef204 | |
| parent | 8eed763b97acc3af6420f7e370c3e61ecc7befe2 (diff) | |
| download | seaweedfs-5581d087021560a4b83cf6434726c00c668abb75.tar.xz seaweedfs-5581d087021560a4b83cf6434726c00c668abb75.zip | |
K8S mysql connection pool
set max lifetime to 10 minutes, keeping connection "fresh"
and eliminating mysql/memsql closing old connection (causing filer errors)
| -rw-r--r-- | k8s/seaweedfs/values.yaml | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/k8s/seaweedfs/values.yaml b/k8s/seaweedfs/values.yaml index cdb9437ee..e08731354 100644 --- a/k8s/seaweedfs/values.yaml +++ b/k8s/seaweedfs/values.yaml @@ -298,8 +298,10 @@ filer: WEED_MYSQL_HOSTNAME: "mysql-db-host" WEED_MYSQL_PORT: "3306" WEED_MYSQL_DATABASE: "sw_database" - WEED_MYSQL_CONNECTION_MAX_IDLE: "10" - WEED_MYSQL_CONNECTION_MAX_OPEN: "150" + WEED_MYSQL_CONNECTION_MAX_IDLE: "5" + WEED_MYSQL_CONNECTION_MAX_OPEN: "75" + # "refresh" connection every 10 minutes, eliminating mysql closing "old" connections + WEED_MYSQL_CONNECTION_MAX_LIFETIME_SECONDS: "600" # enable usage of memsql as filer backend WEED_MYSQL_INTERPOLATEPARAMS: "true" WEED_LEVELDB2_ENABLED: "false" |