Skip to content

Instantly share code, notes, and snippets.

@memorycraft

memorycraft/rds_optimize.sql

Created March 4, 2013 12:41
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save memorycraft/5082014 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rds_optimize.sql
mysql> OPTIMIZE TABLE order_line;
+-------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------+----------+----------+-------------------------------------------------------------------+
| deflag.order_line | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| deflag.order_line | optimize | status | OK |
+-------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (57.53 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment