by Carlos Salguero | Jun 10, 2020 | Monitoring, MySQL, Percona Software
Even though Percona Monitoring and Management 2 (PMM) comes with a lot of dashboards and metrics out of the box, sometimes we need to extend the default metrics by running custom MySQL queries.For example, suppose you want to have information about cached indexes from... by Carlos Salguero | Jun 24, 2019 | MySQL
I receive many questions about errors being reported about pt-kill… and often those errors are not real. The main problem I have found is that pt-kill is hard to understand and the documentation doesn’t have many examples (I’ll add them), so, I... by Carlos Salguero | Jan 11, 2018 | Insight for DBAs, MySQL
In this short blogpost, we’ll show you how to use the mysql_random_data_load tool to insert random data into tables. This is a great aide in testing when you have empty tables and need them to be populated with data. We’ve all done it manually (the... by Carlos Salguero | Mar 2, 2017 | MongoDB, Percona Software
This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we’ll look at the pt-mongodb-summary tool in Percona Toolkit.The pt-mongodb-summary tool from Percona Toolkit provides a quick... by Carlos Salguero | Mar 1, 2017 | MongoDB, Percona Software
This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we’ll look at how to use the pt-mongodb-query-digest tool in Percona Toolkit 3.0. Percona’s pt-query-digest is one of our most... by Carlos Salguero | Nov 4, 2016 | MySQL, Percona Software
In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change.One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough...