로그인  |  회원가입  |  결제계좌   中文 상담

회원로그인

mysql命令获取数据库占用容量 - 투호스팅 - 도메인,호스팅,기업메일,미국서버,홍콩서버,서버관리대행,중국서버,중국호스팅,중국도메인

编程知识 >> mysql >> mysql命令获取数据库占用容量

글쓴이: Admin 날짜: 17-06-01 16:48,

所有数据库用量以列表显示:
> SELECT table_schema "Database Name",SUM(data_length + index_length) / 1024 / 1024 "Size(MB)" FROM information_schema.TABLES GROUP BY table_schema;

如果只显示某个数据库,例如显示名为tohosting_db数据库的容量,可加where语句:
> SELECT table_schema "Database Name",SUM(data_length + index_length) / 1024 / 1024 "Size(MB)" FROM information_schema.TABLES WHERE table_schema = 'tohosting_db' GROUP BY table_schema;

삭제 수정 목록 답변 글쓰기