Stay ahead of MySQL operational problems with Percona Toolkit and PMP plugins

on YouTube ↗28m

" summary

Percona Toolkit version 2.2.14 bundles command-line tools that diagnose and prevent real operational failures: pt-stalk collects OS and MySQL samples and can trigger on connection or query thresholds, pt-query-digest profiles slow/general logs and compares 30 minutes before/after deploy to surface the few queries causing most load, and pt-table-checksum runs chunked checks, writes per-chunk results to a table and drives the pmp-check-pt-table-checksum Nagios alerting to detect silent replication divergence. Regularly cronning these finds issues that otherwise never stop MySQL.

AI-written summary · about

" chapters (7)

1. 0:00Percona Toolkit intro
2. 2:52Toolkit features overview
3. 5:07PT-stalk diagnostics
4. 9:56PT-query-digest analysis
5. 14:58PT-table-checksum replication
6. 20:32Key takeaways
7. 22:46Q&A

" related talks

• 51mResolving MySQL Problems QuicklyKenny Gryp · PHP UK Conference 2013
• 58mBetter MySQL With Percona PMMPeter Zaitsev · Percona Live 2022
• 29mAdvanced Optimization and Troubleshooting MySQL Using PMM2Peter Zaitsev · Percona Live Online 2020
• 21mEasy way of application monitoringCihan Tunali · Percona University Istanbul 2022
• 01h 02mHow-to MySQL Performance Diagnostic Using Percona PMMMarcos Albe · Percona Live 2022
• 27mUsing PMM to identify and troubleshoot problematic MySQL queriesMichael Coburn · Percona Tech Days 2020
• 51mHow to improve PostgreSQL Monitoring and ...Charly Batista, Agustin Gallego · PGConf NYC 2021
• 30mWhy we recommend PMM to our clientsMatthias Crauwels · OSMC 2018