tinchodev/get_mysql_table_sizes.sql

Created December 5, 2017 21:06

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tinchodev/d36c56c084e12c0b2cf68757478a02f0.js"></script>
Save tinchodev/d36c56c084e12c0b2cf68757478a02f0 to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

tinchodev created this gist Dec 5, 2017.

get_mysql_table_sizes.sql

-Original file line number
+Diff line change
@@ -0,0 +1,6 @@
+    SELECT
+         table_schema as `Database`,
+         table_name AS `Table`,
+         round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
+    FROM information_schema.TABLES
+    ORDER BY (data_length + index_length) DESC;