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: http://lists.mysql.com/internals
> To unsubscribe:    http://lists.mysql.com/internals?unsub=1
> 

Thread
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