Skip to content

Instantly share code, notes, and snippets.

@memorycraft

memorycraft/rds_optimize_alter.sql

Last active December 14, 2015 11:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save memorycraft/5081993 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save memorycraft/5081993 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rds_optimize_alter.sql
mysql> ALTER TABLE order_line ENGINE=InnoDB;
Query OK, 790679 rows affected (31.92 sec)
Records: 790679 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE customer ENGINE=InnoDB;
Query OK, 150000 rows affected (14.18 sec)
Records: 150000 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE stock ENGINE=InnoDB;
Query OK, 500000 rows affected (30.85 sec)
Records: 500000 Duplicates: 0 Warnings: 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment