Is your table MyISAM or InnoDB?
From: Morten [mailto:my.lists@stripped]
Sent: 15 June 2009 21:23
Subject: The size of an index (INDEX_LENGTH)
I dropped an index on a table with 25M records today. The INDEX_LENGTH
in information_schema.tables shrank from 3834642432 to 3215982592, ie.
The index was on an int(11) column.
That means each index key takes up ~618Mb/25M ~= 25 bytes but that
doesn't sound right? Is that true, or is information_schema.tables
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql