Homec4science

Script to selectively convert MyISAM tables to InnoDB

Authored by epriestley <git@epriestley.com> on Jul 11 2011, 19:46.

Description

Script to selectively convert MyISAM tables to InnoDB

Summary:
A bunch of the .sql patch files don't explicitly specify the table engine, but
we should always use InnoDB with the exception of one table which needs MyISAM
for FULLTEXT.

MySQL doesn't no-op an ALTER TABLE statment that changes the engine back to
itself and converting large tables can be time consuming, so convert only the
required tables.

Test Plan: Ran on secure.phabricator.com and my local box, it fixed all the
issues in about 3 seconds on secure.phabricator.com and <<1 second on my local.
Reviewed By: codeblock
Reviewers: codeblock, tuomaspelkonen, jungejason, aran
CC: aran, epriestley, codeblock
Differential Revision: 641

Details

Committed
epriestley <git@epriestley.com>Jul 11 2011, 20:42
Pushed
aubortJan 31 2017, 17:16
Parents
rPH36e00db5645e: bug due to using $fields instead of $this->fields
Branches
Unknown
Tags
Unknown

Event Timeline

epriestley <git@epriestley.com> committed rPH467308dd12e2: Script to selectively convert MyISAM tables to InnoDB (authored by epriestley <git@epriestley.com>).Jul 11 2011, 20:42