Does TiDB currently support full-text indexing and is there a plan for it?

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiDB当前是否支持全文索引以及是否有规划

| username: 数据源的TiDB学习之路

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version] 7.5.0
[Reproduction Path] None
[Encountered Problem: Problem Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Logs/Monitoring]

2
| username: TiDBer_QYr0vohO | Original post link

Not supported for now, but it might be in the future. Support FULLTEXT search · Issue #1793 · pingcap/tidb · GitHub

3
| username: 源de爸 | Original post link

Not supported for now. We used MySQL before, but we rarely used it.

4
| username: 芝士改变命运 | Original post link

This is rarely used.

5
| username: DBAER | Original post link

What scenarios require full-text indexing?

6
| username: 数据源的TiDB学习之路 | Original post link

I just want to organize the indexes supported by TiDB.

7
| username: xfworld | Original post link

This is obviously not TiDB’s strong suit; ES would be more reliable…

8
| username: TiDBer_嘎嘣脆 | Original post link

Currently, no. Full-text indexing is meaningless for TiDB.

9
| username: stephanie | Original post link

Full-text search might be more suitable with ES. I just happened to see an article today about using TiDB in combination with ES for full-text search.
Embracing Elasticsearch: Giving TiDB the Wings of Full-Text Search | PingCAP

10
| username: xiaoqiao | Original post link

I haven’t heard of any plans for this, and it’s rarely used in MySQL, right? Wouldn’t something like Elasticsearch be better for your scenario?

11
| username: zhaokede | Original post link

Full-text indexing depends on the business scenario.

12
| username: zhang_2023 | Original post link

It is not supported at the moment.

13
| username: 友利奈绪 | Original post link

It seems I didn’t notice this.

14
| username: 呢莫不爱吃鱼 | Original post link

It is not supported, right?

15
| username: Hacker_PtIIxHC1 | Original post link

You can consider using ES search for full-text indexing.

16
| username: 有猫万事足 | Original post link

It’s not in the current roadmap.

17
| username: TIDB-Learner | Original post link

Full-text search seems cumbersome. Will TiDB support it in the future?

18
| username: TiDBer_HErMeXDz | Original post link

You can use ES…

19
| username: zhanggame1 | Original post link

There are no plans; what everyone is calling for more is custom functions or something like that.

20
| username: 呢莫不爱吃鱼 | Original post link

Not very meaningful, right?