Percona Toolkit (formerly Maatkit) provides essential command-line utilities for MySQL.
Percona Toolkit is a set of high-quality command-line tools for open-source databases, such as MySQL and PostgreSQL. The tools enable power users to do their work more safely and quickly by relying on tested software instead of scripting things themselves.
The toolkit includes functionality such as table checksums, a query profiler, and a visual EXPLAIN tool. It also provides missing features such as checking whether slaves have the same data as the master.
Percona Toolkit has a test suite with more than 2,500 tests.
Key Features
- Verify master and replica data consistency.
- Efficiently archive rows.
- Find duplicate indexes.
- Summarize MySQL servers.
- Analyze queries from logs and tcpdump.
- Collect vital system information when problems occur.
Website: www.percona.com/toolkit
Support: Forums, GitHub Code Repository
Developer: Baron Schwartz and others
License: GNU General Public License v2.0
Percona Toolkit is written in Go. Learn Go with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |
Please read our Comment Policy before commenting.