Tagged articles
percona-toolkit
33 articles · Page 1 of 1
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

This guide walks through MySQL performance troubleshooting—from enabling and analyzing slow‑query logs with pt‑query‑digest, interpreting EXPLAIN plans, designing covering and composite indexes, tuning InnoDB buffer pool and connection settings, to best‑practice recommendations and real‑world case validation.
Buffer PoolEXPLAINIndex Optimization
0 likes · 27 min read

This article walks through a real‑world MySQL slow‑query case, showing how to identify the bottleneck with EXPLAIN, design covering and composite indexes, rewrite the SQL, tune InnoDB parameters, and safely deploy the changes, ultimately shrinking execution time from seconds to a few milliseconds.
EXPLAINIndexingMySQL
0 likes · 32 min read

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 ToolsMySQLPerformance Tuning
0 likes · 9 min read

This article introduces MySQL performance tuning utilities—including mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest—provides download and usage commands with report‑analysis guidance, and then shifts to promotional content for ChatGPT‑4.0 services, a paid community, and related offers.
Database ToolsDevOpsLinux
0 likes · 12 min read

This article introduces four open‑source MySQL performance tools—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining their purpose, how to download and run them, and how to interpret the diagnostic reports they generate for database optimization.
Database ToolsMySQLPerformance Tuning
0 likes · 12 min read

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 tips for interpreting their diagnostic reports to improve database configuration and query efficiency.
Database ToolsMySQLPerformance Tuning
0 likes · 8 min read

This article introduces a collection of practical open‑source utilities—including SQLTXPLAIN, SOAR, SQLAdvisor, and Percona Toolkit tools—that streamline common MySQL DBA tasks such as schema changes, replication checks, slow‑query analysis, and data consistency verification, helping engineers work faster and more efficiently.
DBA toolsMySQLSQL Optimization
0 likes · 8 min read


ITPUBJun 17, 2024 · Databases
This guide introduces a collection of practical MySQL DBA utilities—including SQLTXPLAIN, SOAR, SQLAdvisor, and Percona Toolkit commands such as pt‑duplicate-key-checker, pt‑kill, pt‑mysql-summary, pt‑query-digest, pt‑table-checksum, and pt‑table-sync—showing how to install them, run key commands, and interpret their outputs to streamline database administration tasks.
DBAMySQLSQL Optimization
0 likes · 9 min read

Learn how to assess and optimize your MySQL database using four powerful open‑source tools—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—complete with download links, command‑line usage examples, and guidance on interpreting their diagnostic reports to improve performance and security.
Database ToolsMySQLPerformance Tuning
0 likes · 9 min read

This guide introduces key MySQL performance‑tuning utilities—including 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 for a healthier database.
MySQLmysqltunerpercona-toolkit
0 likes · 8 min read

This article introduces several MySQL performance‑tuning utilities—including mysqltuner.pl, tuning-primer.sh, and Percona Toolkit’s pt-variable-advisor and pt-query-digest—explaining how to download, run, and interpret their reports to optimize database configuration, memory usage, and query efficiency.
Database ToolsMySQLPerformance Tuning
0 likes · 7 min read

This guide explains what pt‑kill is, how it works within Percona Toolkit to kill MySQL connections based on execution time and various filters, demonstrates command‑line usage, victim‑selection modes, filtering options, source‑code logic, and common patterns such as logging and daemonizing.
Connection ManagementMySQLPT-kill
0 likes · 12 min read

This guide explains how to use Percona Toolkit's pt-archiver for MySQL data archiving, covering installation, basic and bulk commands, underlying two‑phase‑commit logic, performance trade‑offs of various parameters, and best‑practice tips for safe, efficient archiving and deletion.
Data ArchivingMySQLReplication Lag
0 likes · 19 min read

This article explains why MySQL upgrades can cause syntax, semantic and performance incompatibilities, introduces the Percona Toolkit's pt‑upgrade tool, details its detection logic and common usage patterns, provides a full demo with real query results, and lists essential parameters and precautions for safely migrating from MySQL 5.7 to 8.0.
MySQLSQLcompatibility testing
0 likes · 17 min read

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 ToolsMySQLPerformance Tuning
0 likes · 9 min read

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 describes how to interpret their reports to identify configuration and query‑level issues.
Database ToolsMySQLSQL Optimization
0 likes · 8 min read


