TiDB System Parameter Comparison Tool

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

Original topic: tidb系统参数对比工具

| username: ShawnYan

Are there any other tools besides tidba that can compare the differences in parameters between different versions of TiDB?

| username: 大飞哥online | Original post link

There should be no command that can directly compare parameter differences, right?

| username: 大飞哥online | Original post link

Show both sides and use the Beyond Compare tool to compare.

| username: TiDBer_小阿飞 | Original post link

Query it and then compare it with BC.

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

Based on past experience, it has always been relying on my own eyes to see…

| username: 路在何chu | Original post link

I mostly keep the TiDB parameters at their default settings and only adjust them when performance issues arise. Unlike MySQL, which requires optimization right after installation.

| username: ShawnYan | Original post link

Which tables or files are you looking at?

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

Global system variables table mysql.GLOBAL_VARIABLES

| username: xingzhenxiang | Original post link

You can view the configuration file information.

| username: 大飞哥online | Original post link

Hahaha, it seems like we’ve both experienced the vicissitudes of life, relying solely on our eyes to see.

| username: Kongdom | Original post link

Soaring to the skies and diving to the depths, only TiDBA can achieve this.

| username: 大飞哥online | Original post link

Lower couplet: :face_with_peeking_eye:

| username: 啦啦啦啦啦 | Original post link

Actually, if you have time, you can write one yourself. Comparing parameters is not very complicated.

| username: zhanggame1 | Original post link

Comparing is not troublesome; the troublesome part is needing both versions of the repository.

| username: Kongdom | Original post link

A left join + a right join, done. :yum:

| username: ShawnYan | Original post link

I am still looking forward to having a web-based comparison tool, so that multiple versions can be compared simultaneously.

| username: zhanggame1 | Original post link

You can suggest that TiDB support full join.

| username: 人如其名 | Original post link

A temporary workaround is to put the variable and config parameters into a table and use set difference operations to see the differences between different versions. The attachment contains parameters for three LTS versions: 6.1, 6.5, and 71. You can import it into the database using mysql -hxxx -p <config.sql and then use set difference operations to compare them. This should suffice for now.

| username: 人如其名 | Original post link

There is also a comparison of monitoring metrics. There are too many metrics in Prometheus, and it is not easy to track changes in each version.

| username: heiwandou | Original post link

It seems there is no such tool.