Differences

This shows you the differences between two versions of the page.

--- table_size [2017/02/23 08:48] – created luke7858
+++ table_size [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-=== Size of a table in a db ===
+=== Size of a tables in a db ===
-**__Note:__** You will need to replace DATABASE_NAME and TABLE_NAME.
+**__Note:__** You will need to replace **__DATABASE_NAME__**
 <sxh bash>
 SELECT table_name AS "Table",
-     round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
+round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
 FROM information_schema.TABLES
-WHERE table_schema = "$DATABASE_NAME"
+WHERE table_schema = "DATABASE_NAME"
-AND table_name = "$TABLE_NAME";
+ORDER BY (data_length + index_length) DESC LIMIT 15;
 </sxh>