Returns list of all MyISAM tables sorted by size

MyISAM_tables.sql

SELECT
    concat(table_schema, '.', table_name) tbl,
    engine,
    concat(round(table_rows/
        1000000,2),'M') rows,
    concat(round(data_length/
        (1024*1024*1024),2),'G') DATA,
    concat(round(index_length/
        (1024*1024*1024),2),'G') idx,
    concat(round((data_length+index_length)/
        (1024*1024*1024),2),'G') total_size,
    round(index_length/data_length,2) idxfrac
 FROM information_schema.TABLES
WHERE table_schema not in
        ('mysql', 'performance_schema', 'information_schema')
  AND engine = 'MyISAM'
ORDER BY data_length+index_length DESC;