Skip to content

Instantly share code, notes, and snippets.

@vietcf

vietcf/mysql

Created December 14, 2016 03:08
Show Gist options
  • Save vietcf/cd0d517e4b3d5ddc9630f755b1848ce8 to your computer and use it in GitHub Desktop.
Save vietcf/cd0d517e4b3d5ddc9630f755b1848ce8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql
mysql> select TABLE_SCHEMA, table_name, round(data_length/1024/1024) as data_length_mb, round(data_free/1024/1024) as data_free_mb from information_schema.tables where round(data_free/1024/1024) > 100 order by data_free_mb;
+--------------+---------------+----------------+--------------+
| TABLE_SCHEMA | table_name | data_length_mb | data_free_mb |
+--------------+---------------+----------------+--------------+
| f319_xen | xf_search | 14 | 104 |
| f319_xen | xf_user_alert | 0 | 115 |
+--------------+---------------+----------------+--------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment