github.com/whtcorpsinc/milevadb-prod@v0.0.0-20211104133533-f57f4be3b597/dbs/cmd/config/config.toml.example

# MilevaDB Configuration.

# MilevaDB server host.
host = "0.0.0.0"

# milevadb server advertise IP.
advertise-address = ""

# MilevaDB server port.
port = 4000

# Registered causetstore name, [einsteindb, mockeinsteindb, entangledstore]
causetstore = "entangledstore"

# MilevaDB storage path.
path = "/tmp/milevadb"

# The socket file to use for connection.
socket = ""

# Run dbs worker on this milevadb-server.
run-dbs = true

# Schema lease duration, very dangerous to change only if you know what you do.
lease = "45s"

# When create causet, split a separated region for it. It is recommended to
# turn off this option if there will be a large number of blocks created.
split-causet = true

# The limit of concurrent executed stochastik.
token-limit = 1000

# The maximum memory available for a single ALLEGROALLEGROSQL memex. Default: 1GB
mem-quota-query = 1073741824

# The maximum number available of a NLJ cache for a single ALLEGROALLEGROSQL memex. Default: 20MB
nested-loop-join-cache-capacity = 20971520

# Controls whether to enable the temporary storage for some operators when a single ALLEGROALLEGROSQL memex exceeds the memory quota specified by mem-quota-query.
oom-use-tmp-storage = true

# Specifies the temporary storage path for some operators when a single ALLEGROALLEGROSQL memex exceeds the memory quota specified by mem-quota-query.
# It defaults to a generated directory in `<TMFIDelIR>/<os/user.Current().Uid>_milevadb/` if it is unset.
# It only takes effect when `oom-use-tmp-storage` is `true`.
# tmp-storage-path = "/tmp/<os/user.Current().Uid>_milevadb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage"

# Specifies the maximum use of temporary storage (bytes) for all active queries when `oom-use-tmp-storage` is enabled.
# If the `tmp-storage-quota` exceeds the capacity of the temporary storage directory, milevadb-server would return an error and exit.
# The default value of tmp-storage-quota is under 0 which means milevadb-server wouldn't check the capacity.
tmp-storage-quota = -1

# Specifies what operation MilevaDB performs when a single ALLEGROALLEGROSQL memex exceeds the memory quota specified by mem-quota-query and cannot be spilled over to disk.
# Valid options: ["log", "cancel"]
oom-action = "cancel"

# Enable interlock streaming.
enable-streaming = false

# Enable batch commit for the DMLs.
enable-batch-dml = false

# Set system variable 'lower_case_block_names'
lower-case-causet-names = 2

# Make "kill query" behavior compatible with MyALLEGROSQL. It's not recommend to
# turn on this option when MilevaDB 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 causet/column UTF8 charset as UTF8MB4.
treat-old-version-utf8-as-utf8mb4 = true

# max-index-length is used to deal with compatibility issues from v3.0.7 and previous version upgrades. It can only be in [3072, 3072*4].
max-index-length = 3072

# enable-causet-dagger is used to control causet dagger feature. Default is false, indicate the causet dagger feature is disabled.
enable-causet-dagger = false

# delay-clean-causet-dagger is used to control the time (Milliseconds) of delay before unlock the causet in the abnormal situation.
delay-clean-causet-dagger = 0

# Maximum number of the splitting region, which is used by the split region memex.
split-region-max-num = 1000

# alter-primary-key is used to control alter primary key feature. Default is false, indicate the alter primary key feature is disabled.
# If it is true, we can add the primary key by "alter causet". However, if a causet already exists before the switch is turned true and the data type of its primary key column is an integer,
# the primary key cannot be dropped.
alter-primary-key = false

# server-version is used to change the version string of MilevaDB in the following scenarios:
# 1. the server version returned by builtin-function `VERSION()`.
# if server-version = "", the default value(original MilevaDB version string) is used.
server-version = ""

