Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group