Hi,
Is your table MyISAM or InnoDB?
Andrew
-----Original Message-----
From: Morten [mailto:my.lists@stripped]
Sent: 15 June 2009 21:23
To: mysql@stripped
Subject: The size of an index (INDEX_LENGTH)
Hi,
I dropped an index on a table with 25M records today. The INDEX_LENGTH
in information_schema.tables shrank from 3834642432 to 3215982592, ie.
~618Mb difference
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
unreliable or?
Thanks,
Morten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
