From: Rick James
Date: January 25 2010 11:49pm
Subject: Re: Hash index on MyISAM
List-Archive: http://lists.mysql.com/internals/37658
Message-Id: <C7836DFB.15BDB%rjames@yahoo-inc.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Once the data in the table becomes too big to be cached, a hash index
performs poorly on both INSERT and SELECT.  This is because a hash index
tends to be very random, thereby defeating the LRU nature of caching.

Would you describe further how you envision a hash index being 'good'?


-- 
Rick James
MySQL Geek



> From: nihal dindar <ndindar@stripped>
> Date: Mon, 25 Jan 2010 23:26:28 +0100
> To: MySQL Internal <internals@stripped>
> Subject: Hash index on MyISAM
> 
> Hi all,
> 
> Is it possible to implement a hash index on MyISAM tables? Or is there
> any open src implementation?
> 
> Thanks,
> 
> Nihal
> 
> -- 
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:    http://lists.mysql.com/internals?unsub=rjames@stripped
>