数据库数据容量和索引容量查询

-- Check Database SPACE
select concat(round(sum(DATA_LENGTH/1024/1024), 2), ' MB') as data from TABLES where table_schema='VWS2';


-- Check Index SPACE
SELECT CONCAT(ROUND(SUM(index_length)/(1024*1024), 2), ' MB') AS 'Total Index Size' FROM information_schema.TABLES WHERE table_schema LIKE 'VWS2';sh