TiDB OOM at 130k table with 8C/16G

[kennedy8312]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

100-1200 tables and 0-5000 partitions per schema, multiple schemas. Scale the table count on a per-database basis.
Using 8C/16G machine.

2. What did you expect to see? (Required)

TiDB could support the scenario of multiple tables/partitions.

3. What did you see instead (Required)

TiDB was OOM at a number of 130k tables.

4. What is your TiDB version? (Required)

| Release Version: v7.6.0-idx
Edition: Community
Git Commit Hash: f06bfd3
Git Branch: heads/refs/tags/v7.6.0-idx
UTC Build Time: 2024-01-08 10:08:10
GoVersion: go1.21.5
Race Enabled: false
Check Table Before Drop: false
Store: tikv |

[kennedy8312]

candidate_1m

[kennedy8312]

/assign zimulala