For NDB  tables, you can also obtain this information using the ndb_desc  utility. 

## • INDEX_LENGTH 

The length of the index file for this partition or subpartition, in bytes. 

For partitions of NDB  tables, whether the tables use implicit or explicit partitioning, the INDEX_LENGTH column value is always 0. However, you can obtain equivalent information using the ndb_desc  utility. 

## • DATA_FREE 

The number of bytes allocated to the partition or subpartition but not used. 

For NDB  tables, you can also obtain this information using the ndb_desc  utility. 

## • CREATE_TIME 

The time that the partition or subpartition was created. 

## • UPDATE_TIME 

The time that the partition or subpartition was last modified. 

## • CHECK_TIME 

The last time that the table to which this partition or subpartition belongs was checked. 

For partitioned InnoDB  tables, the value is always NULL . 

## • CHECKSUM 

The checksum value, if any; otherwise NULL . 

## • PARTITION_COMMENT 

The text of the comment, if the partition has one. If not, this value is empty. 

The maximum length for a partition comment is defined as 1024 characters, and the display width of the PARTITION_COMMENT  column is also 1024, characters to match this limit. 

## • NODEGROUP 

This is the nodegroup to which the partition belongs. This is relevant only to NDB Cluster tables; otherwise, the value is always 0 . 

## • TABLESPACE_NAME 

The name of the tablespace to which the partition belongs. The value is always DEFAULT , unless the table uses the NDB  storage engine (see the Notes  at the end of this section). 

## Notes 

• PARTITIONS  is a nonstandard INFORMATION_SCHEMA  table. 

•A table using any storage engine other than NDB  and which is not partitioned has one row in the PARTITIONS  table. However, the values of the PARTITION_NAME , SUBPARTITION_NAME , PARTITION_ORDINAL_POSITION , SUBPARTITION_ORDINAL_POSITION , PARTITION_METHOD , SUBPARTITION_METHOD , PARTITION_EXPRESSION , SUBPARTITION_EXPRESSION , and 

