Questions about choosing TiDB types

Translated
1

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

Original topic: 提问关于tidb类型的选择

| username: tidb狂热爱好者

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
7.5
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]

image
image1380×196 16.3 KB

We are using AWS hosts.
I noticed that their KV selected EBS with a speed limit of 120MB for 3 TiKV. If there are a lot of read and write operations, will the speed be throttled?

2
| username: 啦啦啦啦啦 | Original post link

It feels too low for TiKV.

3
| username: TiDBer_jYQINSnf | Original post link

This speed is like a mechanical hard drive.

4
| username: tidb狂热爱好者 | Original post link

The mechanical disk has a write speed of 250MB/s.

5
| username: TiDBer_jYQINSnf | Original post link

Not even as good as a mechanical drive :grin:

6
| username: zhaokede | Original post link

This configuration cannot bring out the performance of the database.

7
| username: zhanggame1 | Original post link

If the TiKV memory is large enough, it should be able to manage.

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

If you don’t use high-performance disks for TiKV nodes in TiDB, it will be very problematic later on…

9
| username: 小毛毛虫 | Original post link

In a production environment, TiKV machines should all be NVMe, right? If it’s a small system with low concurrency, just use a regular MySQL.

10
| username: dba远航 | Original post link

Performance is even worse than a mechanical disk, probably fatal.

11
| username: FutureDB | Original post link

This disk latency configuration is quite eye-catching.

12
| username: redgame | Original post link

Too low.

13
| username: TiDBer_vfJBUcxl | Original post link

Low, poor performance.

14
| username: DBAER | Original post link

This performance definitely won’t cut it, it might even be worse than a laptop.

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

It should be very slow, TiDB has high IO requirements.