在北方每当春回大地，丁香花便不甘寂寞，也会兴致匆匆竟相开放，把他那扑扑幽香……丁香花色繁多有紫色，红色，白色等在没有梅雨的六月里散发着香水般芳菲的气息。天坛公园有个丁香林，置身其中，人真会有些要被花香熏晕的感觉多么忧郁的花。多么娇嫩的花。院子里栽满丁香花。开满紫色美丽的鲜花。丁香花小，一簇一簇的，有白有紫，路边的丁香花已孕育花苞，树下围了不少人指着花苞吵吵嚷嚷，别着急呀，只等春雷一响就会竞相绽放。
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'; +------------------+
| Total Index Size |
+------------------+
| 1.70 GB |
+------------------+ （2）单位是MB SELECT CONCAT(ROUND(SUM(index_length)/(1024*1024), 2), ' MB') AS 'Total Index Size' FROM information_schema.TABLES WHERE table_schema LIKE 'database'; 其中“database”为你所要查看的数据库 2.查看表空间 SELECT CONCAT(ROUND(SUM(data_length)/(1024*1024*1024), 2), ' GB') AS 'Total Data Size'
FROM information_schema.TABLES WHERE table_schema LIKE 'database';
+-----------------+
| Total Data Size |
+-----------------+
| 3.01 GB |
+-----------------+ 3.查看数据库中所有表的信息 SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name',
CONCAT(ROUND(table_rows/1000000,2),'M') AS 'Number of Rows',
CONCAT(ROUND(data_length/(1024*1024*1024),2),'G') AS 'Data Size',
CONCAT(ROUND(index_length/(1024*1024*1024),2),'G') AS 'Index Size' ,
CONCAT(ROUND((data_length+index_length)/(1024*1024*1024),2),'G') AS'Total'FROM information_schema.TABLES WHERE table_schema LIKE 'database';
本文mysql表空间及索引的查看方法到此结束。有时稍微低下头，或许我们人生路会更加精彩，我们的能力也会有所长进。小编再次感谢大家对我们的支持！
