How to record table row and table size in MySQL

Open MySQL command line    

use your database/schema

run this command 

select table_name as "nama tabel", concat(table_rows," baris") as "jumlah record data", round(((data_length + index_length) / 1024/1024), 2) `Size in MB`  from information_schema.tables where table_schema = 'your database' order by 3 desc;