[development] Big site update

Gildas COTOMALE gildas.cotomale at gmail.com
Sat Dec 10 18:31:54 UTC 2005

2005/12/9, Chris Johnson <chris at tinpixel.com>:
> John Handelaar wrote:
> >
> > 1.  I'm testing this tweak to MBR.org at the moment:
> >
> >     ALTER TABLE node SET TYPE = InnoDB;
> >     ALTER TABLE comments SET TYPE = InnoDB;
> >
> >     ...initial results are extremely impressive.
> Any theories as to why this is the case?  What prompted making this change?
> ..chrisxj
"I would as well. Sometimes, however, you will find this situation.
The clustered architecture of InnoDB sometimes lends itself nicely to
large range and grouped expressions, because MyISAM must do
considerable work in bookmark lookups when the temporary set of rows
found is large. In that case, having the data in the index record can
save quite a bit of processing time."
"Sure, MyISAM is fast, but if your logical design requires
transactions, you're free to use one of the transaction-enabled
engines. Further, since MySQL allows you to apply database engines on
the table level, you can take the performance hit on only the tables
that require transactions and leave the nontransactional tables to be
managed by the more lightweight MyISAM engine. With MySQL, flexibility
is the key. "

vi is a real WYSIWYG editor: you see text, you get text.

More information about the development mailing list