mysql 位 查詢,如何查看mysql數據庫的大小?
1:查看所有表空間及表空間大小: select tablespace_name ,sum(bytes) / 1024 / 1024 as MB from dba_data_files group by tablespace_name; 2:查看所有表空間對應的數據文件大小: select tablespace_name,file_name from dba_data_files;
1:查看所有表空間及表空間大小: select tablespace_name ,sum(bytes) / 1024 / 1024 as MB from dba_data_files group by tablespace_name; 2:查看所有表空間對應的數據文件大小: select tablespace_name,file_name from dba_data_files;