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 web development

Do you need DevOps-experts?

Your development team has a full backlog? No time for infrastructure architecture? Our DevOps team is ready to support you!

  • We build reliable cloud solutions with Infrastructure as code
  • We are experts in security, Linux and databases
  • We support your dev team to perform
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)