Does TiDB support in-memory databases? Similar to Oracle's In-memory

Translated
1

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

Original topic: TiDB是否支持内存数据库？类似Oracle的In-memory

| username: alfred

【TiDB Usage Environment】Production Environment or Test Environment or POC
【TiDB Version】
【Encountered Problem】
【Reproduction Path】What operations were performed that caused the problem
【Problem Phenomenon and Impact】

【Attachments】Relevant logs and monitoring (https://metricstool.pingcap.com/)

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results for upload.

2
| username: h5n1 | Original post link

Not supported, the underlying layer is RocksDB, based on LSM tree.

3
| username: buddyyuan | Original post link

Oracle uses In-Memory, which is columnar storage and can only be based on memory.
TiDB has TiFlash, which is a columnar storage engine based on disk storage and does not have a memory-based one.

4
| username: alfred | Original post link

There are indeed similarities, but it is more memory-efficient.

5
| username: forever | Original post link

Version 6.0 has cached tables. You can check it out at TiDB v6.0.0(DMR) 缓存表初试 | TiDB Books

6
| username: alfred | Original post link

Okay, thank you.

7
| username: system | Original post link

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