The TiDB configuration file supports more options than command line options. You can find the default configuration file in config/config.toml.example and rename it to
This document describes the options that are not involved in command line options. For command line options, see here.
KILLstatement to be MySQL compatible
KILL xxxin TiDB differs from the behavior in MySQL. TiDB requires the
TIDBkeyword, as in
KILL TIDB xxx. If
compatible-kill-queryis set to true, the
TIDBkeyword is not needed.
compatible-kill-queryif you are certain that the connection you refer to in your
KILLstatement is on the same server to which you send the
Configuration about log.
expensiveoperation and outputs log with the
query-log-max-len, the statement is truncated to output
Configuration about security.
--ssl-keyat the same time, TiDB authenticates the client certificate based on the list of trusted CAs specified by this option when the client presents the certificate. If the authentication fails, the connection is terminated.
--ssl-keyat the same time, TiDB allows (but not forces) the client to securely connect to TiDB using TLS
Configuration about performance.
n, and then TiDB uses
stmt-count-limit, TiDB returns the
statement count 5001 exceeds the transaction limitation, autocommit = falseerror.
keepalivein the TCP layer
keyconflict or other errors while committing a transaction
retry-limitbut the transaction still fails, TiDB returns an error
joinstatement without any condition (the
wherefield) of both sides tables by default; if you set the value to false, the server refuses to execute when such a
stats-leasetime, TiDB checks the statistics for updates and updates them to the memory if updates exist
5 * stats-leasetime, TiDB persists the total number of rows generated by DML and the number of modified rows
stats-lease, TiDB checks for tables and indexes that need to be automatically analyzed
stats-lease, TiDB checks for column statistics that need to be loaded to the memory
feedback-probability, to update statistics
The Plan Cache configuration of the
Configuration about the transaction latch. It is recommended to enable it when many local transaction conflicts occur.