On 9/3/2010 3:15 PM, Johnny Withers wrote:
> It seems that when your index is PRIMARY on InnoDB tables, it's magic and is
> part of the data thereby it is not included in the index_length field.
>
> I have never noticed this. I don't think adding a new index will make a
> difference.
>
> You could try moving your log files to a different disk array than where
> your data is. If you have binary and query logging enabled, it's probably a
> good idea.
>
Johnny is correct. The PRIMARY KEY to an InnoDB table is indeed part of
the data:
http://dev.mysql.com/doc/refman/5.1/en/innodb-index-types.html
That explains why there is no length to this index.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
