How to get All table sizes of the database in mysql?

You can use this query to show the size of a table.

Example:

SELECT 
    table_name AS `Table`, 
    round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
WHERE table_schema = "Accounts";

Result: