EmergencyEMERGENCY? Get 24/7 Help Now!

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

Using sysbench 0.5 for performing MySQL benchmarks

 | September 2, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, OpenStack, Percona MySQL Consulting, Percona MySQL Support

Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance.  I generally turn to sysbench since it comes with a variety of different tests (accessed via –test= option interface), including: fileio – File I/O test cpu – CPU performance test memory – […]

Read More

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

 | August 12, 2013 |  Posted In: MySQL, Percona Server, 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

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.