rfcs icon indicating copy to clipboard operation
rfcs copied to clipboard

Published 20 hours ago • verified publisher icon tikv

Integer Shard Index

Open TonsnakeLin opened this issue 3 years ago • 4 comments

Signed-off-by: TonsnakeLin [email protected] Hot index reduces the write scalability of the TiDB cluster when the written data is monotonically increasing. We find out a proposal to solve the problem that is using an expression index to scatter the hot index, the new expression index is called a shard index.

TonsnakeLin avatar Dec 27 '21 12:12 TonsnakeLin

@cfzjywxk @youjiali1995 @zhangjinpeng1987 @you06 @tiancaiamao

TonsnakeLin avatar Dec 27 '21 12:12 TonsnakeLin

@TonsnakeLin Please move this design to https://github.com/pingcap/tidb/tree/master/docs/design

zhangjinpeng87 avatar Jan 03 '22 09:01 zhangjinpeng87

don't use Chinese in the benchmark result picture.

siddontang avatar Jan 17 '22 01:01 siddontang

This looks like a simple version of GLOBAL INDEX for a hash partitioned global index. Are there any plans on extending it to fully support GLOBAL INDEX? So it supports any type of index, both partitioned and non-partitioned tables, and also support to partition the index by either HASH or RANGE ?

There is already an implementation of GLOBAL INDEX in TiDB, but it is only experimental and I don't think it is maintained. Some links in this issue.

mjonss avatar Feb 21 '22 00:02 mjonss