EmergencyEMERGENCY? Get 24/7 Help Now!

5 free handy tools for monitoring and managing MySQL replication

 | March 9, 2015 |  Posted In: MySQL, Percona Software, Percona Toolkit

MySQL Replication is very simple to set up. In this post I’ll discuss its importance and five handy tools for monitoring and managing MySQL replication. What is MySQL Replication? It’s the process of copying the (real-time events) data from one master instance to another slave instance and maintaining the redundant consistent data in a different […]

Read More

The MySQL Query Cache: How it works, plus workload impacts (good and bad)

 | January 2, 2015 |  Posted In: MySQL, Percona Server for MySQL

The MySQL query cache is one of the prominent features in MySQL and a vital part of query optimization. It is important to know how the MySQL query cache works, as it has the potential to cause significant performance improvements – or a slowdown – of your workload. The MySQL query cache is a global one shared among the […]

Read More

How a set of queries can be killed in MySQL using Percona Toolkit’s pt-kill

 | November 19, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona Toolkit

You might have encountered situations where you had to kill some specific select queries that were running for long periods and choking the database. This post will go into more detail with an example of report query offloading. Report query (select) offloading to a slave server is a common practice to reduce the workload of the […]

Read More

How to avoid hash collisions when using MySQL’s CRC32 function

 | October 13, 2014 |  Posted In: MySQL, Percona Toolkit

Percona Toolkit’s  pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes data efficiently between MySQL tables. The tools by default use the CRC32. Other good choices include MD5 and SHA1. If you have installed the FNV_64 user-defined function, pt-table-sync will […]

Read More