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)
Список: pgsql-performance

Скрыть дерево обсуждения

sustained update load of 1-2k/sec  (Mark Cotner, )
 Re: sustained update load of 1-2k/sec  (Bob Ippolito, )
  Re: sustained update load of 1-2k/sec  (Mark Cotner, )
   Re: sustained update load of 1-2k/sec  (Bob Ippolito, )
  Re: sustained update load of 1-2k/sec  (Tom Lane, )
   Re: sustained update load of 1-2k/sec  (Andreas Pflug, )
    Re: sustained update load of 1-2k/sec  (Tom Lane, )
    Re: sustained update load of 1-2k/sec  (Ron, )
   Re: sustained update load of 1-2k/sec  (PFC, )
    Re: sustained update load of 1-2k/sec  (Mark Cotner, )
 Re: sustained update load of 1-2k/sec  (Alex Turner, )
  Re: sustained update load of 1-2k/sec  (Ron, )
   Re: sustained update load of 1-2k/sec  ("Jeffrey W. Baker", )
    Re: sustained update load of 1-2k/sec  (Ron, )
   Re: sustained update load of 1-2k/sec  (Alex Turner, )
    Re: sustained update load of 1-2k/sec  (Ron, )
 Re: sustained update load of 1-2k/sec  ("J. Andrew Rogers", )
  Re: sustained update load of 1-2k/sec  (Mark Cotner, )

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 по дате сообщения:

От: Jeremiah Jahn
Дата:
Сообщение: Re: extremly low memory usage
От: Jeremiah Jahn
Дата:
Сообщение: Re: extremly low memory usage