EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL Triggers and Updatable Views

 | June 14, 2017 |  Posted In: Insight for DBAs, MySQL

MySQL Triggers

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 […]

Read More

How to Save and Load Docker Images to Offline Servers

 | May 23, 2017 |  Posted In: MySQL

Docker Images

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 […]

Read More

ICP Counters in information_schema.INNODB_METRICS

 | May 22, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL, Percona Monitoring and Management, PMM

ICP Counters

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 […]

Read More

MariaDB Handler_icp_% Counters: What They Are, and How To Use Them

 | May 9, 2017 |  Posted In: Insight for DBAs, MySQL

Handler_icp_% counters

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 […]

Read More