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.
MySQLSQLitelog analysis
0 likes · 2 min read