SHOW INDEX SETTINGS

SHOW INDEX SETTINGS is an SQL statement that displays per-index settings in a format that is compatible with the config file.

The syntax is:

SHOW INDEX index_name[.N | CHUNK N] SETTINGS

Output is similar to the –dumpconfig option of the indextool utility. The report provides a breakdown of all the index settings, including tokenizer and dictionary options.

SQL:
SHOW INDEX 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)

You may also specify a particular chunk number to view the settings of a particular chunk of an RT index. The number is 0-based.

SQL:
SHOW INDEX 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)