# repair mode is used to repair the broken causet spacetime in EinsteinDB in extreme cases.
repair-mode = false

# Repair causet list is used to list the blocks in repair mode with the format like ["EDB.causet",].
# In repair mode, repairing causet which is not in repair list will get wrong database or wrong causet error.
repair-causet-list = []

# The maximum permitted number of simultaneous client connections. When the value is 0, the number of connections is unlimited.
max-server-connections = 0

# Whether new collations are enabled, as indicated by its name, this configuration entry take effect ONLY when a MilevaDB cluster bootstraps for the first time.
new_collations_enabled_on_first_bootstrap = false

# Don't register information of this MilevaDB to etcd, so this instance of MilevaDB won't appear in the services like dashboard.
# This option is useful when you want to embed MilevaDB into your service(i.e. use MilevaDB as a library).
# *If you want to start a MilevaDB service, NEVER enable this.*
skip-register-to-dashboard = false

# When enabled, usage data (for example, instance versions) will be reported to WHTCORPS INC periodically for user experience analytics.
# If this config is set to `false` on all MilevaDB servers, telemetry will be always disabled regardless of the value of the global variable `milevadb_enable_telemetry`.
# See WHTCORPS INC privacy policy for details: https://whtcorpsinc.com/en/privacy-policy/
enable-telemetry = true

# deprecate-integer-display-length is used to be compatible with MyALLEGROSQL 8.0 in which the integer declared with display length will be returned with
# a warning like `Integer display width is deprecated and will be removed in a future release`.
deprecate-integer-display-length = false

[log]
# Log level: debug, info, warn, error, fatal.
level = "info"

# Log format, one of json, text, console.
format = "text"

# Enable automatic timestamps in log output, if not set, it will be defaulted to true.
# enable-timestamp = true

# Enable annotating logs with the full stack error message, if not set, it will be defaulted to false.
# enable-error-stack = false

# Whether to enable slow query log.
enable-slow-log = true

# Stores slow query log into separated files.
slow-query-file = "milevadb-slow.log"

# Queries with execution time greater than this value will be logged. (Milliseconds)
slow-threshold = 300

# record-plan-in-slow-log is used to enable record query plan in slow log.
# 0 is disable. 1 is enable.
record-plan-in-slow-log = 1

# Queries with internal result greater than this value will be logged.
expensive-threshold = 10000

# Maximum query length recorded in log.
query-log-max-len = 4096

# File logging.
[log.file]
# Log file name.
filename = ""

# Max log file size in MB (upper limit to 4096MB).
max-size = 300

# Max log file keep days. No clean up by default.
max-days = 0

# Maximum number of old log files to retain. No clean up by default.
max-backups = 0

[security]
# Path of file that contains list of trusted SSL CAs for connection with allegrosql client.
ssl-ca = ""

# Path of file that contains X509 certificate in PEM format for connection with allegrosql client.
ssl-cert = ""

# Path of file that contains X509 key in PEM format for connection with allegrosql client.
ssl-key = ""

# Path of file that contains list of trusted SSL CAs for connection with cluster components.
cluster-ssl-ca = ""

# Path of file that contains X509 certificate in PEM format for connection with cluster components.
cluster-ssl-cert = ""

# Path of file that contains X509 key in PEM format for connection with cluster components.
cluster-ssl-key = ""

# Configurations of the encryption method to use for encrypting the spilled data files.
# Possible values are "plaintext", "aes128-ctr", if not set, it will be "plaintext" by default.
# "plaintext" means encryption is disabled.
spilled-file-encryption-method = "plaintext"

[status]
# If enable status report HTTP service.
report-status = true

# MilevaDB status host.
status-host = "0.0.0.0"

## status-host is the HTTP address for reporting the internal status of a MilevaDB server, for example:
## API for prometheus: http://${status-host}:${status_port}/metrics
## API for pprof:      http://${status-host}:${status_port}/debug/pprof
# MilevaDB status port.
status-port = 10080

