Re: Time to put theory to the test?

From: Rob Wultsch <wultsch(at)gmail(dot)com>
To: J Sisson <sisson(dot)j(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Time to put theory to the test?
Date: 2011-04-26 03:04:57
Message-ID: BANLkTikzg0JMtXPB0E=v_=GTPh2AoAf3oQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Apr 25, 2011 at 12:30 PM, J Sisson <sisson(dot)j(at)gmail(dot)com> wrote:
> machines, and virtually every MySQL machine has required data cleanup
> and table scans and tweaks to get it back to "production" status.

Tip from someone that manages thousands of MySQL servers: Use InnoDB
when using MySQL. Using a crash unsafe product will yield undesirable
results when a server crashes. It is also faster for many use cases.

InnoDB is crash safe. It is just that simple.

--
Rob Wultsch
wultsch(at)gmail(dot)com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2011-04-26 05:30:58 Re: Performance
Previous Message Robert Haas 2011-04-25 23:54:34 Re: Slow deleting tables with foreign keys