In addition, the binlogs function as incremental backups. With a full backup + binlogs, you can do point-in-time recovery to any moment you choose.
-----Original Message----- From: Keith Murphy [mailto:bmur...@paragon-cs.com] Sent: Monday, July 19, 2010 6:55 AM To: Jan Steinman Cc: mysql@lists.mysql.com Subject: Re: Myisam advantages 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 This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any loss or damage caused by viruses or errors or omissions in the contents of this message, which arise as a result of e-mail transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
