TiDB takes too long to delete a database

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

Original topic: tidb删除数据库时间过长

| username: TiDBer_ai1s9Gz4

[Test Environment for TiDB] Testing environment
[Encountered Issue: Phenomenon and Impact] Using sysbench for stress testing, it is particularly slow to delete the database after completion.
There are a total of 16 tables, each with 10 million rows of data.
drop database sbtest
I would like to ask what could be the reason for this?
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]


| username: Lucien-卢西恩 | Original post link

Is the test environment configuration relatively low? The execution time might be longer because TiKV is handling delete operations and the GC can’t keep up. You can check the resource load and thread bottlenecks.

| username: TiDBer_ai1s9Gz4 | Original post link

I would like to ask where to check the resource load and thread bottleneck. It’s my first time using it, so I’m not quite sure…

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

Is it also slow to delete a single table?

| username: TiDBer_ai1s9Gz4 | Original post link

Yes, but the query is still quite fast.

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

Then there might be some issues with your IO writing.

| username: TiDBer_ai1s9Gz4 | Original post link

So, which parameters are related to this, and where can I find them?