如何找出MySQL中索引的大小 [英] How to figure out size of Indexes in MySQL

问题描述

我想确定索引的大小，它们是主键索引.这碰巧是在mysql集群上，但我认为这并不重要.

I want to determine the size of my indexes, they are primary key indexes. This happens to be on mysql cluster but I don't think that is significant.

推荐答案

我认为这就是您想要的.

I think this is what you're looking for.

show table status from [dbname]

http://dev.mysql.com/doc/refman/5.1/en/show-table-status.html

这篇关于如何找出MySQL中索引的大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！