Read more

MySQL 5.1: Switch to InnoDB Plugin for better performance

Tobias Kraze
May 25, 2012Software engineer at makandra GmbH

MySQL version 5.1 comes with an alternative, faster InnoDB implementation (called "InnoDB Plugin").

Illustration online protection

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

  • Prevents you from data breaches and liability risks
  • Upgrade at your own pace
  • Works with modern Rubies
Read more Show archive.org snapshot

Switching is easy:

  • Stop your mysqld with sudo stop mysql
  • Add the following lines to your /etc/mysql/my.cnf under the [mysqld] section
    ignore-builtin-innodb
    plugin-load=innodb=ha_innodb_plugin.so
  • Start your mysqld with sudo start mysql

The file format has not changed, your tables should survive this.

Note: This is not necessary in MySQL 5.5, where the new implementation is the default.

Posted by Tobias Kraze to makandra dev (2012-05-25 11:52)