[nycphp-talk] MyISAM vs InnoDB
oorza2k5 at gmail.com
Thu Jan 21 13:05:47 EST 2010
On Thu, Jan 21, 2010 at 1:03 PM, Jake McGraw <jmcgraw1 at gmail.com> wrote:
> 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.
That's what Solr (or Sphinx) is for ;)
More information about the talk