Does GC affect MVCC?

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

Original topic: gc会影响mvcc吗

| username: 谢斌1204

GC is executed every 10 minutes. I have a transaction that takes 11 minutes to execute. In session 2, at the 10 minute 29 second mark, can I still query historical version data?

| username: TiDBer_jYQINSnf | Original post link

No problem, the data being used by the transaction will not be garbage collected.

| username: caiyfc | Original post link

So generally, if GC is not progressing, it might be because a large transaction is stuck. :joy:

| username: TiDBer_jYQINSnf | Original post link

That’s what it means :grin:

| username: DBAER | Original post link

Learned.

| username: zhaokede | Original post link

Data with locks in transactions is unaffected.

| username: TIDB-Learner | Original post link

The knowledge I learned last year has resurfaced in my mind again.

| username: Kongdom | Original post link

:joy: Painful memories are starting to attack me.

| username: TiDBer_rvITcue9 | Original post link

Data being used by a transaction will not be garbage collected.

| username: kelvin | Original post link

Here to learn.

| username: GreenGuan | Original post link

It won’t be affected.

| username: system | Original post link

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