林万程
林万程
监控SQL慢
https://github.com/xuxueli/xxl-job/blob/39b92f9db608753650f2285bf70b0279800a560c/xxl-job-admin/src/main/resources/mybatis-mapper/XxlJobLogMapper.xml#L230C1-L240C11 这个SQL在我们自动化部署环境平均执行时间16秒,最高执行时间32秒,看代码每10秒一次, 建议添加组合索引,优化 SQL 以便命中索引: - 去掉 ORDER BY id ASC 避免 MYSQL 走主键索引遍历全表 Using where ```xml SELECT id FROM `xxl_job_log` WHERE !( (trigger_code in (0, 200) and handle_code =...
我微信号:LinWanCen
### What happened? do request failed: Post "http://21.104.14.114:21018/v1/completions": dial tcp 21.104.14.114:21018: connect: connection refused ### Relevant log output or stack trace ```shell ``` ### Steps to reproduce _No response_ ###...