[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 5 Server 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 its affiliates. Other names may be trademarks of their respective owners.
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: 5 Current database: Current user: root@127.0.0.1 SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.7.1-TiDB-v1.0.8-1-gaacba4a MySQL Community Server (Apache License 2.0) Protocol version: 10 Connection: 127.1 via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 TCP port: 4000 Binary 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-gaacba4a Git Commit Hash: aacba4a427f6c1dd64cd581e1f888e00aa64e948 Git Branch: release-1.0 UTC Build Time: 2018-02-11 12:21:59 1 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)
