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
>
