List:General Discussion« Previous MessageNext Message »
From:xufeng Date:December 17 2008 5:16am
Subject:RE: MySQL 5.0.67 on SMP
View as plain text  
Yes,I tested from two mysql clients with your code and it showed exactly as
you pointed out.
The top from the mysqld machine showed:

Cpu0  : 100.0% us,  0.0% sy,  0.0% ni,  0.0% id,  0.0% wa,  0.0% hi,  0.0%
si
Cpu1  :  0.3% us,  0.0% sy,  0.0% ni, 99.7% id,  0.0% wa,  0.0% hi,  0.0% si
Cpu2  :  0.0% us,  0.3% sy,  0.0% ni, 99.7% id,  0.0% wa,  0.0% hi,  0.0% si
Cpu3  : 100.0% us,  0.0% sy,  0.0% ni,  0.0% id,  0.0% wa,  0.0% hi,  0.0%
si
Mem:   2074824k total,   977252k used,  1097572k free,    74844k buffers
Swap:  2031608k total,        0k used,  2031608k free,   720236k cached
 
24022 mysql     25   0  100   1:59.25  2.7  554m  55m 2448 R mysqld

24027 mysql     25   0  100   2:12.25  2.7  554m  55m 2448 R mysqld  

Thank you again.

Yours,
Xu Feng
> -----Original Message-----
> From: Dan Nelson [mailto:dnelson@stripped]
> Sent: 2008年12月16日 13:51
> To: xufeng
> Cc: mysql@stripped
> Subject: Re: MySQL 5.0.67 on SMP
> 
> 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
> 
> --
> 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