use information_schema;
SELECT TABLE_NAME,(DATA_LENGTH+INDEX_LENGTH)/1024/1024/1024,TABLE_ROWS,(DATA_LENGTH+INDEX_LENGTH)/table_rows FROM TABLES;
SELECT TABLE_NAME,(DATA_LENGTH+INDEX_LENGTH)/1024/1024/1024,TABLE_ROWS,(DATA_LENGTH+INDEX_LENGTH)/table_rows FROM TABLES;