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