MySQL table sizes

table_size.sql

-- top 10
SELECT
	CONCAT(table_schema,'.',table_name) AS `tbl`,
	round(((data_length + index_length) / POW(1024,2)), 2) `Size_MB`
FROM
	information_schema.TABLES
ORDER BY
	(data_length + index_length)
	DESC limit 10;

-- specific schema
SET @tableschema = 'apps';
SELECT
	CONCAT(table_schema,'.',table_name) AS `tbl`,
	round(((data_length + index_length) / POW(1024,2)), 2) `Size_MB`
FROM
	information_schema.TABLES
WHERE 
  table_schema = @tableschema
ORDER BY
	(data_length + index_length)
	DESC limit 10;
	
=======

SELECT
	CONCAT(table_schema,'.',table_name) AS `tbl`,
	round(((data_length + index_length) / POW(1024,2)), 2) `Size_MB`,
    table_rows/1000000 as rows_mil
FROM
	information_schema.TABLES
WHERE 
  table_name in (
      '_billing_events_old',
  )
ORDER BY
	(data_length + index_length)
DESC limit 10;