Re: Time to put theory to the test?

On 26/04/11 15:04, Rob Wultsch wrote:

On Mon, Apr 25, 2011 at 12:30 PM, J Sisson <sisson.j@gmail.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.

+1

Or even switch to the Mariadb fork and use the crash safe Aria engine [1] instead of Myisam if you must be without transactions. That has the additional benefit of getting out from under the "Big O" - which is always nice!

Cheers

Mark

[1] I have not personally tested that Aria is crash safe, but can attest that Innodb certainly is.