DBLE Slow Query Log – Demonstration and Usage

This is the final lesson of the micro‑course “DBLE Quick Start”, focusing on the slow query log.

DBLE’s slow query log is compatible with MySQL’s mysqldumpslow and Percona’s pt‑query‑digest tools.

The demonstration shows how to check whether the slow query log is enabled via the management console, enable it with an ENABLE statement, and set the threshold (default 100 ms, changed to 1 ms for the demo).

After enabling, a few queries are executed on the traffic port to generate slow‑query entries; a query taking roughly 40 ms is observed, while other frequently used queries return faster.

The generated logs are stored in a “slowlogs” directory, rotated by size and time, and follow the MySQL slow‑log format with additional columns that reflect trace information.

Note: In production, slow logs are collected after real slow queries occur, whereas trace data is used for pre‑analysis.

Using mysqldumpslow (seconds granularity) shows the 40 ms query at the top of the list; Percona’s pt‑query‑digest provides a richer output for deeper analysis.

Community members are invited to join the DBLE QQ group and access additional resources, including GitHub repositories for DBLE and its documentation.

The course series has completed eighteen video and text lessons, with more high‑quality content planned for the future.