Re: Joel's Performance Issues WAS : Opteron vs Xeon

От: Jim C. Nasby
Тема: Re: Joel's Performance Issues WAS : Opteron vs Xeon
Дата: ,
Msg-id: 20050423021107.GX58835@decibel.org
(см: обсуждение, исходный текст)
Ответ на: Re: Joel's Performance Issues WAS : Opteron vs Xeon  ("Joel Fradkin")
Ответы: Re: Joel's Performance Issues WAS : Opteron vs Xeon  ("Joel Fradkin")
Список: pgsql-performance

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

Re: Joel's Performance Issues WAS : Opteron vs Xeon  ("Dave Page", )
 Re: Joel's Performance Issues WAS : Opteron vs Xeon  (Andreas Pflug, )
  Re: Joel's Performance Issues WAS : Opteron vs Xeon  ("Joel Fradkin", )
   Re: Joel's Performance Issues WAS : Opteron vs Xeon  (Bruce Momjian, )
   Re: Joel's Performance Issues WAS : Opteron vs Xeon  (Alvaro Herrera, )
    Re: Joel's Performance Issues WAS : Opteron vs Xeon  (Mischa Sandberg, )
    Re: Joel's Performance Issues WAS : Opteron vs Xeon  ("Joel Fradkin", )
     Re: Joel's Performance Issues WAS : Opteron vs Xeon  ("Jim C. Nasby", )
      Re: Joel's Performance Issues WAS : Opteron vs Xeon  ("Joel Fradkin", )
       Re: Joel's Performance Issues WAS : Opteron vs Xeon  ("Joshua D. Drake", )
        Re: Joel's Performance Issues WAS : Opteron vs Xeon  (, )
      Re: Joel's Performance Issues WAS : Opteron vs Xeon  (Christopher Browne, )

On Fri, Apr 22, 2005 at 05:04:19PM -0400, Joel Fradkin wrote:
> And is the system always going to be used by only one user?
> No we have 400+ concurrent users
>
> I guess the question is if this big select is representative of the load you
> expect in production.
> Yes we see many time on the two processor box running MSSQL large return
> sets using 100%cpu for 5-30 seconds.
>
> What happens if you execute the query more times?  Do the times stay the
> same as the second run?
> I will definitely have to pressure testing prior to going live in
> production. I have not done concurrent tests as honestly single user tests
> are failing, so multiple user testing is not something I need yet.

I would very, very strongly encourage you to run multi-user tests before
deciding on mysql. Mysql is nowhere near as capable when it comes to
concurrent operations as PostgreSQL is. From what others have said, it
doesn't take many concurrent operations for it to just fall over. I
can't speak from experience because I avoid mysql like the plague,
though. :)

Likewise, MSSQL will probably look better single-user than it will
multi-user. Unless you're going to only access the database single-user,
it's just not a valid test case (and by the way, this is true no matter
what database you're looking at. Multiuser access is where you uncover
your real bottlenecks.)
--
Jim C. Nasby, Database Consultant               
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


В списке pgsql-performance по дате сообщения:

От: Greg Stark
Дата:
Сообщение: Re: Bad n_distinct estimation; hacks suggested?
От: "Joel Fradkin"
Дата:
Сообщение: Re: Joel's Performance Issues WAS : Opteron vs Xeon