Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

refine information schema cache #48285

Closed
crazycs520 opened this issue Nov 3, 2023 · 0 comments · Fixed by #48284
Closed

refine information schema cache #48285

crazycs520 opened this issue Nov 3, 2023 · 0 comments · Fixed by #48284
Assignees
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@crazycs520
Copy link
Contributor

crazycs520 commented Nov 3, 2023

Enhancement

workload: stale read, with tidb_read_staleness=-60;

 sysbench --config-file=sysbench.conf stale_read.lua --threads=20 --read_staleness=-60 --kv_read_timeout=100 --max_execution_time=400 --mysql-ignore-errors=all run

When TiDB domain load schema meets following error:

[2023/11/03 18:29:30.023 +08:00] [WARN] [domain.go:196] ["failed to get schema version"] [error="There is no Write MVCC info for the schema version"] [version=2410] [startTS=445384588003639307]

The QPS will droped cause by information schema cache is missed, then need to load snapshot information schema.

image

This is caused by information schema cache will be invalid since there is a schema version with schemaTs=0, then infoCache.GetBySnapshotTS will always return nil.

version: v6.5.5

@crazycs520 crazycs520 added the type/enhancement The issue or PR belongs to an enhancement. label Nov 3, 2023
@crazycs520 crazycs520 self-assigned this Nov 3, 2023
ti-chi-bot bot pushed a commit that referenced this issue Nov 6, 2023
ti-chi-bot bot pushed a commit that referenced this issue Nov 7, 2023
crazycs520 added a commit to ti-chi-bot/tidb that referenced this issue May 27, 2024
…formation schema cache (pingcap#48284)

close pingcap#48285

Signed-off-by: crazycs520 <crazycs520@gmail.com>
crazycs520 added a commit to ti-chi-bot/tidb that referenced this issue May 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
1 participant