moodLearning Wiki

Differences

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

Link to this comparison view

mysql-notes [2019/04/15 14:28]
serbizadmin created
mysql-notes [2020/06/13 15:10]
Line 1: Line 1:
-====== DB Size ====== +
-<code> +
-SELECT table_schema "dbname" +
-     , SUM(data_length + index_length) / (1024 * 1024) "Database Size in MB" +
-FROM information_schema.TABLES +
-GROUP BY table_schema; +
-</code>+