BestHub
Sign in
Tagged articles

pt-query-digest

20 articles · Page 1 of 1
Raymond Ops
Raymond Ops
Aug 11, 2026 · Databases

How to Diagnose MySQL Slow Queries: From Log Capture to Index Optimization

This guide walks MySQL operators through a complete slow‑query troubleshooting workflow—starting with enabling and analyzing the slow‑query log, using pt‑query‑digest and EXPLAIN to pinpoint index, SQL, schema, configuration or hardware bottlenecks, and then applying concrete optimizations such as proper indexing, cursor pagination, JOIN tuning, and server‑level parameter tweaks.

EXPLAINJOIN tuningMySQL
0 likes · 33 min read
How to Diagnose MySQL Slow Queries: From Log Capture to Index Optimization
Raymond Ops
Raymond Ops
Aug 3, 2026 · Databases

How to Diagnose MySQL Slow Queries Without Relying on Blind Indexing

This guide walks through a systematic approach to uncovering and fixing MySQL slow queries, covering slow‑query‑log configuration, log analysis with mysqldumpslow and pt‑query‑digest, EXPLAIN‑based execution‑plan inspection, index design principles, SQL rewrites, configuration tuning, and ongoing monitoring to prevent performance regressions.

EXPLAINMySQLSlow Query
0 likes · 27 min read
How to Diagnose MySQL Slow Queries Without Relying on Blind Indexing
Linux Tech Enthusiast
Linux Tech Enthusiast
Jul 4, 2026 · Databases

Four MySQL Scripts for Diagnosing and Optimizing Your Queries

This article introduces four command‑line tools—MySQLTuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run them, and interpret their reports to assess MySQL performance, configuration, and query efficiency.

MySQLSQL Optimizationmysqltuner
0 likes · 8 min read
Four MySQL Scripts for Diagnosing and Optimizing Your Queries
MaGe Linux Operations
MaGe Linux Operations
Apr 23, 2026 · Databases

How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes

This guide walks through a systematic approach to identify, analyze, and fix MySQL slow queries by enabling the slow‑query log, interpreting its format, using tools like mysqldumpslow and pt‑query‑digest, examining execution plans with EXPLAIN, designing proper indexes, rewriting SQL, tuning server parameters, and establishing continuous monitoring to prevent regressions.

EXPLAINMySQLSlow Query
0 likes · 34 min read
How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes
MaGe Linux Operations
MaGe Linux Operations
Oct 29, 2025 · Databases

Master MySQL Slow Query Analysis & Optimization: A Practical Guide

This guide walks through enabling MySQL slow query logging, analyzing logs with pt‑query‑digest, interpreting EXPLAIN output, applying index and SQL optimizations, tuning database parameters, and setting up Prometheus monitoring, culminating in a real‑world order‑query case that reduces execution time from seconds to milliseconds.

EXPLAINMySQLSlow Query
0 likes · 17 min read
Master MySQL Slow Query Analysis & Optimization: A Practical Guide
Liangxu Linux
Liangxu Linux
Feb 16, 2025 · Databases

Essential MySQL Tuning Tools: Diagnose and Optimize Your Database

This guide introduces four powerful MySQL performance‑tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run, and interpret their reports to identify configuration issues, memory overload, and slow‑query problems.

Database ToolsMySQLpercona-toolkit
0 likes · 9 min read
Essential MySQL Tuning Tools: Diagnose and Optimize Your Database
Top Architect
Top Architect
Apr 11, 2024 · Databases

MySQL Slow Query Analysis and Index Optimization for Large Tables

This article presents a detailed investigation of a MySQL master‑slave instance suffering from nightly SLA alerts due to slow‑query latency, analyzes the root causes with pt‑query‑digest and execution plans, proposes index redesign, demonstrates backup and restore with mydumper, compares online DDL and pt‑osc, and finally shows batch‑delete techniques to reduce load on large tables.

Database PerformanceLarge TablesMySQL
0 likes · 16 min read
MySQL Slow Query Analysis and Index Optimization for Large Tables
Top Architect
Top Architect
Jan 7, 2022 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑diagnostic utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run them, and shows how to interpret their reports for optimizing database configuration and query performance.

Database ToolsMySQLmysqltuner
0 likes · 8 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
Java Architect Essentials
Java Architect Essentials
Nov 17, 2021 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑tuning utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download, install, and run them, and shows how to interpret their diagnostic reports to identify configuration issues and optimize database performance.

Database ToolsMySQLmysqltuner.pl
0 likes · 9 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
ITPUB
ITPUB
Aug 11, 2021 · Databases

Boost MySQL Performance: Essential Tools and How to Use Them

This guide introduces four practical MySQL performance‑tuning utilities—MySQLTuner, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run, and interpret their reports to identify configuration issues, memory overload, and slow‑query problems.

MySQLmysqltunerpercona-toolkit
0 likes · 8 min read
Boost MySQL Performance: Essential Tools and How to Use Them
ITPUB
ITPUB
Aug 9, 2021 · Databases

Boost MySQL Performance: Essential Tools and How to Use Them

This guide introduces four popular MySQL performance‑tuning utilities—mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest—provides download commands, usage examples, and detailed guidance on interpreting their reports to identify configuration issues and query bottlenecks.

MySQLpercona-toolkitpt-query-digest
0 likes · 9 min read
Boost MySQL Performance: Essential Tools and How to Use Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 22, 2020 · Databases

Using pt-query-digest to Analyze MySQL Slow Query Logs

This article introduces pt-query-digest from Percona Toolkit, explains how to install the toolkit, configure MySQL slow‑query logging, run pt-query-digest on the slow log, interpret its detailed output, and locate specific SQL statements for performance tuning.

MySQLSlow Query Logpercona-toolkit
0 likes · 15 min read
Using pt-query-digest to Analyze MySQL Slow Query Logs
ITPUB
ITPUB
Mar 23, 2020 · Databases

Essential MySQL Performance Tuning Tools: MySQLTuner, Tuning‑Primer, and Percona Toolkit

This guide introduces four open‑source MySQL diagnostic utilities—MySQLTuner, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run them against a live server, interpret the generated AWR‑style reports, and apply the recommended configuration changes for better stability and speed.

MySQLdatabase optimizationmysqltuner
0 likes · 8 min read
Essential MySQL Performance Tuning Tools: MySQLTuner, Tuning‑Primer, and Percona Toolkit
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 20, 2020 · Databases

DBLE Slow Query Log – Demonstration and Usage

This tutorial demonstrates how to enable, configure, and analyze DBLE’s slow query log—compatible with MySQL’s mysqldumpslow and Percona’s pt‑query‑digest—by generating sample queries, examining log rotation, and using the tools to inspect performance details, while also providing community resources and course information.

DBLEMySQLSlow Query Log
0 likes · 4 min read
DBLE Slow Query Log – Demonstration and Usage