星辰考古：TiDB v1.0 再回首

[root@shawnyan ~]# mysql -uroot -P4000 -h127.1 --default-character-set=utf8 --prompt='tidb> 'Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 5Server version: 5.7.1-TiDB-v1.0.8-1-gaacba4a MySQL Community Server (Apache License 2.0)
Copyright (c) 2000, 2024, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
tidb> \s--------------mysql  Ver 8.4.0 for Linux on x86_64 (MySQL Community Server - GPL)
Connection id:  5Current database: Current user:  root@127.0.0.1SSL:   Not in useCurrent pager:  stdoutUsing outfile:  ''Using delimiter: ;Server version:  5.7.1-TiDB-v1.0.8-1-gaacba4a MySQL Community Server (Apache License 2.0)Protocol version: 10Connection:  127.1 via TCP/IPServer characterset: latin1Db     characterset: latin1Client characterset: utf8Conn.  characterset: utf8TCP port:  4000Binary data as:  Hexadecimal--------------
tidb> select version();+------------------------------+| version()                    |+------------------------------+| 5.7.1-TiDB-v1.0.8-1-gaacba4a |+------------------------------+1 row in set (0.00 sec)
tidb> select tidb_version()\G*************************** 1. row ***************************tidb_version(): Release Version: v1.0.8-1-gaacba4aGit Commit Hash: aacba4a427f6c1dd64cd581e1f888e00aa64e948Git Branch: release-1.0UTC Build Time: 2018-02-11 12:21:591 row in set (0.01 sec)
tidb> select * from mysql.tidb;+-----------------------+-------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------+| VARIABLE_NAME         | VARIABLE_VALUE                                                                            | COMMENT                                                                                |+-----------------------+-------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------+| bootstrapped          | True                                                                                      | Bootstrap flag. Do not delete.                                                         || tidb_server_version   | 15                                                                                        | Bootstrap version. Do not delete.                                                      || tikv_gc_leader_uuid   | 63d1e883d100006                                                                           | Current GC worker leader UUID. (DO NOT EDIT)                                           || tikv_gc_leader_desc   | host:shawnyan, pid:22873, start at 2024-05-05 15:22:34.205171361 +0800 CST m=+1.715160561 | Host name and pid of current GC leader. (DO NOT EDIT)                                  || tikv_gc_leader_lease  | 20240505-15:36:34 +0800 CST                                                               | Current GC worker leader lease. (DO NOT EDIT)                                          || tikv_gc_run_interval  | 10m0s                                                                                     | GC run interval, at least 10m, in Go format.                                           || tikv_gc_life_time     | 10m0s                                                                                     | All versions within life time will not be collected by GC, at least 10m, in Go format. || tikv_gc_last_run_time | 20240505-15:32:34 +0800 CST                                                               | The time when last GC starts. (DO NOT EDIT)                                            || tikv_gc_safe_point    | 20240505-15:22:34 +0800 CST                                                               | All versions after safe point can be accessed. (DO NOT EDIT)                           || tikv_gc_concurrency   | 1                                                                                         | How many go routines used to do GC parallel, [1, 128], default 1                       |+-----------------------+-------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------+10 rows in set (0.01 sec)
tidb> select count(*) from mysql.GLOBAL_VARIABLES;+----------+| count(*) |+----------+|      498 |+----------+1 row in set (0.00 sec)
tidb> select * from mysql.GLOBAL_VARIABLES where VARIABLE_NAME like 'tidb%';+------------------------------------+----------------+| VARIABLE_NAME                      | VARIABLE_VALUE |+------------------------------------+----------------+| tidb_max_row_count_for_inlj        | 128            || tidb_index_lookup_size             | 20000          || tidb_distsql_scan_concurrency      | 10             || tidb_index_join_batch_size         | 25000          || tidb_index_serial_scan_concurrency | 1              || tidb_skip_utf8_check               | 0              || tidb_index_lookup_concurrency      | 4              |+------------------------------------+----------------+7 rows in set (0.01 sec)

[root@shawnyan bin]# echo "config show" | ./pd-ctl {  "max-snapshot-count": 3,  "max-store-down-time": "1h0m0s",  "leader-schedule-limit": 64,  "region-schedule-limit": 12,  "replica-schedule-limit": 16,  "schedulers-v2": [    {      "type": "balance-region",      "args": null    },    {      "type": "balance-leader",      "args": null    },    {      "type": "hot-region",      "args": null    }  ]}