Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: tiflash 支持二级索引吗？
|
username: TiDBer_TkoMdI15
Currently, I have only found information about secondary indexes existing in TiKV, but not in TiFlash.
If TiFlash supports secondary indexes, what performance issues might arise?
Refer to:
The data in TiFlash is mainly divided into two parts: Delta and Stable. The Stable data is organized by Packs, with each Pack containing approximately 8192 rows. To ensure the correctness of secondary indexes, data with the same primary key needs to be written into the same Pack during insertion. This ensures the correctness of MVCC when filtering with secondary indexes. For a more detailed explanation, you can look forward to the subsequent source code analysis of the DeltaIndex topic.
[Event Video Replay]: https://www.bilibili.com/video/BV16A4y1X7gy/
[PPT Download]: TiFlash Storage Layer Overview.pdf (877.2 KB)
Not supported, this issue was also discussed a few days ago, refer to this link
TiFlash does not currently support traditional indexes, rough indexes.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
|
username: 
|
username: 
|
username: 
|
username: