romanticmj

Results 2 issues of romanticmj

**背景** 微服务>50,告警>2w时,经常出现告警延迟,最多时候达到1h以上 **原因分析** SendExcutor每5min拉取一次告警,通过arthas分析,主要是在 m_decoratorManager.generateTitleAndContent 耗时长,发现是其中有一条SQL执行很慢 `SELECT al.id,al.domain,al.alert_time,al.category,al.`type`,al.content,al.metric,al.creation_date FROM alert al WHERE al.alert_time >= ? AND al.alert_time

增加线程的CPU使用率 ![image](https://github.com/huoyo/ko-time/assets/21699352/863debe3-c8e5-406c-8732-ae91ab61f86a)