Query Analyzer Agent

A LinkedIn-built Go agent that captures and analyzes MySQL queries by sniffing the database server's network port, with negligible performance overhead, and aggregates results into a remote MySQL store for review.


About

Query Analyzer Agent runs alongside the database server and captures all queries by sniffing the network interface with libpcap, rather than hooking into MySQL itself, so it adds no measurable overhead to the server it watches. It aggregates queries by hostname and checksum/fingerprint and either writes them to a local log file or sends them to a remote MySQL database — the project ships the schema for a partitioned query_analyzer database with query_info and query_history tables — so results collected from many agents can be reviewed, annotated, and marked reviewed in one place.

Written in Go, it builds on GoPacket for packet capture, Percona’s go-mysql libraries for parsing the MySQL protocol, and Viper for its TOML configuration (the interface, port, and remote-database connection details). LinkedIn describes the motivation and design in its engineering blog post. It’s released under the BSD 2-Clause license.

Category Software & Tools
Subcategory Monitoring & Observability
✎ Suggest an update

Community feedback

This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.