by Juan Arruti | Apr 10, 2024 | Cloud, Insight for DBAs, Monitoring, MySQL
It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The Ingress NGINX Controller is one of the most popular choices for... by Juan Arruti | Oct 12, 2023 | Cloud, Monitoring, MySQL
In this blog post, we’ll review how to run Linux profilers such as perf and produce flame graphs on Kubernetes environments.Flame graphs are a graphical representation of function calls. It shows which code paths are more busy on the CPU in given samples. They... by Juan Arruti | Apr 23, 2020 | Insight for DBAs, Monitoring, MySQL
One of our customers recently asked whether it is possible to identify, from the MySQL side, the query that is causing high CPU usage on his system. The usage of simple OS tools to find the culprit has been a widely used technique for a long time by PostgreSQL and... by Juan Arruti | Jul 19, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.MySQL version 5.6 and later allows you to execute replicated events using parallel threads. This feature is called Multi-Threaded Slave (MTS), and to enable it you... by Juan Arruti | Feb 8, 2017 | Insight for DBAs, MySQL
This blog we describe an issue with MySQL 5.7’s super_read_only feature when used alongside with GTID in chained slave instances. Background In MySQL 5.7.5 and onward introduced the gtid_executed table in the MySQL database to store every GTID. This...