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