EmergencyEMERGENCY? Get 24/7 Help Now!

Development plans

Posted on:



Share Button

We gathered together our ideas of MySQL improvements on this page https://www.percona.com/percona-lab/dev-plan.html
and we are going to implement some of them.
My favorite one is – make InnoDB files .ibd (one created with –innodb-file-per-table=1) movable from one server to another, however it is sort of challenging.
Probably next one patch we want to integrate is Google’s smp-fix or Yasufumi’s rw-locks (we are going to test both before)

On this page https://www.percona.com/percona-lab.html you can find links to our current binaries and patches.

Share Button

Vadim Tkachenko

Vadim leads Percona's development group, which produces the Percona Server, Percona Server for MongoDB, Percona XtraDB Cluster and Percona XtraBackup. He is an expert in solid-state storage, and has helped many hardware and software providers succeed in the MySQL market.


, , ,

Percona Software

  • Actually we’re really needing the ability to move InnoDB tables too…

    We wrote our own partitioning code in our distributed DB land… it supports shards and partitions (on partition per day).

    The problem is when we need to bring up a new DB server in a shard. We need to copy all the previous partitions.

    They’re immutable so we should be able to copy them from a currently running version of InnoDB to another box.

    It might be possible to do this for a DB server which was an original clone for the current server but I need to test it. I’m not sure what happens when InnoDB has been running for a while.

    We actually migrated BACK to MyISAM (ug) because of this feature. (that and we saved 2x on disk space)



  • Personally I think this is awesome addition, and could be integrated into your set of patches as well:



  • Vadim Post author


    We played with progress in processlist, but often it shows misleading information, so we decided to not include it yet.


  • I’m currently trying out the new Ebay Heap Engine, I’ve managed to get the patch to work with 5.0.68, few rejects which I think I fixed. I’m by far no expert, so next step would be to check the changes between the original patched version and the new version to see what exactly caused the rejects, doesn’t seem to be a big deal though.

    Maybe you can write something about the actual process of creating a customized MySQL (is there something like that already out?) while you’re at it 😉


  • Vadim Post author


    That would be interesting to test.
    Before including in release we need to check if there is no stability and performance problems.

    About process – yeah, I have such idea, will try to write :)


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.

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