查看數(shù)據(jù)庫(kù)占用總大小
①? 第一步 use 數(shù)據(jù)庫(kù)名
②? SELECT (sum( DATA_LENGTH )/ 1048576 + sum( INDEX_LENGTH )/ 1048576) as '總內(nèi)存(單位M)' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '數(shù)據(jù)庫(kù)名'
查看數(shù)據(jù)庫(kù)各個(gè)表占用總大小和條數(shù)
SELECT TABLE_NAME,(DATA_LENGTH+INDEX_LENGTH)/1048576 as memory,TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '數(shù)據(jù)庫(kù)名' ORDER BY memory DESC
查看數(shù)據(jù)庫(kù)最后修改時(shí)間（來確定mysql數(shù)據(jù)庫(kù)是否已經(jīng)長(zhǎng)期不再使用。）
SELECT TABLE_NAME, UPDATE_TIME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '數(shù)據(jù)庫(kù)名' ORDER BY UPDATE_TIME DESC