ITPUBAug 11, 2021 · Databases
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.
MySQLPerformance Tuningmysqltuner
0 likes · 8 min read


ITPUBAug 9, 2021 · Databases
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

This article explains how to use Percona Toolkit's pt-table-checksum tool to detect and verify data consistency between MySQL master and replica servers, covering its principles, suitable scenarios, safety mechanisms, and step‑by‑step commands for setup, data generation, and checksum execution.
Data ConsistencyMySQLchecksum
0 likes · 16 min read

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.
MySQLPerformance Analysispercona-toolkit
0 likes · 15 min read

This article provides a comprehensive guide to the pt-online-schema-change (pt-osc) tool for MySQL online DDL, covering its underlying mechanism, limitations, installation steps, command‑line syntax, practical examples, and a comparative analysis with native Online DDL and gh‑ost to help users choose the appropriate solution.
Database MigrationMySQLonline DDL
0 likes · 32 min read

This article introduces the Percona Toolkit utility pt‑stalk, explains its OS‑level and MySQL‑level monitoring capabilities, details configuration parameters and usage scenarios, shows example command lines, describes the generated diagnostic output, and briefly covers the companion pt‑sift tool for analysis.
LinuxMySQLdiagnostics
0 likes · 8 min read

This guide introduces four open‑source MySQL tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run each tool, and shows how to interpret their AWR‑style reports for concrete performance and security improvements.
Database ToolsMySQLPerformance Tuning
0 likes · 9 min read


ITPUBMar 23, 2020 · Databases
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.
MySQLPerformance Tuningdatabase optimization
0 likes · 8 min read

This guide introduces four key MySQL optimization utilities—mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest—explains how to download, install, and run each tool, and shows how to interpret their health‑check reports to identify performance bottlenecks, configuration issues, and security risks.
MySQLPerformance TuningTools
0 likes · 8 min read

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, run them, and interpret their reports to identify configuration issues and optimize database performance.
Database ToolsMySQLOperations
0 likes · 9 min read

This guide introduces several Percona Toolkit command‑line tools—pt‑archiver, pt‑config‑diff, pt‑heartbeat, pt‑variable‑advisor, and pt‑pmp—explaining their purpose, providing example commands for data archiving, configuration comparison, accurate replication lag measurement, variable optimization suggestions, and stack‑trace debugging, plus a quick installation snippet.
MySQLdatabase administrationpercona-toolkit
0 likes · 11 min read


21CTONov 18, 2017 · Databases
This article walks through practical MySQL optimization techniques—including configuration file tuning, key InnoDB parameters, effective index design, and the use of Percona and MySQL Tuner tools—to help you speed up queries and eliminate performance bottlenecks in production environments.
ConfigurationIndex OptimizationMySQL
0 likes · 17 min read

pt-heartbeat, a Percona Toolkit utility, enables precise monitoring of MySQL and PostgreSQL replication lag by creating a heartbeat table on the master, updating timestamps, and comparing them with slaves, with detailed installation steps, usage examples, and configuration guidance for reliable replication health checks.
MySQLPostgreSQLReplication Lag
0 likes · 5 min read

Learn a step-by-step method to safely alter large MySQL tables in production without locking, by creating a new table, syncing data via triggers, copying rows, swapping tables, and using Percona’s pt-online-schema-change tool with example commands and installation instructions.
Database MigrationMySQLOnline Schema Change
0 likes · 4 min read

Learn how to diagnose MySQL master‑slave data drift using Percona Toolkit’s pt‑table‑checksum, configure necessary replication parameters, and automatically reconcile differences with pt‑table‑sync, including installation steps, command syntax, required privileges, and troubleshooting common errors for reliable database consistency.
MySQLReplicationdatabase consistency
0 likes · 13 min read


21CTOAug 14, 2015 · Databases
This guide explains why a MySQL master‑slave setup lost data after a migration, how to compare the master and replica using pt-table-checksum, and step‑by‑step commands to synchronize missing rows safely with pt-table-sync.
MySQLpercona-toolkitpt-table-checksum
0 likes · 11 min read
