Changes between Version 4 and Version 5 of jazz/MySQL

Timestamp:

Feb 12, 2018, 2:40:47 PM (6 years ago)

Author:

jazz

Comment:

--

jazz/MySQL

@@ -73 +73 @@
 1 row in set (0.00 sec)
 }}}
+
+* 查詢資料庫硬碟用量 - [https://makandracards.com/makandra/39413-mysql-mariadb-show-disk-usage-of-tables-and-columns 參考來源]
+{{{
+SELECT table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)` FROM information_schema.TABLES WHERE table_schema = "$your_database";
+}}}
+* 查詢資料表硬碟用量 - [https://makandracards.com/makandra/39413-mysql-mariadb-show-disk-usage-of-tables-and-columns 參考來源]
+{{{
+SELECT sum(char_length($your_column))/1024/1024 FROM $your_table
+}}}