#!pkk

pawel koston

  • Blog
  • linux
  • Catalog
Subscribe
#mysql #sql

SQL query to display database size in MB

Display Mysql database size in MB Query

SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ; 
Author pawelkoston
← Next Post   Previous Post →
  • #!pkk
  • EN
  • PL
  • projects
  • archive
  • RSS