[Mysql]Database 용량 확인

[전체 데이터베이스 용량 확인]
select table_schema ‘Linear_Regression’, sum(data_length + index_length) / 1024 / 1024 ‘size(MB)’ from information_schema.tables group by table_schema

[특정 DB명 status 확인]
show table status like ‘DB명’

[특정 DB 용량 늘리기]
alter table ‘DB명’ max_rows = 400000000 avg_row_length=1500