HomePhorge

Script to selectively convert MyISAM tables to InnoDB

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

Provenance
epriestleyAuthored on Jul 11 2011, 10:46 AM
themackabuPushed on Mar 25 2025, 8:07 PM
Parents
rP36e00db5645e: bug due to using $fields instead of $this->fields
Branches
Unknown
Tags
Unknown

Event Timeline