Aikesheng Open Source Community

Mar 20, 2020 · Databases

Generating Hourly Slow Query Reports from MySQL Slow Log Using pt-query-digest and termsql

This guide shows how to generate hourly slow‑query reports from MySQL slow‑log files by using pt‑query‑digest’s timeline feature, filtering with sed, importing the data into SQLite with termsql, and then querying the results to identify hotspot periods and recurring patterns.