Differences

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

--- mysql_database_sizes [2017/02/23 08:47] – luke7858
+++ mysql_database_sizes [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-\\
+~~NOCACHE~~
-==== Size of ALL databases ====
+====== Database/Table Sizes ======
+{{tabembed>[[database_size|database size, [[table_size|table size}}
-__**Note:**__ You do not need to change the 'Database Name' entry
-<sxh bash>
-SELECT table_schema "Database Name",
-    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
-    sum( data_free )/ 1024 / 1024 "Free Space in MB"
-FROM information_schema.TABLES
-GROUP BY table_schema ;
-</sxh>
-\\
-==== File size of a specific db ====
-The following commands should be run inside mysql
-\\
-__**Note:**__ replace “Data Base Name” with the db name.
-<sxh bash>
-SELECT table_schema "Data Base Name",
-    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
-    sum( data_free )/ 1024 / 1024 "Free Space in MB"
-FROM information_schema.TABLES
-WHERE table_schema = "$DATABASE_NAME"
-</sxh>
-\\
-=== Size of a table in a db ===
-**__Note:__** You will need to replace DATABASE_NAME and TABLE_NAME.
-<sxh bash>
-SELECT table_name AS "Table",
-     round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
-FROM information_schema.TABLES
-WHERE table_schema = "$DATABASE_NAME"
-AND table_name = "$TABLE_NAME";
-</sxh>