Update xx set yy where zz, using table index in the where condition, not using TiFlash

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

Original topic: update xx set yy where zz,where条件使用表索引,不走tiflash

| username: wenyi

The update statement only uses the index on the table and does not go through TiFlash, meaning it can only update based on the index of the table.

| username: TiDBer_pkQ5q1l0 | Original post link

Updates do not go through TiFlash in the first place.

| username: 啦啦啦啦啦 | Original post link

The image is not visible. Please provide the text you need translated.

| username: 胡杨树旁 | Original post link

TiFlash is only responsible for synchronizing data, while data writing mainly occurs on the leader.

| username: tidb菜鸟一只 | Original post link

The data in TiFlash is all replicated from TiKV, so updates definitely do not update the data in TiFlash.

| username: wenyi | Original post link

What I mean is not to update TiFlash data. Before updating, you need to query the records that need to be updated. Why doesn’t the query use TiFlash?
It should be that TiDB only supports select DML statements to use TiFlash, but update does not.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.