EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server and XtraBackup weekly news, March 5th

 | March 6, 2011 |  Posted In: MySQL, Percona Software


What’s new this week in Percona Server:

  • For users who upgraded to Squeeze, the new version of Debian, we’re expecting to support Squeeze in our repositories on the next release based on MySQL 5.1.55, which we estimate will be released on March 9th. This should also update the Maverick repository for Ubuntu users.
  • If you’re waiting for the innodb_lazy_drop_table feature in Percona Server, unfortunately it doesn’t look like we can get it into the next release. It was just too late in the release process to have time to do proper QA, and we take quality very seriously.
  • Yasufumi clarified his idea for XtraDB to store statistics for the ::records_in_range() handler function, instead of accessing the data. This would prevent queries from needing to enter the InnoDB kernel during the planning phase, which can be a severe bottleneck especially for complex queries, which need to check the number of records in ranges many times. If you have ever seen a server with dozens of queries in “statistics” state, that’s the bottleneck this feature could help alleviate.
  • We merged a change developed by Facebook that reduces excess fcntl() calls. This has been shown to double throughput on sysbench benchmarks.

News for XtraBackup:

  • Alexey reports that implementation of the custom streaming format is complete.
  • We are working on releasing XtraBackup 1.5 as stable (it’s currently a Release Candidate), but we don’t have a firm release date.
  • We are also working towards XtraBackup 1.6, which contains lots of new features, and of course fixes bugs.
  • We have decided to make innobackupex always back up the MySQL system database, even for partial backups; it contains data that is necessary to restore other data correctly.
Baron Schwartz

Baron is the lead author of High Performance MySQL. He is a former Percona employee.

Leave a Reply


Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.