BestHub
Sign in
Tagged articles
16 articles
Page 1 of 1
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.

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

Index Optimizationexplainmysql
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 PerformanceIndex OptimizationLarge Tables
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 ToolsMySQLTunermysql
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.

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

Slow Query Logmysqlpercona-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.

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

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