List:General Discussion« Previous MessageNext Message »
From:Keith Murphy Date:July 19 2010 1:54pm
Subject:Re: Myisam advantages
View as plain text  
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

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