List:Internals« Previous MessageNext Message »
From:Rick James Date:January 25 2010 11:49pm
Subject:Re: Hash index on MyISAM
View as plain text  
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:
> To unsubscribe:

Hash index on MyISAMnihal dindar25 Jan
  • Re: Hash index on MyISAMRick James26 Jan
  • Re: Hash index on MyISAMSergei Golubchik26 Jan
  • Re: Hash index on MyISAMIngo Strüwing26 Jan