EmergencyEMERGENCY? Get 24/7 Help Now!

Using Prometheus to Check for auto_increment Value Exhaustion

 | November 8, 2017 |  Posted In: Insight for DBAs, Percona Monitoring and Management, PMM, Prometheus

auto_increment Value Exhaustion small

In this blog post, we’ll look at how to use Prometheus to check for auto_increment value exhaustion. One of the proactive tasks DBAs perform is checking if a field defined as auto_increment is about to reach the maximum allowed value of the int definition. For example, if a field is defined as smallint unsigned and […]

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

Changing the Tablespace Directory with pt-online-schema-change

and  | November 4, 2016 |  Posted In: InnoDB, MySQL, Percona Toolkit

MariaDB ColumnStore

In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change. One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough to run over an LVM volume or a RAID (depending on the level, though), it […]

Read More

Basic Housekeeping for MySQL Indexes

 | September 9, 2016 |  Posted In: Insight for DBAs, MySQL

MySQL Indexes

In this blog post, we’ll look at some of the basic housekeeping steps for MySQL indexes. We all know that indexes can be the difference between a high-performance database and a bad/slow/painful query ride. It’s a critical part that needs deserves some housekeeping once in a while. So, what should you check? In no particular order, […]

Read More

Fixing errant transactions with mysqlslavetrx prior to a GTID failover

 | December 2, 2015 |  Posted In: GTID, MySQL

GTID and errant transactions

Errant transactions are a major issue when using GTID replication. Although this isn’t something new, the drawbacks are more notorious with GTID than with regular replication. The situation where errant transaction bites you is a common DBA task: Failover. Now that tools like MHA have support for GTID replication (starting from 0.56 version), this protocol […]

Read More

Reset MySQL root password without restarting MySQL (no downtime!)

 | December 10, 2014 |  Posted In: Insight for DBAs, MySQL

Disclaimer: Reset the MySQL root password at your own risk! It doesn’t apply if you’re using Pluggable authentication and certainly won’t be usable if/when MySQL system tables are stored on InnoDB What is the situation? The situation is the classic “need to reset MySQL root password” but you cannot restart MySQL (because it is the master production […]

Read More