On Thu, Jul 15, 2010 at 10:46 PM, P.R.Karthik <[email protected]> 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 > [email protected]
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 [email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
