MySQL 8 Cookbook

General query log

You can use pt-query-digest to analyze the general query log by passing the argument --type genlog. Since general logs do not report query times, only the count aggregate is shown:

 shell> sudo pt-query-digest --type genlog /var/lib/mysql/db1.log   > general_query_digest

The output will be something like this:

# 400ms user time, 0 system time, 28.84M rss, 99.35M vsz# Current date: Sat Nov 18 09:02:08 2017# Hostname: db1# Files: /var/lib/mysql/db1.log# Overall: 511 total, 39 unique, 30.06 QPS, 0x concurrency _______________# Time range: 2017-11-18 09:01:09 to 09:01:26# Attribute          total     min     max     avg     95%  stddev  median# ============     ======= ======= ======= ======= ======= ======= =======# Exec time              0       0       0       0       0       0       0# Query size 92.18k ...