A short MySQL snippet to display table sizes of the mentioned DATABASE_NAME in a fine tabular format.

MySQL Table Size

  SELECT table_name, engine, table_rows, data_length, ROUND(((data_length+index_length)/1024/1024),0) "MB"
    FROM information_schema.tables 
   WHERE table_schema = 'DATABASE_NAME' 
ORDER BY data_length;