SELECT table_schema,table_name,table_type,engine,table_rows,data_length/1024/1024/1024 as "size - Gigs" FROM information_schema.tables WHERE engine='MyISAM' AND data_length > 536870912 ORDER BY table_schema,table_rows DESC;