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
> 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
That explains why there is no length to this index.
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN