Parameter Configuration
This article will explain how to modify the parameters of the TiDB instance through the console.
Enter the Management Page
Find the corresponding instance on the product homepage, and click the “Details” button to enter the details page.
View
Switch to the “Parameter Configuration” panel, all parameters and current configurations will be automatically listed
Modification
Enter the parameter you want to modify in the input box of the parameter value column in the parameter list, and click submit
Parameter List
| Parameter Name | Default Value | Range | Need to Restart | Parameter Description |
|---|---|---|---|---|
| proxysql_mysql-max_connections | 2048 | 1 ~ 1000000 | No | Total maximum connections for all users |
| proxysql_max_connections | 10000 | 1 ~ 100000 | No | Maximum connections per user |
| tidb_gc | 10m0s | [10m - 720h] | No | tikv_gc_life_time |
| tidb_txn-total-size-limit | 104857600 | [104857600 - 1099511627776] | Yes | txn-total-size-limit |
| tidb_max-index-length | 3072 | [3072 - 12288] | Yes | max-index-length |