> use information_schema; select table_name,table_rows,concat(round(DATA_LENGTH/1024/1024/1024,2),'GB') from tables where TABLE_SCHEMA = 'bw_data' order by table_rows desc;