EmergencyEMERGENCY? Get 24/7 Help Now!

Differences in PREPARE Statement Error Handling with Binary and Text Protocol (Percona XtraDB Cluster / Galera)

 | July 5, 2017 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

PREPARE Statement

In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols. Introduction Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets rolled back with a DEADLOCK error. While the same holds true even if you fire […]

Read More

Percona Monitoring and Management 1.1.5 is Now Available

 | June 21, 2017 |  Posted In: Database Monitoring, Events and Announcements, Insight for DBAs, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Software, PMM, Prometheus, ProxySQL

Troubleshooting MySQL Performance

Percona announces the release of Percona Monitoring and Management 1.1.5 on June 21, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM-667: Fixed the Latency graph in the ProxySQL Overview dashboard to plot microsecond values instead of milliseconds. PMM-800: Fixed the InnoDB Page Splits graph in the MySQL InnoDB Metrics Advanced dashboard to […]

Read More

Tracing MongoDB Queries to Code with Cursor Comments

 | June 21, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB

Tracing MongoDB Queries

In this short blog post, we will discuss a helpful feature for tracing MongoDB queries: Cursor Comments. Cursor Comments Much like other database systems, MongoDB supports the ability for application developers to set comment strings on their database queries using the Cursor Comment feature. This feature is very useful for both DBAs and developers for quickly […]

Read More

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

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

MongoDB Authentication and Roles: Creating Your First Personalized Role

 | May 17, 2017 |  Posted In: Insight for DBAs, MongoDB, Security

MongoDB Authentication and Roles

In this blog post, we’ll walk through the native MongoDB authentication and roles, and learn how to create personalized roles. It is a continuation of Securing MongoDB instances. As said before, MongoDB features a few authentication methods and built-in roles that offer great control of both who is connecting to the database and what they are allowed […]

Read More

Percona-Lab/mongodb_consistent_backup: 1.0 Release Explained

 | May 10, 2017 |  Posted In: Backups, Insight for DBAs, Insight for Developers, MongoDB

mongodb_consistent_backup

In this blog post, I will cover the Percona-Lab/mongodb_consistent_backup tool and the improvements in the 1.0.1 release of the tool. Percona-Lab/mongodb_consistent_backup mongodb_consistent_backup is a tool for performing cluster consistent backups on MongoDB clusters or single-replica sets. This tool is open source Python code, developed by Percona and published under our Percona-Lab GitHub repository. Percona-Lab is […]

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