taosdata/TDengine

Slow insertion several times every day

Open

#24,082 opened on Dec 15, 2023

View on GitHub
 (9 comments) (0 reactions) (0 assignees)C (5,002 forks)batch import
help wanted

Repository metrics

Stars
 (24,849 stars)
PR merge metrics
 (Avg merge 1d 1h) (4 merged PRs in 30d)

Description

Bug Description 每天都有几次的插入慢（超过1秒）的情况，正常的都是几毫秒。请问是什么问题，如何改进？ java日志 ERROR c.a.druid.filter.stat.StatFilter:523 - slow sql 1077 millis. insert into *******

Environment (please complete the following information):

  • OS: Ubutu
  • Memory 8G
  • TDengine Version [e.g. 3.2.0.0]
  • 应用是java的，和TD在同一台电脑，没有集群
  • 用最普通的创建数据库没格外定义参数。用了超级表，子表是按不同传感器不同子表分离。

Contributor guide

Research direction
Investigate slow insertion by examining TDengine server logs, monitoring system resource usage (CPU, memory, disk I/O), and reviewing database schema (especially supertable and child tables). Check if the server is overloaded or if there are configuration issues like improper batch sizes or flush intervals.
Tech stack
c
Domain
databasebackend
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Needs investigation
Prerequisites
CTDengine
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40