NYCPHP Meetup

[nycphp-talk] MyISAM vs InnoDB

Jake McGraw jmcgraw1 at gmail.com
Thu Jan 21 13:03:27 EST 2010


On Thu, Jan 21, 2010 at 12:57 PM, Eddie Drapkin <oorza2k5 at gmail.com> wrote:
> The bottom line is InnoDB is transactional, (configured properly) ACiD
> compliant, doesn't write-lock entire tables and supports foreign keys.
>  Performance, next to these "features," isn't really a concern, IMO.
>
> On Thu, Jan 21, 2010 at 12:55 PM, Lester Leong <lester.bleong at gmail.com> wrote:
>> I'm sure we've all heard one version or another of which was faster. Among
>> the people I've spoken to in person the consensus was MyISAM. But I recently
>> came across a Falcon benchmark online that showed InnoDB being the fastest.
>> I'm sure the real answer is "it depends on your application", but... anyone
>> care to share their thoughts on this?

InnoDB for everything but tables that require fulltext search, which
is not yet supported on InnoDB.

>>
>> _______________________________________________
>> New York PHP Users Group Community Talk Mailing List
>> http://lists.nyphp.org/mailman/listinfo/talk
>>
>> http://www.nyphp.org/Show-Participation
>>
> _______________________________________________
> New York PHP Users Group Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> http://www.nyphp.org/Show-Participation
>



More information about the talk mailing list