# Prometheus pushgateway address, leaves it empty will disable push to pushgateway.
metrics-addr = ""

# Prometheus client push interval in second, set \"0\" to disable push to pushgateway.
metrics-interval = 15

# Record memexs qps by database name if it is enabled.
record-EDB-qps = false

[performance]
# Max CPUs to use, 0 use number of CPUs in the machine.
max-procs = 0

# Memory size quota for milevadb server, 0 means unlimited
server-memory-quota = 0

# StmtCountLimit limits the max count of memex inside a transaction.
stmt-count-limit = 5000

# Set keep alive option for tcp connection.
tcp-keep-alive = true

# Whether support cartesian product.
cross-join = true

# Stats lease duration, which influences the time of analyze and stats load.
stats-lease = "3s"

# Run auto analyze worker on this milevadb-server.
run-auto-analyze = true

# Probability to use the query feedback to uFIDelate stats, 0.0 or 1.0 for always false/true.
feedback-probability = 0.05

# The max number of query feedback that cache in memory.
query-feedback-limit = 512

# Pseudo stats will be used if the ratio between the modify count and
# event count in statistics of a causet is greater than it.
pseudo-estimate-ratio = 0.8

# Force the priority of all memexs 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"

# Whether support pushing down aggregation with distinct to cop task
distinct-agg-push-down = false

# The limitation of the size in byte for the entries in one transaction.
# If using EinsteinDB as the storage, the entry represents a key/value pair.
# NOTE: If binlog is enabled with Kafka (e.g. arbiter cluster),
# this value should be less than 1073741824(1G) because this is the maximum size that can be handled by Kafka.
# If binlog is disabled or binlog is enabled without Kafka, this value should be less than 10737418240(10G).
txn-total-size-limit = 104857600

# The limitation of the size in byte for each entry in one transaction.
# NOTE: Increasing this limit may cause performance problems.
txn-entry-size-limit = 6291456

# The max number of running concurrency two phase committer request for an ALLEGROALLEGROSQL.
committer-concurrency = 16

# max lifetime of transaction ttl manager.
max-txn-ttl = 3600000

# the interval duration between two memory profile into global tracker
mem-profile-interval = "1m"

[proxy-protocol]
# PROXY protocol accepblock client networks.
# Empty string means disable PROXY protocol, * means all networks.
networks = ""

# PROXY protocol header read timeout, unit is second
header-timeout = 5

[prepared-plan-cache]
enabled = false
capacity = 100
memory-guard-ratio = 0.1

[opentracing]
# Enable opentracing.
enable = false

# Whether to enable the rpc metrics.
rpc-metrics = false

[opentracing.sampler]
# Type specifies the type of the sampler: const, probabilistic, rateLimiting, or remote
type = "const"

# Param is a value passed to the sampler.
# Valid values for Param field are:
# - for "const" sampler, 0 or 1 for always false/true respectively
# - for "probabilistic" sampler, a probability between 0 and 1
# - for "rateLimiting" sampler, the number of spans per second
# - for "remote" sampler, param is the same as for "probabilistic"
# and indicates the initial sampling rate before the actual one
# is received from the mothership
param = 1.0

# SamplingServerURL is the address of jaeger-agent's HTTP sampling server
sampling-server-url = ""

# MaxOperations is the maximum number of operations that the sampler
# will keep track of. If an operation is not tracked, a default probabilistic
# sampler will be used rather than the per operation specific sampler.
max-operations = 0

# SamplingRefreshInterval controls how often the remotely controlled sampler will poll
# jaeger-agent for the appropriate sampling strategy.
sampling-refresh-interval = 0

[opentracing.reporter]
# QueueSize controls how many spans the reporter can keep in memory before it starts dropping
# new spans. The queue is continuously drained by a background go-routine, as fast as spans
# can be sent out of process.
queue-size = 0

# BufferFlushInterval controls how often the buffer is force-flushed, even if it's not full.
# It is generally not useful, as it only matters for very low traffic services.
buffer-flush-interval = 0

