changing @@tidb_schema_cache_size to 0, TableByName miss rate 100% #59949
Labels
affects-8.5
This bug affects the 8.5.x(LTS) versions.
severity/minor
sig/sql-infra
SIG: SQL Infra
type/bug
The issue is confirmed as a bug.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
Run some workload like sysbench point get.
First, the @@tidb_schema_cache_size = 512M, the default value.
Change it to 0, check the schema cache hit rate.
2. What did you expect to see? (Required)
Hit rate near 100% or no data (infoschema v2 not used)
3. What did you see instead (Required)
Run sysbench_point_get with @@tidb_schema_cache_size = 512M
Set @@tidb_schema_cache_size = 0
Run sysbench_point_get again, the hit rate is nearly 0.
4. What is your TiDB version? (Required)
master e6b4d95
The text was updated successfully, but these errors were encountered: