Is there a possibility to get the table size for a database? I can get the number of records for each table with SQL

select fld_name, fld_record_count from (show tables) where fld_kind = 0

But I don't see a way to get the size of all tables.

For my email archiving app the user end up with large databases. Because I save the raw data of the email the database usually is larger than the raw data. Now I have a user who made a 120 GB database out of 8 GB of emails. So I want to know what is in his tables. For now I've asked him to check in Valentina Studio.