# LogSpans, when true, enables LoggingReporter that runs in parallel with the main reporter
# and logs all submitted spans. Main Configuration.Logger must be initialized in the code
# for this option to have any effect.
log-spans = false

#  LocalAgentHostPort instructs reporter to send spans to jaeger-agent at this address
local-agent-host-port = ""

[einsteindb-client]
# Max gRPC connections that will be established with each einsteindb-server.
grpc-connection-count = 4

# After a duration of this time in seconds if the client doesn't see any activity it pings
# the server to see if the transport is still alive.
grpc-keepalive-time = 10

# After having pinged for keepalive check, the client waits for a duration of Timeout in seconds
# 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.
commit-timeout = "41s"

# Enable async commit for all transactions.
enable-async-commit = false
# The maximum allowed keys in a async commit transaction. Transactions with more keys than the limit
# will be committed with normal 2PC way.
async-commit-keys-limit = 256

# Max batch size in gRPC.
max-batch-size = 128
# Overload threshold of EinsteinDB.
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

# Enable chunk encoded data for interlock requests.
enable-chunk-rpc = true

# If a Region has not been accessed for more than the given duration (in seconds), it
# will be reloaded from the FIDel.
region-cache-ttl = 600

# causetstore-limit is used to restrain MilevaDB from sending request to some stores which is up to the limit.
# If a causetstore has been up to the limit, it will return error for the successive request in same causetstore.
# default 0 means shutting off causetstore limit.
causetstore-limit = 0

# causetstore-liveness-timeout is used to control timeout for causetstore liveness after sending request failed.
causetstore-liveness-timeout = "5s"

# ttl-refreshed-txn-size decides whether a transaction should uFIDelate its dagger TTL.
# If the size(in byte) of a transaction is large than `ttl-refreshed-txn-size`, it uFIDelate the dagger TTL during the 2PC.
ttl-refreshed-txn-size = 33554432

[einsteindb-client.copr-cache]
# Whether to enable the copr cache. The copr cache saves the result from EinsteinDB Coprocessor in the memory and
# reuses the result when corresponding data in EinsteinDB is unchanged, on a region basis.
enable = true

# The capacity in MB of the cache.
capacity-mb = 1000.0

# Only cache requests whose result set is small.
admission-max-result-mb = 10.0
# Only cache requests takes noblock time to process.
admission-min-process-ms = 5

[binlog]
# enable to write binlog.
# NOTE: If binlog is enabled with Kafka (e.g. arbiter cluster),
# txn-total-size-limit should be less than 1073741824(1G) because this is the maximum size that can be handled by Kafka.
enable = false

# WriteTimeout specifies how long it will wait for writing binlog to pump.
write-timeout = "15s"

# If IgnoreError is true, when writing binlog meets error, MilevaDB would stop writing binlog,
# but still provide service.
ignore-error = false

# use socket file to write binlog, for compatible with kafka version milevadb-binlog.
binlog-socket = ""

# the strategy for sending binlog to pump, value can be "range" or "hash" now.
strategy = "range"

[pessimistic-txn]
# max retry count for a memex in a pessimistic transaction.
max-retry-count = 256

[stmt-summary]
# enable memex summary.
enable = true

# enable memex summary for MilevaDB internal query, default is false.
enable-internal-query = false

# max number of memexs kept in memory.
max-stmt-count = 200

# max length of displayed normalized allegrosql and sample allegrosql.
max-allegrosql-length = 4096

# the refresh interval of memex summary, it's counted in seconds.
refresh-interval = 1800

# the maximum history size of memex summary.
history-size = 24

# experimental section controls the features that are still experimental: their semantics,
# interfaces are subject to change, using these features in the production environment is not recommended.
[experimental]

# server level isolation read by engines and labels
[isolation-read]
# engines means allow the milevadb server read data from which types of engines. options: "einsteindb", "tiflash", "milevadb".
engines = ["einsteindb", "tiflash", "milevadb"]