On Thu, Jul 15, 2010 at 10:46 PM, P.R.Karthik <prk...@gmail.com> 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 > kart...@mafiree.com
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 wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org