EmergencyEMERGENCY? Get 24/7 Help 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

Schema changes in MySQL for OpenStack Trove users

 | November 24, 2014 |  Posted In: MySQL, OpenStack

People using OpenStack Trove instances can hit a common issue in the MySQL world: how to perform schema change operations while minimizing the impact on the database server? Let’s explore the options that can allow online schema changes. Summary With MySQL 5.5, pt-online-schema-change from Percona Toolkit is your best option for large tables while regular […]

Read More

Why ALTER TABLE runs faster on Percona Server 5.5 vs. MySQL 5.5

 | May 15, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Server

Some of us Perconians are at OpenStack summit this week in Atlanta. Matt Griffin, our director of product management, tweeted about the turbo-hipster CI talk about their experience of ALTER TABLEs running faster on Percona Server. Oracle’s Morgan Tocker then tweeted in response, asking why this was the case. I decided that the simplest way to […]

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

Hot Indexing Part I: New Feature

 | April 5, 2011 |  Posted In: Tokutek, TokuView

From 31 minutes to 2 seconds Hot Indexing Overview TokuDB v5.0 introduces several features that are new to the MySQL world. Recently, we posted on HCAD: Hot Column addition and Deletion. In this post, we talk about Hot Indexing. What happens when you try to add a new index, as follows?

In standard MySQL […]

Read More

Tokutek’s Chief Scientist Discusses TokuDB v5.0

 | March 29, 2011 |  Posted In: Tokutek, TokuView

Running with Big Data It’s spring here in Boston, though one could hardly tell (still barely hitting 40°F). So, for those stuck indoors working out on the treadmill, or those lucky enough to do a workout outdoors, we’ve got a great podcast. Our Chief Scientist and co-founder Martín Farach-Colton had the privilege of sitting down […]

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.