diff options
author | Xuanwo | 2019-07-05 19:17:32 +0800 |
---|---|---|
committer | Xuanwo | 2019-07-05 19:17:32 +0800 |
commit | b0786cee6a3791f1abde4070508bb71083d8ee8c (patch) | |
tree | e31f8e763cd42e59cb91a3a4bd74ac8a25f2ea0d | |
parent | fa07aac01dd48df01a443d433c82fea72a76cd67 (diff) | |
download | aur-b0786cee6a3791f1abde4070508bb71083d8ee8c.tar.gz |
Bump to version 3.0.0
-rw-r--r-- | .SRCINFO | 8 | ||||
-rw-r--r-- | PKGBUILD | 6 | ||||
-rw-r--r-- | tidb.toml | 106 |
3 files changed, 100 insertions, 20 deletions
@@ -1,6 +1,6 @@ pkgbase = tidb pkgdesc = A distributed HTAP database compatible with the MySQL protocol - pkgver = 2.1.10 + pkgver = 3.0.0 pkgrel = 1 url = https://github.com/pingcap/tidb arch = x86_64 @@ -11,16 +11,16 @@ pkgbase = tidb depends = tikv provides = tidb-server backup = etc/tidb/tidb.toml - source = tidb-2.1.10.tar.gz::https://github.com/pingcap/tidb/archive/v2.1.10.tar.gz + source = tidb-3.0.0.tar.gz::https://github.com/pingcap/tidb/archive/v3.0.0.tar.gz source = tidb.service source = tidb-sysusers.conf source = tidb-tmpfiles.conf source = tidb.toml - sha256sums = 34f532e0290388cd843bd36900888a67dd6e72f35f1fc09df192d75548a2ca67 + sha256sums = c92424569419538671c80b3cbd13e287af598c5ac263d267f98842814df2982b sha256sums = 22318c19bb89ff5a0852df5186cc1496214cd49f2264192413a326d1e8c93dc9 sha256sums = 2b147d80985e714d5f861baf76591104c07058b9b6fa573bf0676d675cf8fc20 sha256sums = 30ce83fbec8f102c30e438282bb5b18c026d08480f2386d68f1116c12481bf66 - sha256sums = a34a8ca1f13c965cc0e872fc671f377b64a80cc11225cd6359bf7415b4c86a06 + sha256sums = 906c6b0cb66e627b51ee938f266d8126f6857360e56d070ca254005b6752c64d pkgname = tidb @@ -1,6 +1,6 @@ # Maintainer: Xuanwo <xuanwo@archlinuxcn.org> pkgname=tidb -pkgver=2.1.10 +pkgver=3.0.0 pkgrel=1 pkgdesc='A distributed HTAP database compatible with the MySQL protocol' makedepends=('go' 'make' 'git') @@ -15,11 +15,11 @@ source=(tidb-${pkgver}.tar.gz::https://github.com/pingcap/tidb/archive/v${pkgver tidb-sysusers.conf tidb-tmpfiles.conf tidb.toml) -sha256sums=('34f532e0290388cd843bd36900888a67dd6e72f35f1fc09df192d75548a2ca67' +sha256sums=('c92424569419538671c80b3cbd13e287af598c5ac263d267f98842814df2982b' '22318c19bb89ff5a0852df5186cc1496214cd49f2264192413a326d1e8c93dc9' '2b147d80985e714d5f861baf76591104c07058b9b6fa573bf0676d675cf8fc20' '30ce83fbec8f102c30e438282bb5b18c026d08480f2386d68f1116c12481bf66' - 'a34a8ca1f13c965cc0e872fc671f377b64a80cc11225cd6359bf7415b4c86a06') + '906c6b0cb66e627b51ee938f266d8126f6857360e56d070ca254005b6752c64d') _gopkgname='github.com/pingcap/tidb' diff --git a/tidb.toml b/tidb.toml index 1e02e45c5451..b5bff46d7c1a 100644 --- a/tidb.toml +++ b/tidb.toml @@ -3,6 +3,9 @@ # TiDB server host. host = "0.0.0.0" +# tidb server advertise IP. +advertise-address = "" + # TiDB server port. port = 4000 @@ -41,6 +44,22 @@ enable-streaming = false # Set system variable 'lower_case_table_names' lower-case-table-names = 2 +# Make "kill query" behavior compatible with MySQL. It's not recommend to +# turn on this option when TiDB server is behind a proxy. +compatible-kill-query = false + +# check mb4 value in utf8 is used to control whether to check the mb4 characters when the charset is utf8. +check-mb4-value-in-utf8 = true + +# treat-old-version-utf8-as-utf8mb4 use for upgrade compatibility. Set to true will treat old version table/column UTF8 charset as UTF8MB4. +treat-old-version-utf8-as-utf8mb4 = true + +# enable-table-lock is used to control table lock feature. Default is false, indicate the table lock feature is disabled. +enable-table-lock = false + +# delay-clean-table-lock is used to control whether delayed-release the table lock in the abnormal situation. (Milliseconds) +delay-clean-table-lock = 0 + [log] # Log level: debug, info, warn, error, fatal. level = "info" @@ -52,7 +71,7 @@ format = "text" disable-timestamp = false # Stores slow query log into separated files. -slow-query-file = "" +slow-query-file = "tidb-slow.log" # Queries with execution time greater than this value will be logged. (Milliseconds) slow-threshold = 300 @@ -103,6 +122,10 @@ cluster-ssl-key = "" # If enable status report HTTP service. report-status = true +# TiDB status host. +status-host = "0.0.0.0" + +# Prometheus pushgateway address, leaves it empty will disable prometheus push. # TiDB status port. status-port = 10080 @@ -112,18 +135,22 @@ metrics-addr = "" # Prometheus client push interval in second, set \"0\" to disable prometheus push. metrics-interval = 15 +# Record statements qps by database name if it is enabled. +record-db-qps = false + [performance] # Max CPUs to use, 0 use number of CPUs in the machine. max-procs = 0 + +# Max memory size to use, 0 use the total usable memory in the machine. +max-memory = 0 + # StmtCountLimit limits the max count of statement inside a transaction. stmt-count-limit = 5000 # Set keep alive option for tcp connection. tcp-keep-alive = true -# The maximum number of retries when commit a transaction. -retry-limit = 10 - # Whether support cartesian product. cross-join = true @@ -134,14 +161,33 @@ stats-lease = "3s" run-auto-analyze = true # Probability to use the query feedback to update stats, 0 or 1 for always false/true. -feedback-probability = 0.0 +feedback-probability = 0.05 # The max number of query feedback that cache in memory. query-feedback-limit = 1024 # Pseudo stats will be used if the ratio between the modify count and # row count in statistics of a table is greater than it. -pseudo-estimate-ratio = 0.7 +pseudo-estimate-ratio = 0.8 + +# Force the priority of all statements in a specified priority. +# The value could be "NO_PRIORITY", "LOW_PRIORITY", "HIGH_PRIORITY" or "DELAYED". +force-priority = "NO_PRIORITY" + +# Bind info lease duration, which influences the duration of loading bind info and handling invalid bind. +bind-info-lease = "3s" + +# The limitation of the number for the entries in one transaction. +# If using TiKV as the storage, the entry represents a key/value pair. +# WARNING: Do not set the value too large, otherwise it will make a very large impact on the TiKV cluster. +# Please adjust this configuration carefully. +txn-entry-count-limit = 300000 + +# The limitation of the size in byte for the entries in one transaction. +# If using TiKV as the storage, the entry represents a key/value pair. +# WARNING: Do not set the value too large, otherwise it will make a very large impact on the TiKV cluster. +# Please adjust this configuration carefully. +txn-total-size-limit = 104857600 [proxy-protocol] # PROXY protocol acceptable client networks. @@ -151,14 +197,10 @@ networks = "" # PROXY protocol header read timeout, unit is second header-timeout = 5 -[plan-cache] -enabled = false -capacity = 2560 -shards = 256 - [prepared-plan-cache] enabled = false capacity = 100 +memory-guard-ratio = 0.1 [opentracing] # Enable opentracing. @@ -223,9 +265,29 @@ grpc-keepalive-time = 10 # and if no activity is seen even after that the connection is closed. grpc-keepalive-timeout = 3 -# max time for commit command, must be twice bigger than raft election timeout. +# Max time for commit command, must be twice bigger than raft election timeout. commit-timeout = "41s" +# The max time a Txn may use (in seconds) from its startTS to commitTS. +# We use it to guarantee GC worker will not influence any active txn. Please make sure that this +# value is less than gc_life_time - 10s. +max-txn-time-use = 590 + +# Max batch size in gRPC. +max-batch-size = 128 +# Overload threshold of TiKV. +overload-threshold = 200 +# Max batch wait time in nanosecond to avoid waiting too long. 0 means disable this feature. +max-batch-wait-time = 0 +# Batch wait size, to avoid waiting too long. +batch-wait-size = 8 + +[txn-local-latches] +# Enable local latches for transactions. Enable it when +# there are lots of conflicts between transactions. +enabled = true +capacity = 2048000 + [binlog] # enable to write binlog. enable = false @@ -233,9 +295,27 @@ enable = false # WriteTimeout specifies how long it will wait for writing binlog to pump. write-timeout = "15s" -# If IgnoreError is true, when writting binlog meets error, TiDB would stop writting binlog, +# If IgnoreError is true, when writing binlog meets error, TiDB would stop writing binlog, # but still provide service. ignore-error = false # use socket file to write binlog, for compatible with kafka version tidb-binlog. binlog-socket = "" + +# the strategy for sending binlog to pump, value can be "range" or "hash" now. +strategy = "range" + +[pessimistic-txn] +# enable pessimistic transaction. +enable = false + +# start pessimistic transaction by default. +default = false + +# max retry count for a statement in a pessimistic transaction. +max-retry-count = 256 + +# default TTL in milliseconds for pessimistic lock. +# The value must between "15s" and "60s". +ttl = "30s" + |