Question

sys 数据库 对外显示通常只有一张表 sys_config

mysql> select * from sys.sys_config;
+--------------------------------------+-------+---------------------+--------+
| variable                             | value | set_time            | set_by |
+--------------------------------------+-------+---------------------+--------+
| diagnostics.allow_i_s_tables         | OFF   | 2021-07-28 03:18:32 | NULL   |
| diagnostics.include_raw              | OFF   | 2021-07-28 03:18:32 | NULL   |
| ps_thread_trx_info.max_length        | 65535 | 2021-07-28 03:18:32 | NULL   |
| statement_performance_analyzer.limit | 100   | 2021-07-28 03:18:32 | NULL   |
| statement_performance_analyzer.view  | NULL  | 2021-07-28 03:18:32 | NULL   |
| statement_truncate_len               | 64    | 2021-07-28 03:18:32 | NULL   |
+--------------------------------------+-------+---------------------+--------+
6 rows in set (0.01 sec)

本章参考

[1]. https://dev.mysql.com/doc/refman/8.0/en/

[2]. https://dev.mysql.com/doc/refman/8.0/en/information-schema.html

[3]. https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html

[4]. https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html

[5]. MySQL5.6 PERFORMANCE_SCHEMA 说明 https://www.cnblogs.com/zhoujinyi/p/5236705.html