Mysql Table Sizes

size.sql

https://aws.amazon.com/premiumsupport/knowledge-center/view-storage-rds-mysql-mariadb/

#Run the following query to find the size of each user-created database:
select table_schema, round(sum(data_length+index_length)/1024/1024/1024,2) "size in GB" from information_schema.tables group by 1 order by 2 desc;

#In some cases, MySQL creates internal temporary tables that can't be removed because a query is intervening. These temporary tables aren't part of the table named "tables" inside information_schema. Run the following query to find these internal temporary tables:
select * from innodb_sys_tables where name like '%#%';