scripts.mit.edu

MIT SIPB Script Services for Athena

sql.mit.edu default storage engine changed from MyISAM to InnoDB

November 20, 2014 at 7:07 pm by in

We have changed the MySQL default storage engine on sql.mit.edu from MyISAM to InnoDB. This change only affects newly created tables. Existing tables are unaffected, with the exception noted below of Trac databases. No user action is required.

InnoDB offers many improvements over MyISAM and has become the default engine upstream as of MySQL 5.5. Even though sql.mit.edu still runs MySQL 5.1, we made this change because it is required by Trac 1.0.2. We have also converted all Trac databases to InnoDB to let them continue working with Trac 1.0.2.

If you wish to take advantage of the new features provided by InnoDB, you can convert existing tables using the ALTER TABLE command. You can still create new MyISAM tables by passing the ENGINE=MyISAM parameter to CREATE TABLE. You can also convert InnoDB tables back to MyISAM with ALTER TABLE.

Note that the version of InnoDB running on sql.mit.edu does not yet support FULLTEXT indexes. We expect this to be eventually fixed when we upgrade to MySQL 5.6 or later. Until then, tables that use FULLTEXT indexes should be left on the MyISAM engine.

© 2004-2013, the SIPB scripts.mit.edu project.
These pages may be reused under either the GFDL 1.2 or CC-BY-SA 3.0.
Questions? Contact scripts@mit.edu.

You are currently connected to pancake-bunny.mit.edu.