Skip to content

Instantly share code, notes, and snippets.

@simonrenoult

simonrenoult/optimize_table.sql

Created July 1, 2019 09:00
Show Gist options
  • Save simonrenoult/2840916b770e047b8dcf5613be62d8e1 to your computer and use it in GitHub Desktop.
Save simonrenoult/2840916b770e047b8dcf5613be62d8e1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
optimize_table.sql
mysql> OPTIMIZE TABLE articles;
+--------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------+----------+----------+-------------------------------------------------------------------+
| debug_sql.articles | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| debug_sql.articles | optimize | status | OK |
+--------------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (10.46 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment