Skip to content

Instantly share code, notes, and snippets.

@c4pt0r
Created May 26, 2019 17:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save c4pt0r/b0c39f9da9360af2fb2c41ace274b30e to your computer and use it in GitHub Desktop.
Save c4pt0r/b0c39f9da9360af2fb2c41ace274b30e to your computer and use it in GitHub Desktop.
tikv config for sysbench
diff --git a/conf/tidb.yml b/conf/tidb.yml
index d7e1d23..6e15aab 100644
--- a/conf/tidb.yml
+++ b/conf/tidb.yml
@@ -42,7 +42,7 @@ global:
log:
# Log level: debug, info, warn, error, fatal.
- # level: "info"
+ level: "error"
# Log format, one of json, text, console.
# format: "text"
@@ -141,7 +141,7 @@ proxy_protocol:
# header-timeout: 5
prepared_plan_cache:
- # enabled: false
+ enabled: true
# capacity: 100
# memory-guard-ratio: 0.1
@@ -218,7 +218,7 @@ tikv_client:
# overload-threshold: 200
# Max batch wait time in nanosecond to avoid waiting too long. 0 means disable this feature.
- # max-batch-wait-time: 0
+ max-batch-wait-time: 1000000
# Batch wait size, to avoid waiting too long.
# batch-wait-size: 8
diff --git a/conf/tikv.yml b/conf/tikv.yml
index 1eb48ac..59f29f5 100644
--- a/conf/tikv.yml
+++ b/conf/tikv.yml
@@ -11,7 +11,7 @@
global:
## Log levels: trace, debug, info, warning, error, critical.
## Note that `debug` and `trace` are only available in development builds.
- # log-level: "info"
+ log-level: "error"
## Timespan between rotating the log files.
## Once this timespan passes, log files will be rotated, i.e. existing log file will have a
@@ -21,13 +21,13 @@ global:
readpool:
storage:
## Size of the thread pool for high-priority operations.
- # high-concurrency: 4
+ high-concurrency: 12
## Size of the thread pool for normal-priority operations.
- # normal-concurrency: 4
+ normal-concurrency: 12
## Size of the thread pool for low-priority operations.
- # low-concurrency: 4
+ low-concurrency: 12
## Max running high-priority operations of each worker, reject if exceeded.
# max-tasks-per-worker-high: 2000
@@ -66,7 +66,7 @@ server:
# grpc-compression-type: "none"
## Size of the thread pool for the gRPC server.
- # grpc-concurrency: 4
+ grpc-concurrency: 8
## The number of max concurrent streams/requests on a client connection.
# grpc-concurrent-stream: 1024
@@ -232,10 +232,10 @@ raftstore:
# cleanup-import-sst-interval: "10m"
## Use how many threads to handle log apply
- # apply-pool-size: 2
+ apply-pool-size: 4
## Use how many threads to handle raft messages
- # store-pool-size: 2
+ store-pool-size: 4
coprocessor:
## When it is set to `true`, TiKV will try to split a Region with table prefix if that Region
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment