Monthly Archives - December 2012

Percona response to recent MySQL security bugs

Recently there have been discussions on several vulnerabilities in MySQL and closely related projects such as MariaDB and Percona Server. Usually we have inherited security fixes from MySQL when we have updated Percona Server to be based off a new Oracle MySQL release. In this case however, Oracle has been incredibly quiet.
We’ve been examining […]

Read more

Fractal Tree Indexing Overview

We get a lot of questions about how Fractal Tree indexes work. It’s a write-optimized index with fast queries, but which write-optimized indexing structure is it?
In this ~15 minute video (which uses these slides), I give a quick overview of how they work and what they are good for.

Read more

Quickly finding unused indexes (and estimating their size)

I had a customer recently who needed to reduce their database size on disk quickly without a lot of messy schema redesign and application recoding.  They didn’t want to drop any actual data, and their index usage was fairly high, so we decided to look for unused indexes that could be removed.
Collecting data
It’s quite […]

Read more

Announcing Percona XtraBackup 2.0.4

Percona is glad to announce the release of Percona XtraBackup 2.0.4 on December 4th, 2012. 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.0 series.
Bugs Fixed:

Bug fix for #932623 introduced the regression in XtraBackup 2.0.2 which caused incremental backups to fail because […]

Read more

A closer look at Percona XtraDB Cluster for MySQL

The Web And PHP Magazine just published an article describing Percona XtraDB Cluster written by Liz van Dijk and Kenny Gryp. It is a pretty high-level introduction to the technology, so definitely give it a read if you’ve been wanting to give it a closer look.
Go to their website http://www.webandphp.com and download Issue number 9 for free!

 

Read more

Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete

As Percona Live London is raging in the UK, I thought it fitting to remind everyone about the next big Percona Live: MySQL Conference and Expo 2013 in Santa Clara, Californa on April 22-25, 2013.  You can register NOW for this conference, and the Super Saving Registration deadline ends on December 28th, so be sure […]

Read more