List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:July 19 2010 10:25pm
Subject:Re: Myisam advantages
View as plain text  
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
Thread
Myisam advantagesP.R.Karthik16 Jul
  • Re: Myisam advantagesPrabhat Kumar16 Jul
  • Re: Myisam advantagesRob Wultsch20 Jul
Re: Myisam advantagesJan Steinman17 Jul
  • Re: Myisam advantagesKeith Murphy19 Jul
    • RE: Myisam advantagesGavin Towey19 Jul