Jan 15, 2019 |
MySQL, Percona Software
If you have set up per-process metrics in Percona Monitoring and Management, you may have found yourself in need of tuning it further to not only group processes together, but to display some of them in isolation. In this blogpost we will explore how to modify the rules for grouping processes, so that you can […]
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 expectations The best way to avoid these kinds of issues […]
Sep 05, 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 client packages are installed, and they are configured already. Using a custom list of metrics Let’s now […]
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 Giuseppe’s post, so head there if you want a deeper dive. First step […]
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 is not bound to Docker’s volumes directory (which is /var/lib/docker/volumes/ […]
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 INSERT INTO … VALUES … way), but that is surely a […]
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 searching code for: all references to a symbol global definitions functions called by a function functions calling a […]
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 for changes made to tables by SQL statements. They do not activate for changes in views, nor by changes to tables made by APIs […]
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 Management Docker images, since we had requests for this from users and […]
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 on MySQL and Percona Server for MySQL. This also applies to […]
May 09, 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 using them. These counters (as seen in SHOW STATUS output) are MariaDB-specific. In a later post, we will see […]