Inserting Data is Particularly Slow

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

Original topic: 插入数据特别慢

| username: TiDBer_xV0VbTdz

www.???.com third-party asdf asdf asdf Jian’an ten years local love you guys just started school download program control v card is so open i oh that is probably Aston scattered fa

| username: Hacker007 | Original post link

It should be an issue with your cluster. Check the logs to see if there are any anomalies.

| username: h5n1 | Original post link

First, check the execution time consumption of this SQL in the dashboard’s slow SQL or SQL analysis.

| username: 濱崎悟空 | Original post link

Need to check the situation in the monitoring.

| username: Jellybean | Original post link

What is the cluster version you are running? My local single-node cluster runs very quickly:

    -> '1111'
    -> );
Query OK, 1 row affected (0.02 sec)

mysql> explain execution
+----------+---------+------+---------------+---------------+
| id       | estRows | task | access object | operator info |
+----------+---------+------+---------------+---------------+
| Insert_1 | N/A     | root |               | N/A           |
+----------+---------+------+---------------+---------------+
1 row in set (0.00 sec)

Please provide the execution plan for this SQL and the slow query details from the Dashboard.

| username: 鱼跃龙门 | Original post link

Which version is it? Check the monitoring logs and slow SQL situation.

| username: FutureDB | Original post link

Check the actual execution plan of this SQL to see specifically where it is slow, and also check the disk write latency in Grafana.

| username: zhaokede | Original post link

Check the execution plan and slow SQL, and see where it is slow.

| username: Kongdom | Original post link

Which version are you using?

| username: 数据库真NB | Original post link

My topic is displayed as garbled text. How are you all able to reply?

| username: 小于同学 | Original post link

How much data?

| username: 濱崎悟空 | Original post link

Need to look at the comprehensive table design and database environment.