List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:July 19 2010 5:07pm
Subject:RE: Myisam advantages
View as plain text  
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:bmurphy@stripped]
Sent: Monday, July 19, 2010 6:55 AM
To: Jan Steinman
Cc: mysql@stripped
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 <Jan@stripped> wrote:

> From: "P.R.Karthik" <prkart@stripped>
>>
>>
>>  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=1
>
>


--
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
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