The TiDB configuration file supports more options than command line options. You can download the default configuration file
config.toml.example and rename it to
config.toml. This document describes only the options that are not involved in command line options.
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
utf8mb4character. If it is enabled and the character set is
utf8, an error occurs when the
mb4character is inserted into
utf8character set in the old table as a switch for
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.
stmt-count-limit, TiDB returns the
statement count 5001 exceeds the transaction limitation, autocommit = falseerror.
keepalivein the TCP layer
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
20 * 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
200 * stats-lease, TiDB writes the feedback cached in the memory to the system table
5 * stats-lease, TiDB reads the feedback in the system table, and updates the statistics
stats-leaseis set to 0, all of the above operations are skipped.
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.
TiDB Binlog related configuration.
trueand an error occurs, TiDB stops writing binlog and add
1to the count of the
tidb_server_critical_error_totalmonitoring item. When the value is set to
false, the binlog writing fails and the entire TiDB service is stopped.