Re: Time to put theory to the test?

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Time to put theory to the test?
Дата
Msg-id 4DB6669B.3090508@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: Time to put theory to the test?  (Rob Wultsch <wultsch@gmail.com>)
Список pgsql-performance
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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Performance
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Performance