by Agustín | Oct 23, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Recently we had a customer that had issues with a filled disk on the server hosting their Docker pmm-server environment. They were not able to access the web UI, or even stop the pmm-server container because they had filled the /var/ mount point. Setting correct... by Agustín | Sep 5, 2018 | MySQL, Percona Software
Do you need to modify the metrics collected from Linux by Percona Monitoring and Management (PMM)? In this blog post we will see how to enable, disable, and update collected metrics on PMM’s linux:metrics exporter. We will assume that the PMM... by Agustín | May 24, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Software
Some years ago, Peter Z wrote a blogpost about using MySQL Sandbox to deploy multiple server versions. Last February, Giuseppe introduced us to its successor: dbdeployer. In this blogpost we will demonstrate how to use it. There is a lot of information in... by Agustín | Mar 20, 2018 | MySQL
In this blog post, we’ll see how to use different mount points on PMM Docker deployments (Percona Monitoring and Management). This is useful if you want to use other mount points for the different directories, or even if you want to use a custom path that... by Agustín | 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 Agustín | Sep 12, 2017 | Insight for DBAs, MariaDB, MySQL
In this post, we will discuss how to search code with the help of cscope. Let’s begin by checking its description and capabilities (quoting directly from http://cscope.sourceforge.net/):Cscope is a developer’s tool for browsing source code. Allows... by Agustín | Jun 14, 2017 | Insight for DBAs, MySQL
In this post we’ll review how MySQL triggers can affect queries. Contrary to what the documentation states, we can activate triggers even while operating on views:https://dev.mysql.com/doc/refman/5.7/en/triggers.html Important: MySQL triggers activate only... by Agustín | May 23, 2017 | MySQL
In this post, we’ll see how to make Docker images available to servers that don’t have access to the Internet (i.e., machines where docker pull <image_name> does not work). As a specific example, we will do this with the latest Percona Monitoring and... by Agustín | May 22, 2017 | Insight for DBAs, MariaDB, MySQL, Percona Software
In this blog, we’ll look at ICP counters in the information_schema.INNODB_METRICS. This is part two of the Index Condition Pushdown (ICP) counters blog post series. As mentioned in the previous post, in this blog we will look at how to check on ICP counters... by Agustín | May 9, 2017 | Insight for DBAs, MySQL
In this post we’ll see how MariaDB’s Handler_icp_% counters status counters (Handler_icp_attempts and Handler_icp_matches) measure ICP-related work done by the server and storage engine layers, and how to see if our queries are getting any gains by...