moodLearning Wiki

Differences

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

Link to this comparison view

mysql-notes [2020/06/13 15:10] (current)
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>