系统表介绍
INNODB_FT_CONFIG 记录了全文索引的元数据
| 列名 | 含义 |
|---|---|
| KEY | 键 |
| VALUE | 值 |
实例
mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
+---------------------------+-------------------+
| KEY | VALUE |
+---------------------------+-------------------+
| optimize_checkpoint_limit | 180 |
| synced_doc_id | 0 |
| stopword_table_name | test/my_stopwords |
| use_stopword | 1 |
+---------------------------+-------------------+