Slow query diagnosis with root cause analysis and index optimization recommendations. Identifies TOP N slow queries, analyzes scan efficiency, calculates index hit rate, and suggests covering indexes โ turning a 20-minute manual diagnosis into 8 seconds.
Replication lag root cause analysis with automated resolution workflow. Detects lag, identifies blocking queries on the master, presents KILL candidates with safety classification, and executes KILL only after double user confirmation. Reduces recovery from 20 minutes to 2 minutes.
Full-chain MySQL deadlock analysis. Captures InnoDB status, parses lock chains, identifies deadlock patterns (AB-BA / Gap Lock / FK), finds current lock waits and long transactions, outputs structured report with fix recommendations. Supports MySQL 5.7+ performance_schema and 5.6 compatibility mode.
Comprehensive TiDB cluster inspection. Checks cluster topology, node health, slow queries, hot regions, TiKV storage status, PD scheduling, leader skew, and TopSQL drain (latency / execution count / memory). Outputs a full inspection report with prioritized findings. Compatible with TiDB v4.0+.
ๅฏน่ฟ็จๅคๅฎไพMySQLๆฐๆฎๅบๆง่กๅ จๆนไฝๆทฑๅบฆๅทกๆฃ๏ผ่ฆ็ๅบ็กๅฅๅบทใ่ฟๆฅ่ด่ฝฝใๆง่ฝๆ ขๆฅ่ฏขใ็ดขๅผๅไฝใไธปไปๅคๅถใๅฎน้็ฉบ้ดใ่ดฆๅทๅฎๅ จใ้ ็ฝฎ้ฃ้ฉๅ ซๅคง็ปดๅบฆ๏ผๅ จ่ชๅจๅฎๆๅทกๆฃๆซๆใ้ฃ้ฉ่ฏๅซใ้ฎ้ขๅฎ็บงใไผๅๅปบ่ฎฎใๆฅๅๅฝๆกฃไธ้ฃไนฆๆจ้๏ผ้็จไบ็ไบง/ๆต่ฏๆๆ่ฟ่กไธญMySQLๅฎไพๅธธๆๅๅ่งๅทกๆฃใ้็จๅบๆฏ๏ผ็จๆท่ฆๆฑ่ฟ่ก MySQL ๅ จ้พ่ทฏๅฅๅบทๆฃๆฅใMySQL ็ปผๅๅทกๆฃใMySQL ้ฃ้ฉๆซๆใMySQL ๆง่ฝๅฎก่ฎกใMySQL ไธปไป็ถๆๆ ธๆฅใMySQL ๅฎๅ จๆฃๆต๏ผๅนถ็ๆ MySQL ๅ จ้ๅทกๆฃๆฅๅๆถไฝฟ็จใ
Linux ไธ็ฝ็ป่ฎพๅคๅช่ฏปๅฅๅบทๅทกๆฃ๏ผ็ดๆฅ่ฟ่ก scripts/patrol.sh๏ผ้ ็ฝฎ็ฑๅนณๅฐไพงไฟก้ๆณจๅ ฅ๏ผAgent ไธ่ฏปๅ็ฏๅขๅ้
ๅๆๅพฎไฟกๅ ฌไผๅทๅๅฐๆฐๆฎ๏ผๅ ๆฌๆ็ซ ้ ่ฏป้ใ่ฏ่ฎบใ็น่ต็ญ็ป่ฎกใๅฝ็จๆท้่ฆๅๆๅพฎไฟกๅ ฌไผๅทๆฐๆฎใๅฏผๅบๅ ฌไผๅทๆ็ซ ็ป่ฎกๆฅ่กจๆถ่ฐ็จๆญคๆ่ฝใ
็จไธไธคๅฅ่ฏ่ฏดๆๅจไปไนๅบๆฏไธๅฟ ้กปๅ ่ฝฝๆฌๆ่ฝ๏ผ่งฆๅๆกไปถ๏ผใ