[GRLUG] FYI - old mysql and new gear

[scott.tanner at comcast.net]

Yes, that info's available under /proc/cpuinfo: 

processor ( id as seen by the kernel ) 
physical id (actual die this processor is on ) 
core id (actual core on the die this processor is on ) 

For the Intel i3 processor on my laptop, I have: 

processor : 0 
physical id : 0 
core id : 0 

processor : 1 
physical id : 0 
core id : 0 

So 2 processors on the same die/core - hyper-threading is enabled! 

Since I've disabled HT on the MySQL servers, only the real cores are left. I've tried to balance out the CPU's between both physical dies, but I'm not sure if it made much difference. Another good test (once I get some time). 


Regards, 
Scott 
----- Original Message -----
From: "Mike Williams" <knightperson at zuzax.com> 
To: "Mailing List for LUG in greater Grand Rapids, MI area." <grlug at grlug.org> 
Sent: Thursday, September 22, 2011 2:29:37 PM 
Subject: Re: [GRLUG] FYI - old mysql and new gear 

On 9/22/2011 2:20 PM, scott.tanner at comcast.net wrote: 


I'm very familiar with nice, but its the taskset command I was referring to, which takes affect at the scheduler: 

http://www.cyberciti.biz/tips/setting-processor-affinity-certain-task-or-process.html 


Regards, 
Scott 
That's good stuff to know for the day when I get to play with a box that has more than2 actual cores. Regarding turning off hyperthreading, I assume it's known which pairs of CPU's are actually the same core? Maybe you could see if there's any performance difference running it on 1, 3, 5, and 7 versus 1, 2, 3, and 4 (assuming that 1 and 2 are core the first core, 2 and 3 are the second, etc). 


-- 
This message has been scanned for viruses and 
dangerous content by MailScanner , and is 
believed to be clean. 
_______________________________________________ 
grlug mailing list 
grlug at grlug.org 
http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug 
-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shinobu.grlug.org/pipermail/grlug/attachments/20110922/f38643eb/attachment-0001.html>