EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Toolkit 3.0.3 is Now Available

 | May 19, 2017 |  Posted In: Events and Announcements, MongoDB, MySQL, Percona Software, Percona Toolkit

Percona Server for MongoDB

Percona announces the release of Percona Toolkit 3.0.3 on May 19, 2017. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source. You download Percona Toolkit packages from the […]

Read More

Percona Live Open Source Database Conference 2017 Slides and Videos Available

 | May 16, 2017 |  Posted In: Big Data, Cloud and MySQL, Cloud and NoSQL, Column Store Database, Database Monitoring, Docker, Group Replication, InnoDB, MariaDB, MongoDB, MyRocks, MySQL, MySQL 101, Percona Live

Percona Live

The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions. To view slides, go to the Percona Live agenda, and select the talk you want slides for from the schedule, and […]

Read More

Percona Server for MySQL 5.7.18-14 is Now Available

 | May 12, 2017 |  Posted In: MyRocks, MySQL, Percona Server, TokuDB

Percona Server for MySQL 5.7.18-14

Percona announces the GA release of Percona Server for MySQL 5.7.18-14 on May 12, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.7.18, including all the bug fixes in it, Percona Server for MySQL […]

Read More

Percona Server for MySQL 5.6.36-82.0 is Now Available

 | May 12, 2017 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB

Percona Server for MySQL 5.7.18-14

Percona announces the release of Percona Server for MySQL 5.6.36-82.0 on May 12, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.6.36, and including all the bug fixes in it, Percona Server for MySQL 5.6.36-82.0 […]

Read More

MyRocks and LOCK IN SHARE MODE

 | May 11, 2017 |  Posted In: MyRocks, MySQL, Technical Webinars

LOCK IN SHARE MODE

In this blog post, we’ll look at MyRocks and the LOCK IN SHARE MODE. Those who attended the March 30th webinar “MyRocks Troubleshooting” might remember our discussion with Yoshinori on  LOCK IN SHARE MODE. I did more tests, and I can confirm that his words are true: LOCK IN SHARE MODE works in MyRocks. This quick example demonstrates this. The initial setup:

In session 1:

[…]

Read More

Percona Server for MySQL 5.5.55-38.8 is Now Available

 | May 10, 2017 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software

Percona Server for MySQL 5.7.18-14

Percona announces the release of Percona Server for MySQL 5.5.55-38.8 on May 10, 2017. Based on MySQL 5.5.55, including all the bug fixes in it, Percona Server for MySQL 5.5.55-38.8 is now the current stable release in the 5.5 series. Percona Server for MySQL is open-source and free. You can find release details in the 5.5.55-38.8 milestone […]

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

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