データベース・データ・テーブルの空き容量の問合せ
1058 ワード
mysql
1、
SELECT CONCAT(TRUNCATE(SUM(data_length)/1024/1024,2),'MB') AS data_size,
CONCAT(TRUNCATE(SUM(max_data_length)/1024/1024,2),'MB') AS max_data_size,
CONCAT(TRUNCATE(SUM(data_free)/1024/1024,2),'MB') AS data_free,
CONCAT(TRUNCATE(SUM(index_length)/1024/1024,2),'MB') AS index_size
FROM information_schema.tables WHERE TABLE_SCHEMA = ' ';
2、
SELECT CONCAT(TRUNCATE(SUM(data_length)/1024/1024,2),'MB') AS data_size,
CONCAT(TRUNCATE(SUM(max_data_length)/1024/1024,2),'MB') AS max_data_size,
CONCAT(TRUNCATE(SUM(data_free)/1024/1024,2),'MB') AS data_free,
CONCAT(TRUNCATE(SUM(index_length)/1024/1024,2),'MB') AS index_size
FROM information_schema.tables WHERE TABLE_NAME = ' ';
:
BYTE(B):
1KB ,2 10 : 1024 BYTE.
1MB ,2 20 : 1024 KB.
1GB ,2 30 : 1024 MB.
1TB ,2 40 : 1024 GB.
1PB ,2 50 : 1024 TB.
1EB ,2 60 : 1024 PB.
1ZB ,2 70 : 1024 EB.
1YB ,2 80 : 1024 ZB.