Ben Shoemate's Notebook

Leslie Hawthorn via Google Open Source Blog shared by 4 people

By Mark Callaghan, Software Engineering Team

Did you know that Google uses MySQL as part of its Ads system? As you can imagine, we demand a lot from this Open Source code base and so we have spent a fair amount of time enhancing it to work better in our massively scaled environment. In the past, we have published several patches and today we have a few more to offer. We expect several of these features to be merged into a future official MySQL release, and one of them, semi-synchronous replication, is already available as a MySQL feature preview.

All of the features in the patch are described on our project wiki. The features include:

• enhancements and bug fixes for features from the previous patch


• changes to make InnoDB run faster on multi-core servers


• changes to display mutex contention statistics


• changes to monitor and rate-limit activity by database account and client IP

We are publishing several patches:

• a patch for MySQL 5.0.37 with all of our changes


• a patch for MySQL 5.1.26 with the changes for mutex contention statistics


• a patch for MySQL 5.0.67 to make InnoDB run faster on multi-core servers

We hope these features we've Open Sourced will be useful to other developers. Check out the code and let us know what you think. We'd love to hear from you and answer any questions you might have in our Google MySQL Tools Discussion Group.