• SHOW TABLE SETTINGS

SHOW TABLE SETTINGS 是一个 SQL 语句，用于以配置文件兼容的格式显示每个表的设置。

语法如下：

SHOW TABLE index_name[.N | CHUNK N] SETTINGS

输出类似于 --dumpconfig 选项中的 indextool 实用程序。报告提供了所有表设置的详细说明，包括分词器和词典选项。

SQL:

SHOW TABLE forum SETTINGS;

+---------------+-----------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                     |
+---------------+-----------------------------------------------------------------------------------------------------------+
| settings      | min_prefix_len = 3
charset_table = 0..9, A..Z->a..z, _, -, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F |
+---------------+-----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

你也可以指定特定的块号以查看实时表中某个特定块的设置。编号从0开始。

SQL:

SHOW TABLE forum CHUNK 0 SETTINGS;

+---------------+-----------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                     |
+---------------+-----------------------------------------------------------------------------------------------------------+
| settings      | min_prefix_len = 3
charset_table = 0..9, A..Z->a..z, _, -, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F |
+---------------+-----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)