ITPUB

Jun 11, 2022 · Databases

How Meituan Optimized a Non‑Intrusive MySQL Packet Capture for Full‑SQL Auditing

This article explains Meituan's non‑intrusive, Go‑based packet‑capture solution for full‑SQL database auditing, details the performance challenges encountered at high QPS, and describes a series of systematic analyses and optimizations—including probe redesign, CPU profiling, data‑masking, scheduling, GC pressure reduction, and packet filtering—that dramatically lowered loss rates and CPU usage.