# Information Schema INNODB\_FT\_CONFIG Table

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `INNODB_FT_CONFIG` table contains InnoDB [fulltext index](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes) metadata.

The `SUPER` [privilege](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant) is required to view the table, and it also requires the [innodb\_ft\_aux\_table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) system variable to be set.

It has the following columns:

| Column | Description         |
| ------ | ------------------- |
| KEY    | Metadata item name. |
| VALUE  | Associated value.   |

## Example

```sql
SELECT * FROM INNODB_FT_CONFIG;
+---------------------------+-------+
| KEY                       | VALUE |
+---------------------------+-------+
| optimize_checkpoint_limit | 180   |
| synced_doc_id             | 6     |
| last_optimized_word       |       |
| deleted_doc_count         | 0     |
| total_word_count          |       |
| optimize_start_time       |       |
| optimize_end_time         |       |
| stopword_table_name       |       |
| use_stopword              | 1     |
| table_state               | 0     |
+---------------------------+-------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}