Does TiDB support placing certain hot tables into a keep cache pool like Oracle?

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

Original topic: tidb支持将某些热表像oracle一样放入keep缓存池吗?

| username: oceanzhang

[Test Environment for TiDB] Testing
[TiDB Version] v7.5
[Reproduction Path]
[Encountered Issue: Issue Phenomenon and Impact] In reality, there is a table with hundreds of thousands of rows that is frequently accessed. Can the entire table be permanently cached in memory?
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]

| username: oceanzhang | Original post link

Is it possible to load the entire table into memory every time it starts? Can it be changed to a memory table?

| username: tidb菜鸟一只 | Original post link

Sure, 缓存表 | PingCAP 文档中心
But the table cannot be frequently modified.

| username: zhanggame1 | Original post link

Small table cache, many limitations

| username: 小龙虾爱大龙虾 | Original post link

Sure, before using it, check the limitations.

| username: andone | Original post link

Small tables less than 64MB that are not frequently updated.

| username: Jolyne | Original post link

Small table caching has size limitations and cannot be frequently modified. You can adjust the lease time according to your needs. If modifications are infrequent, you can extend the lease time.

| username: heiwandou | Original post link

Small table caching has quite a few limitations.

| username: Kongdom | Original post link

Hundreds of thousands of tables don’t seem to satisfy the small table caching scenario. :thinking:

| username: 春风十里 | Original post link

It mainly depends on the table size. If it is less than 64M, you can use small table caching. Hundreds of thousands might be tens of megabytes, which is still possible.

| username: dba远航 | Original post link

It can only be a small table less than 64MB and not frequently updated.

| username: zhanggame1 | Original post link

If there are only a few fields and the data size per row is small, it can still accommodate hundreds of thousands.

| username: system | Original post link

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