Buy Percona ServicesBuy Now!

Find unused indexes

 | June 30, 2012 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Software

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

 | June 28, 2012 |  Posted In: Percona Software

Due to a bug in upstream MySQL ( ), 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 […]

Read More

Hot Table Optimization with MySQL

 | June 28, 2012 |  Posted In: Tokutek, TokuView

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 optimization; […]

Read More

MySQL Upgrade Webinar Questions Followup

 | June 28, 2012 |  Posted In: Insight for DBAs, MySQL

I did a Webinar about MySQL Upgrade – Best Practices Yesterday and there were some questions we could not answer during Webinar, following Jay’s Lead I decided to post them as a Blog Post. Q: Can you go directly MySQL 5.0 to 5.5 for MyISAM tables? MyISAM have not been getting any significant development since […]

Read More

Announcing Percona Live MySQL London

 | June 27, 2012 |  Posted In: Events and Announcements, MySQL

Looking for a great opportunity to share your MySQL knowledge with the MySQL community? Here is your chance. Percona is happy to announce that the dates of the Percona Live MySQL London Conference have been set for Dec. 3-4, 2012. Call for speakers is underway and will be open until August 17th, 2012. The conference […]

Read More

Announcing Percona XtraBackup 2.0.1

 | June 25, 2012 |  Posted In: MySQL

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: […]

Read More

Where Percona software goes before it’s released

 | June 24, 2012 |  Posted In: Percona Software

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