mysql 表空间及索引的查看方法

!--NEWSZW_HZH_BEGIN-- 1.查看索引

（1）单位是GB

SELECT CONCAT(ROUND(SUM(index_length)/(1024*1024*1024), 2), " GB") AS "Total Index Size" FROM information_schema.TABLES WHERE table_schema LIKE "database"; SELECT CONC