偶发缓冲队列过大如何优化 · MyCATApache/Mycat-Server#2861

(1 comment) (0 reactions) (0 assignees)Java (9,451 stars) (3,886 forks)batch import

help wanted

説明

应用层显示调用mycat耗时20s,但是mysql监控无慢sql，sql本身走索引了，直接在数据库查询都是毫秒级别返回。通过mycat-eye监控显示，mycat请求耗时过长的时间点与“Mycat缓冲队列分析”出现峰值的时间点比较吻合。达到100k, 平时都是0 怀疑是队列导致查询总耗时时间过长。这种情况应该如何优化呢。版本是1.67

コントリビューターガイド

技術スタック: javamysql
領域: backenddatabaseperformance
Issue 種別: performance
難度: 4
推定時間: over 1 week
活動状況: stale
明確さ: unclear
前提条件: JavaMycat internalsbuffer queue monitoring
初心者向け度: 20
調査方針: Investigate the buffer queue implementation in Mycat Server source code, focusing on classes related to queuing SQL responses. Examine the Mycat eye monitoring data to correlate queue size peaks with request durations. Look for potential bottlenecks in queue processing, such as blocking operations or insufficient capacity. Check if there are known issues or configuration options that affect queue behavior.