EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server and XtraBackup weekly news, February 26th

 | February 27, 2011 |  Posted In: MySQL, Percona Software

PREVIOUS POST
NEXT POST

Percona Server has a new logo:

Percona Server Logo
Percona Server Logo

Other news for Percona Server:

  • Many users noticed that our repositories don’t work for Debian Squeeze, the new version of Debian. Our repositories will support Squeeze on the next release, which will be based on MySQL 5.1.55.
  • We merged a fix for InnoDB’s slow DROP TABLE performance. A new option, innodb_lazy_drop_table, controls this behavior.
  • Vadim asked Yasufumi to look into porting the innodb_sync_checkpoint_limit feature from the Facebook patches into Percona Server.
  • Peter requested a high priority for logging queries to the slow query log from a replica using row-based replication.
  • Yasufumi reported a feature request for XtraDB to store statistics for the ::records_in_range() handler function, instead of accessing the data. This could improve performance for complex queries.
  • A user on our mailing list requested us to merge Google’s KILL IF_IDLE functionality into Percona Server, and proposed the merge on Launchpad.

In XtraBackup news,

  • Alexey completed moving streaming functionality from innobackupex. InnoDB files are now streamed by the xtrabackup binary, and tar4ibd has been removed (this has not been merged into the trunk yet).
  • Alexey completed implementing compression with quicklz in xtrabackup, though a tricky problem remains in combination with streaming.
PREVIOUS POST
NEXT POST
Baron Schwartz

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

5 Comments

  • Facebook patches have a feature of allowing spreading .ibd tables to different disks. Any chance you could port that patch to Percona Server?

    Thanks.

  • I’m happy to see tar and compression support going into xtrabackup. Does quicklz support parallel compression? I’m using pigz (on 3 cores) with xtrabackup and it knocked my 9 hour backup (using regular gzip) down to under 2.

  • Andy, we’re not currently working on that and don’t have any immediate plans to, but if you need it done, we can do it: https://www.percona.com/contact/sales/

    Kristofer, thanks!

    Marcus, quicklz does support parallel compression, and that is why we are using it — we are trying to optimize xtrabackup for very large datasets.

    • I forgot to mention who created our Percona and Percona Server logo: it is http://thelogocompany.net/ I would not hesitate to suggest them for anyone looking to create a logo. They go the extra mile.

Leave a Reply

 
 

Percona’s widely read Percona Data 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.