Monthly Archives - June 2012

Find unused indexes

I wrote one week ago about how to find duplicate indexes. This time we’ll learn how to find unused indexes to continue improving our schema and the overall performance. There are different possibilites and we’ll explore the two most common here. User Statistics from Percona Server and pt-index-usage.
User Statistics
User Statistics is an improvement […]

Read more

Percona Server 5.5.25-27.0 release delayed

Due to a bug in upstream MySQL ( http://bugs.mysql.com/bug.php?id=65745 ), we’ve decided to delay the release of the next Percona Server release until it is resolved. We had originally expected to release Percona Server 5.5.25-27.0 today and instead I’m informing you that we are not.
Quoting Hartmut, who reported the bug:
An UPDATE that should only modify a […]

Read more

Hot Table Optimization with MySQL

Table optimization is a necessary evil; tables sometimes need to be optimized to reclaim space or to improve query performance.  Unfortunately, MySQL blocks writes to a table while it is being optimized.  Because optimization time is proportional to the table size, writes can be blocked for a long time.  Fractal Tree indexes support online […]

Read more

Volver – MySQL, NoSQL, and Cloud Conference Latin America

Volver,
con la frente marchita,
las nieves del tiempo
platearon mi sien…
Martin’s blog (Mi Buenos Aires Querido) was named after a tango, so I decided to follow his lead. The 4 lines of the refrain make reference to someone returning to Buenos Aires after 20 years, now looking a little bit older. I moved to the […]

Read more

Announcing Percona XtraBackup 2.0.1

Percona is glad to announce the release of Percona XtraBackup 2.0.1 on June 25th, 2012. Downloads are available from our download site and Percona Software Repositories.
This release is the current GA (Generally Available) stable release in the 2.0 series.
This release contains over 20 fixed bugs, some of the more significant bugs fixed are:

After creating […]

Read more

Where Percona software goes before it’s released

Where does software go while it’s waiting for release? The answer is: our experimental repository!
For anywhere from a few days to a week before we release them, we stage our software releases in the TESTING download area and in separate software repositories for Debian/Ubuntu and CentOS/RHEL. This is so that we can co-ordinate things such […]

Read more

DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL

Suppose you have turned on innodb_file_per_table (which means that each table has its own tablespace), and you have to drop tables in a background every hour or every day. If its once every day then you can probably schedule the table dropping process to run during off-peak hours. But I have seen cases where […]

Read more