Monthly Archives - September 2013

A TokuDB Stall Caused by a Big Transaction and How It was Fixed

One of our customers sometimes observed lots of simple insertions taking far longer than expected to complete. Usually these insertions completed in milliseconds, but the insertions sometimes were taking hundreds of seconds. These stalls indicated the existence of a serialization bug in the Fractal Tree index software, so the hunt was on. We found […]

Read more

Percona XtraBackup 2.1.5 is now available

Percona is glad to announce the release of Percona XtraBackup 2.1.5 on September 19th, 2013. Downloads are available from our download site here and Percona Software Repositories.
This release is the current GA (Generally Available) stable release in the 2.1 series. Percona XtraBackup is an open source, free MySQL hot backup software that performs […]

Read more

Lock Diagnostics and Index Usage Statistics in TokuMX v1.2.1

TokuMX v1.2.1 introduces two simple new features to help you understand the performance characteristics of your database: lock diagnostics and index usage statistics. We’d like to take you through a few examples of what these features are and how to use them.

Lock Diagnostics
Since we introduced TokuMX, one of the most frequent complaints has been […]

Read more

Percona XtraDB Cluster 5.5.33-23.7.6 is now available

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.33-23.7.6 on September 18, 2013. Binaries are available from the downloads area or from our software repositories.
New Features:

Default State Snapshot Transfer method, defined in wsrep_sst_method variable has been changed from mysqldump to rsync.
New wsrep_reject_queries variable has been implemented that can be used to […]

Read more

Percona Live London 2013: an insider’s view of the schedule

With the close of call for papers earlier this month, the Percona Live London conference committee was in full swing this past week reviewing all of the many submissions for November’s Percona Live London MySQL Conference.
The submissions are far ranging and cover some really interesting topics, making the lineup for Percona Live London really strong! […]

Read more

OSS4B – Presenting in Italy on MySQL and Percona XtraDB Cluster

I will be in Prato (Firenze), Italy Thursday and Friday (September 19th and 20th) to deliver 2 presentations at OSS4B:

Installing and managing MySQL like a real devops: automation in production
Introduction to Percona XtraDB Cluster

If you want to learn about these projects or discuss anything related to MySQL and Percona, join the conference and don’t […]

Read more

Switching between versions using yum

One type of question we get very often (even in the form of filed bugs!) is how to switch from stock MySQL to Percona Server or switch from Percona Server 5.5 to Percona XtraDB Cluster using yum, but à la apt-get, i.e. having yum handle the replace.
In its simplest form, yum cannot replace a […]

Read more