Since everyone keeps bringing up Innodb's shared tablespace, I will point out that Innodb has a "file-per-table" option where each table has it own tablespace. This helps with management issues. While there is still a central datafile it doesn't contain table data and is much smaller than if you used a centralized table space.
keith On Sat, Jul 17, 2010 at 12:37 PM, Jan Steinman <j...@bytesmiths.com> wrote: > From: "P.R.Karthik" <prk...@gmail.com> >> >> >> I am newbie to mysql can i know the advantages of myisam storage engine >> and some of its special features. >> > > Works better with file-based incremental backup systems. > > With InnoDB, you end up backing up a humongous file of all your InnoDB > tables, even if only one byte in one field of one table of one database was > touched. > > ---------------- > There are only two ways to look at life: One is as if nothing is a miracle. > The other is as if everything is a miracle. -- Albert Einstein > :::: Jan Steinman, EcoReality Co-op :::: > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=bmur...@paragon-cs.com > > -- Chief Training Officer Paragon Consulting Services 850-637-3877
