Percona Server and XtraBackup weekly news, February 26th

Percona Server and XtraBackup weekly news, February 26th


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.

Share this post

Comments (5)

  • Andy Reply

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


    February 27, 2011 at 5:16 pm
  • Kristofer Pettersson Reply

    Really nice looking logo!

    March 1, 2011 at 2:43 am
  • Marcus Bointon Reply

    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.

    March 1, 2011 at 10:15 am
  • Baron Schwartz Reply

    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:

    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.

    March 1, 2011 at 1:32 pm
    • Baron Schwartz Reply

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

      March 5, 2011 at 3:30 am

Leave a Reply