db commands

cmds.sql

-- get db size
SELECT round(Sum(data_length + index_length) / 1024 / 1024, 1) as "Size in MB" FROM information_schema.TABLES WHERE table_schema = database();

-- get sizes of all dbs

SELECT table_schema "DB Name",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "MB"
FROM
  information_schema.tables
WHERE
  table_schema NOT IN (
    'information_schema',
    'performance_schema',
    'mysql'
  )
GROUP BY
  table_schema
ORDER BY
  MB DESC;
  
  -- get sizes of tables in db
  
  SELECT TABLE_NAME AS "Table",
table_rows AS Rows,
round(((data_length + index_length) / 1024 / 1024), 2) AS Size_in_MB
FROM
  information_schema.TABLES
WHERE
  table_schema = database()
ORDER BY
  Size_in_MB DESC