mysql-commands.md

• Show sizes of all tables in MB

  SELECT 
      table_name AS `Table`, 
      round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
  FROM information_schema.TABLES 
  WHERE table_schema = "databasename";