WilliamQLiu/get_table_size.sql

Created January 30, 2019 23:51

Star (0) 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/WilliamQLiu/2aa2414fb8d3982dbb07fdbb857d0afd.js"></script>
Save WilliamQLiu/2aa2414fb8d3982dbb07fdbb857d0afd to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

WilliamQLiu created this gist Jan 30, 2019.

get_table_size.sql

-Original file line number
+Diff line change
@@ -0,0 +1,6 @@
+    SELECT
+        table_name AS "Table",
+        round(((data_length + index_length) / 1024 / 1024), 2) as size
+    FROM information_schema.TABLES
+    WHERE table_schema = "my_database"
+    ORDER BY size DESC;