Friday, October 10, 2008

InnoDB faster mutex patch ported to MySQL 5.1

I have ported the Google patch for faster InnoDB mutexes to MySQL 5.1. The Google patch is for the InnoDB plugin. This is for the version of InnoDB in the 5.1 branch.

This improves performance on servers with more than 4 cores. It provides the following on supported platforms (x86, modern gcc)
  • uses atomic ops for the InnoDB mutex
  • replaces the InnoDB rw-mutex
  • disables the InnoDB memory heap and memory heap mutex

The code is in Launchpad
  • more details on my launchpad branch are here 
  • more details on Bazaar are here

4 comments:

Tim Soderstrom said...

You said it's for the InnoDB plugin? I thought they hadn't been updated since 5.1.24? Am I wrong (innodb.com still has 5.1.24 as the latest version)

Mark Callaghan said...

No, I said the Google patch is for the Innodb plugin and I ported that to my launchpad branch that doesn't have the Innodb plugin.

Arjen Lentz said...

The plugin is so much nicer, why don't we just focus on that! I don't think it makes much sense porting *to* old code...

Mark Callaghan said...

Someone needs to bring the plugin into launchpad AND fix all of the test diffs first. The faster mutex patch for the plugin is at http://code.google.com/p/google-mysql-tools/wiki/Mysql5Patches.

Post a Comment