I would like to ask, how do you set the optimal parameters in a production environment?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 想问下,各位在生产环境中如何设置最优参数

| username: oceanzhang

[TiDB Usage Environment] Production Environment
[TiDB Version] 7.5
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issues: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]

| username: forever | Original post link

Most settings are kept at default, and adjustments are only made when performance issues arise. Unlike MySQL, which requires optimization right after installation.

| username: 小龙虾爱大龙虾 | Original post link

Most of the settings are default. For hybrid deployment, follow the parameters in the official documentation. If you don’t want to use new features, you can disable them. Special parameters for the business should be set according to the business needs. Finally, if you encounter any issues, you can adjust them individually. :joy_cat:

| username: Kongdom | Original post link

:thinking: The best choice is what suits you. There’s no one-size-fits-all solution. You can only optimize your parameters based on your own hardware environment and business situation.

| username: TiDBer_QYr0vohO | Original post link

Just follow the official production deployment documentation and keep the defaults.

| username: DBAER | Original post link

The default values are generally used.

| username: 像风一样的男子 | Original post link

There is no best, only the most suitable. Just use all the default settings for the new setup.

| username: QH琉璃 | Original post link

Adjust gradually based on your own usage.

| username: 随缘天空 | Original post link

In fact, it is difficult to set the optimal parameters because they may be related to machine configuration and the cluster. At the beginning, there is no need to pursue this; just follow the official topology configuration. It is sufficient to optimize the environment before installation. For details, you can refer to the following link: TiDB 环境与系统配置检查 | PingCAP 文档中心

| username: TiDBer_JUi6UvZm | Original post link

I found that the default parameters of TiDB are already optimal. Of course, you still need to check them yourself.

| username: TiDBer_JUi6UvZm | Original post link

Understand it first, then make adjustments.

| username: jiayou64 | Original post link

Discovering problems and solving them.

| username: TIDB-Learner | Original post link

The best is in the heart.

| username: TiDBer_RjzUpGDL | Original post link

Default value.

| username: oceanzhang | Original post link

Are you all using the default settings?

| username: oceanzhang | Original post link

You’re just boosting your score.

| username: oceanzhang | Original post link

You said it without saying anything.

| username: oceanzhang | Original post link

You’re just trying to boost your score, aren’t you?

| username: oceanzhang | Original post link

Is it the same in production???

| username: oceanzhang | Original post link

Is it the same in your production environment?