mysql table size 확인

1. 논리적 사이즈 확인

select table_name as table, 

           data_length + index_length as logical size

from information_schema.tables

where table_schema = 'test';

 

혹은 

 

show table status like 'test' ;   -- data_length, index_length 값 확인

 

2. 물리적 사이즈 확인

select file_name, total_extents * extent_size as size

from information_schema.files

where file_name like '%test%';