摘要： Calculate index sizesmysql> SELECT CONCAT(ROUND(SUM(index_length)/(1024*1024*1024), 2), ' GB') AS 'Total Index Size'FROM information_schema.TABLES WHERE table_schema LIKE 'database';+------------------+| Total Index Size |+------------------+| 1.70 GB |+------------------+ 阅读全文