EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL 8.0.1: The Next Development Milestone

 | January 9, 2017 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Quality Assurance

MySQL 8.0.1

This post discusses the next MySQL development milestone: MySQL 8.0.1. From the outset, MySQL 8.0 has received plenty of attention. Both this blog (see the MySQL 8.0 search) and other sites around the Internet have covered it. Early reviews seem positive (including my own MySQL 8.0 early bugs review). There is plenty of excitement about the new features. As […]

Read More

Enabling and Disabling Jemalloc on Percona Server

 | January 3, 2017 |  Posted In: Insight for DBAs, MySQL

MariaDB ColumnStore

This post discusses enabling and disabling jemalloc on Percona Server for MySQL. The benefits of jemalloc versus glibc for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) you have less memory fragmentation, and thus more efficient resource management of the available server memory. For standard installations of Percona Server 5.6+ […]

Read More

Percona Live Featured Tutorial with Øystein Grøvlen — How to Analyze and Tune MySQL Queries for Better Performance

 | December 29, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Live

Percona Live Featured Tutorial

Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona […]

Read More

Using Percona XtraBackup on a MySQL Instance with a Large Number of Tables

 | December 28, 2016 |  Posted In: Insight for DBAs, MySQL, Percona XtraBackup

CVE-2016-6225

In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to back up. So if you’re running innodb_file_per_table=1, and […]

Read More

Don’t Let a Leap Second Leap on Your Database!

 | December 27, 2016 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, MySQL

Leap Second

This blog discusses how to prepare your database for the new leap second coming in the new year. At the end of this year, on December 31, 2016, a new leap second gets added. Many of us remember the huge problems this caused back in 2012. Some of our customers asked how they should prepare for this year’s event […]

Read More

MongoDB PIT Backups In Depth

 | December 16, 2016 |  Posted In: Cloud and NoSQL, High-availability, Insight for DBAs, Insight for Developers, MongoDB, open source databases, Percona Server, Solutions Engineering

MongoDB PIT Backups

In this blog is an in-depth discussion of MongoDB PIT backups. Note: INTIMIDATION FREE ZONE!! This post is meant to give the reader most of the knowledge that is needed to understand the material. This includes basic MongoDB knowledge and other core concepts. I have tried to include links for further research where I can. […]

Read More