List:General Discussion« Previous MessageNext Message »
From:ewen fortune Date:December 16 2008 9:03am
Subject:Re: MySQL 5.0.67 on SMP
View as plain text  
Hi,

I think the known problems with MySQL and SMP architecture are more
based on storage engine restrictions, so InnoDB for example does not
scale well beyond say 8 cores.

There are a number of patches to help solve some of these scaling problems.
http://www.percona.com/docs/wiki/release:start
http://code.google.com/p/google-mysql-tools/

You can read about these here
http://www.mysqlperformanceblog.com/2008/10/20/improved-innodb-rw_lock-patch/

Ewen

On Tue, Dec 16, 2008 at 4:44 AM, xufeng <xufeng@stripped> wrote:
> Hi
>
> Is there a way to check if my MySQL5.0.67 works well on SMP?
> I have two CPUs with each two cores, and I want to know if MySQL distributes
> loads over the two CPUs.
> System OS: Linux 2.6.9-42.ELsmp
> MySQL Version: 5.0.67
> Intel(R) Xeon(TM) CPU 3.00GHz * 2
>
> Thank you in advance.
>
> Yours,
> Xu Feng
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
Thread
MySQL 5.0.67 on SMPxufeng16 Dec
  • Re: MySQL 5.0.67 on SMPDan Nelson16 Dec
    • RE: MySQL 5.0.67 on SMPxufeng17 Dec
  • Re: MySQL 5.0.67 on SMPewen fortune16 Dec
  • need help with query...Lamp Lists17 Dec
    • Re: need help with query...Jason Pruim17 Dec
      • Re: need help with query...Andy Shellam17 Dec
        • RE: need help with query...Jerry Schwartz17 Dec
          • Re: need help with query...Andy Shellam17 Dec
    • RE: need help with query...Jerry Schwartz17 Dec
  • Re: need help with query...Lamp Lists17 Dec
    • Re: need help with query...Andy Shellam17 Dec
  • Re: need help with query...Lamp Lists17 Dec
RE: MySQL 5.0.67 on SMPxufeng16 Dec
  • Re: MySQL 5.0.67 on SMPJoerg Bruehe16 Dec