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;