Re: sustained update load of 1-2k/sec

Поиск
Список
Период
Сортировка
От Ron
Тема Re: sustained update load of 1-2k/sec
Дата
Msg-id 6.2.3.4.0.20050819105751.05c1a760@pop.earthlink.net
обсуждение исходный текст
Ответ на Re: sustained update load of 1-2k/sec  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список pgsql-performance
At 09:58 AM 8/19/2005, Andreas Pflug wrote:

>The 1-2k xact/sec for MySQL seems suspicious, sounds very much like
>write-back cached, not write-through, esp. considering that heavy
>concurrent write access isn't said to be MySQLs strength...

Don't be suspicious.

I haven't seen the code under discussion, but I have seen mySQL
easily achieve these kinds of numbers using the myISAM storage engine
in write-through cache
mode.

myISAM can be =FAST=.  Particularly when decent HW is thrown at it.

Ron



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

Предыдущее
От: Ron
Дата:
Сообщение: Re: sustained update load of 1-2k/sec
Следующее
От: Jeremiah Jahn
Дата:
Сообщение: Re: I'm configuraing a new system (Bigish) and need some