[MTOS-dev] InnoDB performance

[David Jacobs]

It is MyISAM by default, but many, many users switch this to InnoDB
almost reflexively.

David


On 3/5/08, Bud Gibson <fpgibson at gmail.com> wrote:
> Isn't MyISAM the default?  As I recall from past experience, I thought
> InnoDB's main strength was transaction processing.  It would seem blog
> performance is really more bound by query processing.  So, I'd be surprised
> to hear a lot of blog installs were using InnoDB, but that is probably just
> my academic perspective.
>
> Bud
>
>
> On Wed, Mar 5, 2008 at 4:20 PM, David Jacobs <djacobs at apperceptive.com>
> wrote:
> >
> > http://tumblelog.marco.org/post/28044316
> >
> > This post by one of the tumblr developers sheds light on a pretty
> > incredible bug we've seen recently in which InnoDB occasionally
> > under-performs MyISAM by a factor of 5 or 10.
> >
> > It just goes to show how difficult to isolate performance issues are.
> > In addition to the web server, templates, third party plugins, etc.
> > Sometimes you hit an unforeseen bug in something completely external.
> >
> > I'm wondering if some of the (incredibly) slow queries we've seen come
> > out of MT haven't been as a result of this issue.
> >
> > David
> >
> >
> >
> > --
> > David Jacobs
> > http://Apperceptive.com
> > 917 450 0533
> > _______________________________________________
> > MTOS-dev mailing list
> > MTOS-dev at sixapart.com
> > http://www.sixapart.com/mailman/listinfo/mtos-dev
> >
>
>
>
> --
> Bud Gibson
> cell:  734-657-4800
> web:  http://michiganinnovators.org


-- 
David Jacobs
http://Apperceptive.com
917 450 0533