SQL

Get Schema sizes

SELECT
  TABLE_SCHEMA,
  SUM((DATA_LENGTH+INDEX_LENGTH)/1024/1024) AS MB FROM information_schema.tables
  WHERE TABLE_SCHEMA='schema'
GROUP BY 1;

Show current’s schema table sizes

SELECT
  TABLE_SCHEMA, TABLE_NAME,
  SUM((DATA_LENGTH+INDEX_LENGTH)/1024/1024) AS MB FROM information_schema.tables
  WHERE TABLE_SCHEMA=SCHEMA()
GROUP BY TABLE_NAME
ORDER BY MB DESC;