要查看MySQL數(shù)據(jù)庫(kù)的容量,可以執(zhí)行以下查詢語(yǔ)句:
SELECT
table_schema AS `Database`,
SUM(data_length + index_length) / 1024 / 1024 AS `Size (MB)`
FROM information_schema.TABLES
GROUP BY table_schema;
這條查詢語(yǔ)句會(huì)返回每個(gè)數(shù)據(jù)庫(kù)的總大?。ㄒ訫B為單位)。您可以查看返回的結(jié)果,以了解每個(gè)數(shù)據(jù)庫(kù)的容量情況。