Re: Time to put theory to the test?

On Tue, Apr 26, 2011 at 8:13 AM, J Sisson <sisson(dot)j(at)gmail(dot)com> wrote:
> On Mon, Apr 25, 2011 at 10:04 PM, Rob Wultsch <wultsch(at)gmail(dot)com> wrote:
>> Tip from someone that manages thousands of MySQL servers: Use InnoDB
>> when using MySQL.
>
> Granted, my knowledge of PostgreSQL (and even MSSQL) far surpasses my
> knowledge of MySQL, but if InnoDB has such amazing benefits as being
> crash safe, and even speed increases in some instances, why isn't
> InnoDB default?  I suppose the real issue is that I prefer software
> that gives me safe defaults that I can adjust towards the "unsafe" end
> as far as I'm comfortable with, rather than starting off in la-la land
> and working back towards sanity.

Because for many read heavy workloads myisam is still faster. Note
that even if you use innodb tables, your system catalogs are stored in
myisam. The Drizzle project aims to fix such things, but I'd assume
they're a little ways from full production ready status.