EmergencyEMERGENCY? Get 24/7 Help Now!

This Week in Data with Colin Charles 28: Percona Live, MongoDB Transactions and Spectre/Meltdown Rumble On

 | February 16, 2018 |  Posted In: Amazon RDS, Events and Announcements, MariaDB, MongoDB, MySQL, open source databases, Percona Server for MySQL, PMM, PostgreSQL, ProxySQL, TokuDB

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. In case you missed last week’s column, don’t forget to read the fairly lengthy FOSDEM MySQL & Friends DevRoom summary. From a Percona Live Santa Clara 2018 standpoint, beyond the tutorials getting picked and […]

Read More

Collect PostgreSQL Metrics with Percona Monitoring and Management (PMM)

 | February 9, 2018 |  Posted In: Database Monitoring, Percona Monitoring and Management, PMM, PostgreSQL

Collecting PostgreSQL Information using Percona Monitoring and Management

In this article, we’ll describe how to collect PostgreSQL metrics with Percona Monitoring and Management (PMM). We designed Percona Monitoring and Management (PMM) to be the best tool for MySQL and MongoDB performance investigation. At the same time, it’s built on mature opensource components: Prometheus’ time series database and Grafana. Starting from PMM 1.4.0. it’s possible to […]

Read More

This Week in Data with Colin Charles 27: Percona Live Tutorials Released and a Comprehensive Review of the FOSDEM MySQL DevRoom

 | February 9, 2018 |  Posted In: Events and Announcements, InnoDB, MariaDB, MySQL, Percona Live, Percona Monitoring and Management, Percona Server for MySQL, PMM, ProxySQL, Replication

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 update: tutorials have been announced. The committee rated over 300+ talks, and easily 70% of the schedule should go live next week as well. In practice, then, you should see […]

Read More

Using Prometheus to Check for auto_increment Value Exhaustion

 | November 8, 2017 |  Posted In: Insight for DBAs, Percona Monitoring and Management, PMM, Prometheus

auto_increment Value Exhaustion small

In this blog post, we’ll look at how to use Prometheus to check for auto_increment value exhaustion. One of the proactive tasks DBAs perform is checking if a field defined as auto_increment is about to reach the maximum allowed value of the int definition. For example, if a field is defined as smallint unsigned and […]

Read More

Group Replication: The Sweet and the Sour

 | August 1, 2017 |  Posted In: GTID, High-availability, InnoDB, MySQL, Percona XtraDB Cluster, PMM

Group Replication

In this blog, we’ll look at group replication and how it deals with flow control (FC) and replication lag.  Overview In the last few months, we had two main actors in the MySQL ecosystem: ProxySQL and Group-Replication (with the evolution to InnoDB Cluster).  While I have extensively covered the first, my last serious work on […]

Read More

Percona Monitoring and Management 1.2.0 is Now Available

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

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.2.0 on July 14, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM Server 1.2.0 introduced the following changes: Updated Components Consul 0.8.5 Grafana 4.3.2 Orchestrator 2.1.5 Prometheus 1.7.1 New Features PMM-737: New graphs in System Overview dashboard: Memory Advanced Details Saturation Metrics PMM-1090: Added ESXi support […]

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

Percona Monitoring and Management

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

Percona Monitoring and Management 1.1.4 is Now Available

 | May 29, 2017 |  Posted In: Database Monitoring, Docker, Events and Announcements, Insight for Developers, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, Percona Software, PMM, Prometheus, ProxySQL

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.1.4 on May 29, 2017. For installation instructions, see the Deployment Guide. This release includes experimental support for MongoDB in Query Analytics, including updated QAN interface.

Read More

Percona Software and Roadmap Update with CEO Peter Zaitsev: Q2 2017

 | May 24, 2017 |  Posted In: Backups, Benchmarks, MariaDB, MongoDB, MySQL, Percona XtraBackup, Percona XtraDB Cluster, PMM, Technical Webinars

Percona Software and Services

This blog post is a summary of the Percona Software and Roadmap Update – Q2 2017 webinar given by Peter Zaitsev on May 4, 2017. This webinar reflects changes and updates since the last update (Q1 2017). A full recording of this webinar, along with the presentation slide deck, can be found here. Percona Software Below are the […]

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