MySQL索引要放在哪个表空间_mysql表空间与索引查看方法

本节内容：

mysql表空间与mysql索引

1，查看mysql索引

(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，查看mysql表空间

复制代码 代码示例:

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索引管理 mysql创建索引

mysql索引的建立原则

mysql索引类型有哪些

mysql索引创建与管理笔记

mysql索引创建、删除与查看

mysql索引的建立规则

如何创建mysql索引

mysql索引的类型与优缺点

mysql索引优化注意问题

mysql索引优化提升数据库性能

mysql索引优化应用实例

Mysql索引分类与优化

深入理解MySQL索引与优化

mysql索引优化实例分享