Differences

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

--- mysql_database_sizes [2015/03/30 16:42] – created luke7858
+++ mysql_database_sizes [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-=== File size of a specific db ===
+~~NOCACHE~~
-__**Note:**__ replace “Data Base Name” with the db name.
+====== Database/Table Sizes ======
-<sxh bash>
+{{tabembed>[[database_size|database size, [[table_size|table size}}
-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 ALL databases ===
-__**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>
-\\
-=== 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>