mysql table size

[MYSQL] 데이터베이스 테이블 용량 확인

[ 데이터베이스별 용량 조회 ] -- Database Size SELECTtable_schema AS 'DatabaseName' , ROUND(SUM(data_length+index_length)/1024/1024, 1) AS 'Size(MB)' FROMinformation_schema.tables GROUP BY table_schema ORDER BY 2 DESC; table_schema "bmwgs", SUM(data_length + index_length) / 1024 / 1024 "Size(MB)" FROM information_schema.TABLES GROUP BY table_schema; [ 테이블별 용량 조회 ] -- Table Size SELECTtable_name AS 'TableNam..