O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required