# percona/percona-toolkit

Percona Toolkit: a collection of advanced open source command-line tools.

Repository: https://github.com/percona/percona-toolkit
Canonical: https://ross.abutalabs.com/products/percona-toolkit
Homepage: https://www.percona.com/software/database-tools/percona-toolkit
Language: Perl
License: GPL-2.0
License Family: copyleft
Topics: pt, database, database-tools, percona-toolkit
Last push: 2026-08-24T11:40:15+00:00

## Health v2 (maintenance only)
Score: 77/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 35, longevity 100
- inputs: {"age_days": 4866, "days_push": 9, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1544, forks 377 (observed 2026-08-28T04:05:01.521523+00:00)

## What it is
Percona Toolkit is a collection of advanced open source command-line tools for performing difficult MySQL and system tasks such as online schema changes, replication integrity checks, and slow query analysis. The tools are professionally developed, formally tested, fully documented, and self-contained, written primarily in Perl.

## Use cases
- perform online schema changes on large mysql tables without downtime
- verify replication consistency across mysql topologies
- analyze and summarize slow query logs
- find and fix duplicate or orphaned rows in mysql tables
- archive or purge old rows from large tables safely
- validate mysql backups before restoring
- debug and profile mysql server activity

## When to choose
- you administer production MySQL or MariaDB servers and need battle-tested DBA utilities
- you need zero-downtime ALTER TABLE operations on very large tables
- you want scriptable, documented alternatives to one-off maintenance scripts
- you need to detect replication drift in complex MySQL topologies

## When to avoid
- you primarily use PostgreSQL or MongoDB rather than MySQL/MariaDB
- you need a GUI or dashboard-based database management experience
- you want a monitoring service with dashboards and alerting (use Percona PMM instead)
- your environment lacks Perl or cannot install Perl-based tooling

## Facets
- artifact type: cli-tool
- maturity: stable
- function: database, developer-tools, cli, monitoring, backup
- domain: databases, developer-tools
- platform: cli, cross-platform
- tags: mysql, mariadb, dba, replication, schema-change, slow-query-analysis, perl, command-line, devops, linux, macos

## Member repositories
- percona/percona-toolkit (main) score 77

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:01.521523+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:30:38.809388+00:00, confidence not recorded.
  - readme: https://github.com/percona/percona-toolkit (fetched 2026-08-28T04:05:01.521523+00:00, sha 20e0bbd73aa7)
  - homepage: https://www.percona.com/software/database-tools/percona-toolkit (fetched 2026-08-29T11:32:03.469693+00:00, sha 05ce6ac57b0f)
  - site_page: https://www.percona.com/services/database-monitoring-quickstart (fetched 2026-08-29T11:32:03.478841+00:00, sha 2564d28f4bc1)
  - site_page: https://docs.percona.com/ (fetched 2026-08-29T11:32:03.480947+00:00, sha 8e56afa36a44)
  - site_page: https://www.percona.com/about (fetched 2026-08-29T11:32:03.482668+00:00, sha 5f21b7e93ac8)
  - site_page: https://www.percona.com/press (fetched 2026-08-29T11:32:03.484454+00:00, sha eb8179f2849d)
  - site_page: https://www.percona.com/downloads (fetched 2026-08-29T11:32:03.486145+00:00, sha afedf6f94b39)
- Data as of 2026-08-30T08:39:29.467469+00:00.