Does TiDB table have a high watermark?

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

Original topic: tidb表有高水位嘛?

| username: 近墨者zyl

Does TiDB have a high watermark similar to Oracle? Delete cannot lower the high watermark; only truncate and drop can reclaim it.
My understanding: delete, truncate, and drop will all cause empty regions, and empty regions will merge. There shouldn’t be a concept of a high watermark, but I’m not sure. Asking for input from the experts.

| username: tomsence | Original post link

There is no concept of high and low water levels.

| username: h5n1 | Original post link

There is no high watermark, but the MVCC data is still affected.

| username: xfworld | Original post link

No, there is only the concept of health…

You can monitor the health of the table, and the status of the region can also be observed.

| username: system | Original post link

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