summaryrefslogtreecommitdiff
path: root/.config
diff options
context:
space:
mode:
authorHazelnoot <acomputerdog@gmail.com>2025-05-30 08:10:46 -0400
committerHazelnoot <acomputerdog@gmail.com>2025-05-30 12:27:59 -0400
commitb057d3be0de1de61c4a83e3b1d8c247df6240475 (patch)
treedc6101f6315ddffe2c478ef6486e856ee75f506a /.config
parentmerge: Log config file paths at startup (!1066) (diff)
downloadsharkey-b057d3be0de1de61c4a83e3b1d8c247df6240475.tar.gz
sharkey-b057d3be0de1de61c4a83e3b1d8c247df6240475.tar.bz2
sharkey-b057d3be0de1de61c4a83e3b1d8c247df6240475.zip
add slowQueryThreshold setting to configure slow query warning
Diffstat (limited to '.config')
-rw-r--r--.config/ci.yml4
-rw-r--r--.config/cypress-devcontainer.yml4
-rw-r--r--.config/docker_example.yml4
-rw-r--r--.config/example.yml6
4 files changed, 16 insertions, 2 deletions
diff --git a/.config/ci.yml b/.config/ci.yml
index 7d5261aacd..a1c8c23b44 100644
--- a/.config/ci.yml
+++ b/.config/ci.yml
@@ -115,6 +115,10 @@ db:
user: postgres
pass: ci
+ # Log a warning to the server console if any query takes longer than this to complete.
+ # Measured in milliseconds; set to 0 to disable. (default: 300)
+ slowQueryThreshold: 300
+
# If false, then query results will be cached in redis.
# If true (default), then queries will not be cached.
# This will reduce database load at the cost of increased Redis traffic and risk of bugs and unpredictable behavior.
diff --git a/.config/cypress-devcontainer.yml b/.config/cypress-devcontainer.yml
index 51f408983c..97f78f3ccc 100644
--- a/.config/cypress-devcontainer.yml
+++ b/.config/cypress-devcontainer.yml
@@ -57,6 +57,10 @@ db:
user: postgres
pass: postgres
+ # Log a warning to the server console if any query takes longer than this to complete.
+ # Measured in milliseconds; set to 0 to disable. (default: 300)
+ slowQueryThreshold: 300
+
# If false, then query results will be cached in redis.
# If true (default), then queries will not be cached.
# This will reduce database load at the cost of increased Redis traffic and risk of bugs and unpredictable behavior.
diff --git a/.config/docker_example.yml b/.config/docker_example.yml
index 1b55eee7f5..051526024e 100644
--- a/.config/docker_example.yml
+++ b/.config/docker_example.yml
@@ -118,6 +118,10 @@ db:
user: example-misskey-user
pass: example-misskey-pass
+ # Log a warning to the server console if any query takes longer than this to complete.
+ # Measured in milliseconds; set to 0 to disable. (default: 300)
+ slowQueryThreshold: 300
+
# If false, then query results will be cached in redis.
# If true (default), then queries will not be cached.
# This will reduce database load at the cost of increased Redis traffic and risk of bugs and unpredictable behavior.
diff --git a/.config/example.yml b/.config/example.yml
index b7843da9ad..7d9b6ceda6 100644
--- a/.config/example.yml
+++ b/.config/example.yml
@@ -121,13 +121,15 @@ db:
user: sharkey
pass: example-misskey-pass
+ # Log a warning to the server console if any query takes longer than this to complete.
+ # Measured in milliseconds; set to 0 to disable. (default: 300)
+ slowQueryThreshold: 300
+
# If false, then query results will be cached in redis.
# If true (default), then queries will not be cached.
# This will reduce database load at the cost of increased Redis traffic and risk of bugs and unpredictable behavior.
#disableCache: false
- #
-
# Extra Connection options
#extra:
# ssl: true