星辰考古：TiDB v3.x 忆水木

curl -s http://localhost:2379/version

# TiDB v3.0.20{"etcdserver":"3.4.3","etcdcluster":"3.4.0"}
# TiDB v8.1.0{"etcdserver":"3.4.31","etcdcluster":"3.4.0"}

[shawnyan@centos7 ~]$ tiup cluster listName    User  Version  ...----    ----  -------  ...mytidb  tidb  v3.0.20  ...

[shawnyan@centos7 ~]$ mysql -uroot -h127.0.0.1 -P4000Welcome to the MariaDB monitor.  Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.7.25-TiDB-v3.0.20 MySQL Community Server (Apache License 2.0)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> select version(), tidb_version()\G*************************** 1. row ***************************     version(): 5.7.25-TiDB-v3.0.20tidb_version(): Release Version: v3.0.20Git Commit Hash: 9ab0bbf9a012aaf8ae2d3e1eee2a321e03a0d5c1Git Branch: heads/refs/tags/v3.0.20UTC Build Time: 2020-12-25 04:33:21GoVersion: go version go1.13 linux/amd64Race Enabled: falseTiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306Check Table Before Drop: false1 row in set (0.001 sec)

$ curl -s localhost:10080/info | jq{  "is_owner": true,  "version": "5.7.25-TiDB-v3.0.20",  "git_hash": "9ab0bbf9a012aaf8ae2d3e1eee2a321e03a0d5c1",  "ddl_id": "eba21fb1-4c74-4043-be6d-f082ed730794",  "ip": "127.0.0.1",  "listening_port": 4000,  "status_port": 10080,  "lease": "45s",  "binlog_status": "Off"}

SELECT PRIVILEGE_TYPE FROM information_schema.USER_PRIVILEGES WHERE GRANTEE = "'root'@'%'";

-- TiDB 3.0.20SelectInsertUpdateDeleteCreateDropProcessReferencesAlterShow DatabasesSuperExecuteIndexCreate UserTriggerCreate ViewShow ViewCreate RoleDrop RoleCREATE TEMPORARY TABLESLOCK TABLESCREATE ROUTINEALTER ROUTINEEVENTSHUTDOWN
-- TiDB 8.1.0CREATE TABLESPACERELOADFILECONFIGREPLICATION CLIENTREPLICATION SLAVE

-- TiDB 3.0.20MySQL [(none)]> select * from information_schema.processlist;+------+------+-----------+------+---------+------+-------+----------------------------------------------+------+----------+| ID   | USER | HOST      | DB   | COMMAND | TIME | STATE | INFO                                         | MEM  | TxnStart |+------+------+-----------+------+---------+------+-------+----------------------------------------------+------+----------+|   15 | root | 127.0.0.1 | NULL | Query   |    0 | 2     | select * from information_schema.processlist |    0 |          |+------+------+-----------+------+---------+------+-------+----------------------------------------------+------+----------+1 row in set (0.003 sec)
-- TiDB 8.1.0MySQL [(none)]> select * from information_schema.processlist;+------------+------+-----------------+------+---------+------+------------+--------...+----------...+------+------+----------+----------------+---------------+| ID         | USER | HOST            | DB   | COMMAND | TIME | STATE      | INFO   ...| DIGEST   ...| MEM  | DISK | TxnStart | RESOURCE_GROUP | SESSION_ALIAS |+------------+------+-----------------+------+---------+------+------------+--------...+----------...+------+------+----------+----------------+---------------+| 3305111560 | root | 127.0.0.1:19364 | NULL | Query   |    0 | autocommit | select ...| 4b5e7cdd5...|    0 |    0 |          | default        |               |+------------+------+-----------------+------+---------+------+------------+--------...+----------...+------+------+----------+----------------+---------------+1 row in set (0.001 sec)

-- TiDB 3.0.20MySQL [mysql]> select count(*) from mysql.GLOBAL_VARIABLES;+----------+| count(*) |+----------+|      531 |+----------+1 row in set (0.002 sec)
MySQL [(none)]> select * from mysql.GLOBAL_VARIABLES where VARIABLE_NAME like 'tidb_%';+------------------------------------+----------------+| VARIABLE_NAME                      | VARIABLE_VALUE |+------------------------------------+----------------+| tidb_hash_join_concurrency         | 5              || tidb_stmt_summary_history_size     | 24             || tidb_txn_mode                      | pessimistic    || tidb_stmt_summary_refresh_interval | 1800           || tidb_union_concurrency             | 4              || tidb_hashagg_final_concurrency     | 4              || tidb_build_stats_concurrency       | 4              || tidb_opt_correlation_exp_factor    | 1              || tidb_index_lookup_join_concurrency | 4              || tidb_enable_table_partition        | auto           || tidb_index_join_batch_size         | 25000          || tidb_store_limit                   | 0              || tidb_init_chunk_size               | 32             || tidb_opt_join_reorder_threshold    | 0              || tidb_opt_correlation_threshold     | 0.9            || tidb_hashagg_partial_concurrency   | 4              || tidb_ddl_reorg_worker_cnt          | 4              || tidb_max_delta_schema_count        | 1024           || tidb_max_chunk_size                | 1024           || tidb_projection_concurrency        | 4              || tidb_disable_txn_auto_retry        | 1              || tidb_constraint_check_in_place     | 0              || tidb_auto_analyze_start_time       | 00:00 +0000    || tidb_enable_cascades_planner       | 0              || tidb_backoff_lock_fast             | 100            || tidb_index_lookup_concurrency      | 4              || tidb_enable_stmt_summary           | 0              || tidb_auto_analyze_end_time         | 23:59 +0000    || tidb_opt_insubq_to_join_and_agg    | 1              || tidb_skip_isolation_level_check    | 0              || tidb_enable_window_function        | 1              || tidb_retry_limit                   | 10             || tidb_scatter_region                | 0              || tidb_index_serial_scan_concurrency | 1              || tidb_index_lookup_size             | 20000          || tidb_auto_analyze_ratio            | 0.5            || tidb_distsql_scan_concurrency      | 15             || tidb_enable_fast_analyze           | 0              || tidb_backoff_weight                | 2              || tidb_skip_utf8_check               | 0              || tidb_ddl_reorg_batch_size          | 256            || tidb_ddl_error_count_limit         | 512            |+------------------------------------+----------------+42 rows in set (0.002 sec)

>   "cors": "",>     "disable-error-stack": true,>     "record-plan-in-slow-log": 1>     "require-secure-transport": false,>     "cluster-verify-cn": null>     "status-host": "0.0.0.0",>     "record-db-qps": false>     "max-memory": 0,<     "enable-update-stats": true,>     "bind-info-lease": "3s",>     "memory-guard-ratio": 0.1>     "max-batch-size": 128,>     "overload-threshold": 200,>     "max-batch-wait-time": 0,>     "batch-wait-size": 8,>     "region-cache-ttl": 600,>     "store-limit": 0>     "strategy": "range">   "pessimistic-txn": {>     "enable": true,>     "max-retry-count": 256>   "max-index-length": 3072,>   "alter-primary-key": false,>   "stmt-summary": {>     "enable": false,>     "max-stmt-count": 200,>     "max-sql-length": 4096,>     "refresh-interval": 1800,>     "history-size": 24>   "enable-table-lock": false,>   "delay-clean-table-lock": 0