EmergencyEMERGENCY? Get 24/7 Help Now!

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

Percona XtraBackup

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

Monitoring OS metrics for Amazon RDS with Grafana

 | October 25, 2016 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Insight for DBAs, Percona Monitoring and Management

OS Metrics

This article describes how to visualize and monitor OS metrics for Amazon RDS instances using Grafana. We use CloudWatch as a data source, and Grafana to query CloudWatch API in real-time to get data. The setup instructions include just four quick steps (assuming you already use Grafana). Setup 1. Create an IAM user on the AWS […]

Read More

Encrypt your –defaults-file

 | October 12, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

encrypt

This blog post will look how to use encryption to secure your database credentials. In the recent blog post Use MySQL Shell Securely from Bash, there are some good examples of how you might avoid using a ~/.my.cnf – but you still need to put that password down on disk in the script. MySQL 5.6.6 and later introduced […]

Read More