List:General Discussion« Previous MessageNext Message »
From:Andrew Braithwaite Date:June 16 2009 3:51am
Subject:RE: The size of an index (INDEX_LENGTH)
View as plain text  
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

Thread
The size of an index (INDEX_LENGTH)Morten15 Jun
  • Re: The size of an index (INDEX_LENGTH)Dan Nelson15 Jun
  • RE: The size of an index (INDEX_LENGTH)Andrew Braithwaite16 Jun
    • Re: The size of an index (INDEX_LENGTH)Morten Primdahl16 Jun