List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:December 16 2008 5:51am
Subject:Re: MySQL 5.0.67 on SMP
View as plain text  
In the last episode (Dec 16), xufeng said:
> 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

The easiest way to check would be to run top, then run a long-running
CPU-hungry query like

SELECT BENCHMARK(100000000,ENCODE('hello','goodbye'));

from two separate mysql client sessions.  You should see two CPUs worth
of load on the system at that point.

In fact, any version of mysql should scale to multiple CPUs as long as
your OS supports kernel-based threads (most do).  Note that a single
query will always only use one CPU, so you need multiple queries in
parallel to use more.

-- 
	Dan Nelson
	dnelson@stripped
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