Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 2nd, 2012  |  syntax: None  |  size: 0.80 KB  |  hits: 22  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. mysql> 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  GROUP BY table_schema;
  2. +--------------------+----------------------+------------------+
  3. | Data Base Name     | Data Base Size in MB | Free Space in MB |
  4. +--------------------+----------------------+------------------+
  5. | information_schema |           0.00878906 |       0.00000000 |
  6. | mysql              |           1.37921619 |       0.00000000 |
  7. | ndbinfo            |           0.00993729 |       0.00000000 |
  8. | performance_schema |           0.00000000 |       0.00000000 |
  9. | tmp                |          39.62500000 |       0.00000000 |
  10. +--------------------+----------------------+------------------+
create a new version of this paste RAW Paste Data