EmergencyEMERGENCY? Get 24/7 Help Now!

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

How much disk space should I allocate for Percona Monitoring and Management?

 | May 4, 2017 |  Posted In: Database Monitoring, InnoDB, MongoDB, MySQL, Percona Monitoring and Management, PMM

Percona Monitoring and Management

I heard a frequent question at last week’s Percona Live conference regarding Percona Monitoring and Management (PMM): How much disk space should I allocate for PMM Server? First, let’s review the three components of Percona Monitoring and Management that consume non-negligible disk space: Prometheus data source for the time series metrics Query Analytics (QAN) which […]

Read More

Storing UUID and Generated Columns

 | May 3, 2017 |  Posted In: Benchmarks, Insight for DBAs, MySQL

Storing UUID

A lot of things have been said about UUID, and storing UUID in an optimized way. Now that we have generated columns, we can store the decomposed information inside the UUID and merge it again with generated columns. This blog post demonstrates this process. First, I used a simple table with one char field that I called […]

Read More

Percona University in Europe May 9 and May 11

 | May 2, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona University

Percona University

In 2013 we started Percona University, which consists of technology discussion events held in different cities around the world. The next installments of Percona University in Europe are next week when I fly there for Percona University Berlin (May 9) and Percona University Budapest (May 11). Both events are free to attend, and you are […]

Read More

Webinar Thursday May 4, 2017: Percona Software News and Roadmap Update Q2 2017

 | May 1, 2017 |  Posted In: MongoDB, MySQL, open source databases, Percona Managed Services, Percona Software, Technical Webinars

Percona Software News

Come and listen to Percona CEO Peter Zaitsev on Thursday, May 4, 2017 at 11:00 am (PST) / 2:00 pm (EST) discuss Percona’s software news and roadmap, including Percona Server for MySQL and MongoDB, Percona XtraBackup, Percona Toolkit, Percona XtraDB Cluster and Percona Monitoring and Management. Register Now During this webinar, Peter will talk about newly […]

Read More

From Percona Live 2017: Thank You, Attendees!

 | April 28, 2017 |  Posted In: Big Data, Cloud and MySQL, Cloud and NoSQL, Docker, InnoDB, MariaDB, MongoDB, MyRocks, MySQL, Percona Live

Percona Live

From everyone at Percona and Percona Live 2017, we’d like to send a big thank you to all our sponsors, exhibitors, and attendees at this year’s conference. This year’s conference was an outstanding success! The event brought the open source database community together, with a technical emphasis on the core topics of MySQL, MariaDB, MongoDB, PostgreSQL, […]

Read More

Percona Live 2017: Hawkular Metrics, An Overview

 | April 27, 2017 |  Posted In: Big Data, MySQL, Percona Live

Hawkular Metrics

The place is still frantic here at Percona Live 2017 as everybody tries to squeeze in a few more talks before the end of the day. One such talk was given by Red Hat’s Stefan Negrea on Hawkular Metrics. Hawkular Metrics is a scalable, long-term, high-performance storage engine for metric data. The session was an overview […]

Read More

Percona Live 2017: Lessons Learned While Automating MySQL Deployments in the AWS Cloud

 | April 27, 2017 |  Posted In: Cloud and MySQL, MySQL, Percona Live

Percona Live

The last day of Percona Live 2017 is still going strong, with talks all the way until 4:00 pm (and closing remarks and a prize giveaway on the main stage then). I’m going to a few more sessions today, including one from Stephane Combaudon from Slice Technologies: Lessons learned while automating MySQL deployments in the AWS […]

Read More

Percona Live 2017: Day Three Keynotes

 | April 27, 2017 |  Posted In: Big Data, InnoDB, MariaDB, MongoDB, MyRocks, MySQL, Percona Live, Percona Server, Percona Server for MongoDB, Percona XtraDB Cluster, PMM

Percona Live Keynotes

Welcome to the third (and final) day of the Percona Live Open Source Database Conference 2017, and the third (and final) set of Percona Live keynotes! The enthusiasm hasn’t waned here at Percona Live, and we had a full house on Thursday morning! Day three of the conference kicked off with three keynotes talks, and […]

Read More