Homec4science

Allow `bin/storage adjust` to adjust table engines

Authored by epriestley <git@epriestley.com> on Nov 24 2016, 18:00.

Description

Allow bin/storage adjust to adjust table engines

Summary:
Ref T11741. On recent-enough versions of MySQL, we would prefer to use InnoDB for fulltext indexes instead of MyISAM.

Allow bin/storage adjust to read actual and expected table engines, and apply adjustments as necessary.

We have one existing bad table that uses the wrong engine, metamta_applicationemail. This change corrects that table.

Test Plan:

  • Ran bin/storage upgrade.
  • Saw the adjustment phase apply this change properly:
>>>[463] <query> ALTER TABLE `local_metamta`.`metamta_applicationemail` COLLATE = 'utf8mb4_bin', ENGINE = 'InnoDB'

Reviewers: chad

Reviewed By: chad

Maniphest Tasks: T11741

Differential Revision: https://secure.phabricator.com/D16941

Details

Committed
epriestley <git@epriestley.com>Nov 26 2016, 00:13
Pushed
aubortJan 31 2017, 17:16
Parents
rPHff3333548f8a: Create and populate a stopwords table for InnoDB fulltext indexes to use in the…
Branches
Unknown
Tags
Unknown

Event Timeline

epriestley <git@epriestley.com> committed rPH9d0752063e1e: Allow `bin/storage adjust` to adjust table engines (authored by epriestley <git@epriestley.com>).Nov 26 2016, 00:13