Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]

From: Alvaro Herrera
Subject: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]
Date: ,
Msg-id: 20070302150129.GF4885@alvh.no-ip.org
(view: Whole thread, Raw)
In response to: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  ("Jim C. Nasby")
Responses: Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden)
Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Scott Marlowe)
List: pgsql-performance

Tree view

[kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  ("Jim C. Nasby", )
 Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Alvaro Herrera, )
  Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden, )
   Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden, )
    Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Stefan Kaltenbrunner, )
     Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden, )
      Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Stefan Kaltenbrunner, )
       Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Tom Lane, )
        Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Arjen van der Meijden, )
        Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Stefan Kaltenbrunner, )
    Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Richard Huxton, )
  Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]  (Scott Marlowe, )

> From: Kris Kennaway <>

> We have recently made significant progress on optimizing for MySQL
> running on an 8-core amd64 system. The graph of results may be found
> here:
>
>   http://www.freebsd.org/~kris/scaling/scaling.png
>
> This shows the graph of MySQL transactions/second performed by a
> multi-threaded client workload against a local MySQL database with
> varying numbers of client threads, with identically configured FreeBSD
> and Linux systems on the same machine.

Interesting -- the MySQL/Linux graph is very similar to the graphs from
the .nl magazine posted last year.  I think this suggests that the
"MySQL deficiency" was rather a performance bug in Linux, not in MySQL
itself ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-performance by date:

From: Ron
Date:
Subject: Re: strange performance regression between 7.4 and 8.1
From: "Alex Deucher"
Date:
Subject: Re: strange performance regression between 7.4 and 8.1