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 ...
