How To Get Database Size in MySQL

Database Size Calculation

Using following steps you can calculate the size of the existing MySQL database:

• 

  1. Open Terminal/Command prompt(Window)

  In window, Goto start-->Search cmd-->Click to open
  
• 

  2. Change to MySQL directory

  
  
• 

  3. Connect to MySQL Database

  mysql -h localhost -p -u alfresco
  Enter Password:

  
  
• 

  4. Type select command to get size of a Database

  select table_schema, sum(data_length+index_length) 

  /1024 /1024 as MB from informaation_schema.tables 

  where table_schema ="datbase_name";