select TABLE_SCHEMA,table_name,table_rows,AVG_ROW_LENGTH,DATA_FREE,DATA_LENGTH/1024/1024/1024 G,DATA_FREE/DATA_LENGTH from information_schema.tables s order by G desc