MySQL query to list table sizes (index + data) for each schema

db_table_sizes.sql

SELECT 
  TABLE_NAME, 
  table_rows, 
  AVG_ROW_LENGTH, 
  data_length / 1024 /1024 / 1024 AS data_length_gb,
  index_length / 1024 /1024 / 1024 AS index_length_gb, 
  (data_length / 1024 /1024 / 1024  + index_length / 1024 /1024 / 1024) AS total_length_gb 
FROM information_schema.tables 
ORDER BY table_schema, total_length_gb DESC;