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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
