[osflash] [OT] MyISAM ou InnoDb?

[. m a r c o s a u g u s t o]

The diff is that innodb uses row locks, and MyISAM use table lock for
writing.

So MyISAM for heavy select tables, and inno for heavy write .

Ah.. and innodb tables uses a lot more space on the disk!! a mean: A LOT
MORE

On 1/17/07, Arnoud Bos <a.bos9 at chello.nl> wrote:
>
>
> innodb is better also for referential integrity enforcing
> myISAM is faster for selects though...
>
> Arnoud
>
> -----Oorspronkelijk bericht-----
> Van: osflash-bounces at osflash.org [mailto:osflash-bounces at osflash.org]
> Namens
> Infos E-Blokos
> Verzonden: dinsdag 16 januari 2007 22:46
> Aan: Open Source Flash Mailing List
> Onderwerp: Re: [osflash] [OT] MyISAM ou InnoDb?
>
> InnoDb is transactionnal, so better
>
> Franck Chionna
>
>
> ----- Original Message -----
> From: "João Saleiro" <joao.saleiro at webfuel.pt>
> To: "Open Source Flash Mailing List" <osflash at osflash.org>
> Sent: Tuesday, January 16, 2007 4:31 PM
> Subject: [osflash] [OT] MyISAM ou InnoDb?
>
>
> > Considering:
> >
> > One website with hundreds of simultaneous visitors;
> > SQL operations are 80% selects, 20% changes;
> > Thousands of registers in different tables;
> > Relational diagram with about 90 tables, completely connected between
> > them;
> > Engine: MySQL;
> > Situation: Website/RIA
> >
> > Which is the right choice for the Storage Engine: MyISQM, InnoDB or
> other?
> >
> > Thank you,
> >
> > João Saleiro
> >
> >
> > _______________________________________________
> > osflash mailing list
> > osflash at osflash.org
> > http://osflash.org/mailman/listinfo/osflash_osflash.org
>
>
> _______________________________________________
> osflash mailing list
> osflash at osflash.org
> http://osflash.org/mailman/listinfo/osflash_osflash.org
>
>
> _______________________________________________
> osflash mailing list
> osflash at osflash.org
> http://osflash.org/mailman/listinfo/osflash_osflash.org
>



-- 
. m a r c o s    a u g u s t o  ;

.eu vim para confundir e não para explicar!. . . - Chacrinha
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://osflash.org/pipermail/osflash_osflash.org/attachments/20070117/7ede539a/attachment.htm