On Thu, Jul 15, 2010 at 10:46 PM, P.R.Karthik <prkart@stripped> wrote:
> Hi,
>
> I am newbie to mysql can i know the advantages of myisam storage engine
> and some of its special features.
>
> --
> Regards
> Karthik.P.R
> karthik@stripped
Special features:
1. Not atomic.
2. No consistency.
3. Horrible isolation
4. Durable on good days.
In short it can easily eat your data. If you love your data and treat
it well it will love you back. There are very few valid uses for
MyISAM (full text and spatial are not valid, use sphinx and PostGIS
respectively)
--
Rob Wultsch
wultsch@stripped
