Buy Percona ServicesBuy Now!

Transporting tablespace from MySQL 5.6 to MySQL 5.7 (case study)

 | December 1, 2015 |  Posted In: MySQL, Percona XtraBackup

Recently, I was working on a MySQL support ticket where a customer was facing an issue while transporting tablespace from MySQL 5.6 to MySQL 5.7. After closely reviewing the situation, I saw that while importing tablespace they were getting errors such as:

After some research, I found that there is a similar bug reported to MySQL for this issue (https://bugs.mysql.com/bug.php?id=76142), but […]

Read More

InnoDB locks and deadlocks with or without index for different isolation level

 | April 9, 2015 |  Posted In: InnoDB, MySQL, Percona Live

Recently, I was working on one of the issue related to locks and deadlocks with InnoDB tables and I found very interesting details about how InnoDB locks and deadlocks works with or without index for different Isolation levels. Here, I would like to describe a small test case about how SELECT ..FOR UPDATE (with and without limit) behave […]

Read More

How to monitor ALTER TABLE progress in MySQL

 | February 26, 2014 |  Posted In: MySQL, Percona MySQL Support, Percona Toolkit

While working on a recent support issue as a Percona Support Engineer,  I got one question from a customer asking how to monitor ALTER TABLE progress. Actually, for MySQL 5.5 and prior versions, it’s quite difficult to ALTER the table in a running production environment especially for large tables (with millions records). Because it will rebuild and lock the table […]

Read More

MySQL server memory usage troubleshooting tips

 | January 24, 2014 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Support

There are many blog posts already written on topics related to “MySQL server memory usage,” but nevertheless there are some who still get confused when troubleshooting issues associated with memory usage for MySQL. As a Percona support engineer, I’m seeing many issues regularly related to heavy server loads – OR OOM killer got invoked and […]

Read More

Want to archive tables? Use Percona Toolkit’s pt-archiver

 | August 12, 2013 |  Posted In: MySQL, Percona Server for MySQL, Percona Software, Percona Toolkit

Percona Toolkit’s pt-archiver is one of the best utilities to archive the records from large tables to another tables or files. One interesting thing is that pt-archiver is a read-write tool. It deletes data from the source by default, so after archiving you don’t need to delete it separately. As it is done by default, you […]

Read More

Limited disk space? Compact backups with Percona Xtrabackup 2.1

 | June 26, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona XtraBackup

One very interesting feature, “Compact Backup,” is introduced in Percona XtraBackup 2.1. You can run “compact backups” with the  –compact option, which is very useful for those who have limited disk space to keep the MySQL database backup. Now let’s first understand how it works. When we are using –compact option with Innobackupex, it will omit the […]

Read More

Upcoming Webinars

All Webinars »