Monthly Archives - November 2013

Four Benefits of TokuMX Transactions for MongoDB Applications

From the application’s perspective, TokuMX behaves very similarly, if not identically, to MongoDB in many ways. But in one subtle yet important way, on non-sharded clusters, TokuMX is different. With MongoDB, operations on each single document are transactional. With TokuMX, each statement is transactional. Although I explain this in my last post, let me […]

Read more

Using per-query variable statements in Percona Server

Percona Server has implemented per-query variable statement support in version 5.6.14-62.0. This feature provides the ability to set variable values only for a certain query, after execution of which the previous values will be restored. Per-query variable values can be set up with the following command:

MySQL

mysql> SET STATEMENT <variable=value> FOR <statement>;

1

mysql> SET STATEMENT <variable=value> […]

Read more

Introducing Percona Cloud Tools for MySQL

I am proud to announce Percona Cloud Tools, the next generation of tools for MySQL.  I have been developing tools for MySQL for 10 years.  For the last 5 years, I have been developing Percona Toolkit (formerly “Maatkit”).  Almost 1 year ago, we began developing Percona Cloud Tools (PCT), first in-house, then in private […]

Read more

How to recover an orphaned .ibd file with MySQL 5.6

A few years ago Yves Trudeau and Aleksandr Kuzminsky wrote posts about different ways for recovering orphaned .ibd files:

Connecting orphaned .ibd files
A recovery trivia or how to recover from a lost ibdata1 file

Today I want to show you how to do that in more easy and quick way. In my example I’ll restore a […]

Read more

Percona XtraDB Cluster 5.5.34-23.7.6 is now available

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.34-23.7.6 on November 4, 2013. Binaries are available from the downloads area or from our software repositories.
Bugs Fixed:

Fixed the issues with upgrade on Debian caused by debian-start script. Bug fixed #1112363.
Adding the AUTO_INCREMENT column to a table would result in data inconsistency because […]

Read more

Quick link to Percona Toolkit bugs

In this post I wanted to highlight
percona.com/bugs/<tool> , for example: percona.com/bugs/pt-stalk.  This only works for Percona Toolkit.  We often advise people to check a tool’s current bugs, but we don’t always say how.
The official link for Percona Toolkit bugs on Launchpad is https://bugs.launchpad.net/percona-toolkit/+bugs, but then you still have search from there.  So this quick link […]

Read more