<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial; font-size: 12pt; color: #000000'>I'm going to try using affinity to limit the CPU access and run a few benchmarks - should be an interesting test.<br><br>I've heard there's a fair amount of overhead when running MySQL in virtual machines, specifically due to the abstraction layer between the raid controller and guest. It would be interesting to test, but difficult to setup now that the server is running in production - It doesn't look like you can limit the number of processors for Dom0.<br><br>We purposely don't run anything else on these servers to reduce any contention, so limiting the CPU's isn't a very big deal, however wasting 4 / 16 cores (real / +HT) is pretty silly.<br><br>Thanks guys!<br>Scott<br><hr id="zwchr"><b>From: </b>"Ben Rousch" <brousch@gmail.com><br><b>To: </b>"Mailing List for LUG in greater Grand Rapids, MI area." <grlug@grlug.org><br><b>Sent: </b>Monday, September 19, 2011 4:56:22 PM<br><b>Subject: </b>Re: [GRLUG] FYI - old mysql and new gear<br><br>On Mon, Sep 19, 2011 at 4:45 PM, Michael Mol <mikemol@gmail.com> wrote:<br>> On Mon, Sep 19, 2011 at 4:36 PM, <scott.tanner@comcast.net> wrote:<br>>> Just thought I'd share an interesting discovery with the group. This may be<br>>> common knowledge to others, but it was a bit of a surprise to me. We're in<br>>> the process of upgrading the servers which run our primary MySQL DB's<br>>> (version 5.1):<br>>><br>>> Old Server New Server<br>>> ---------------------------------------------------------<br>>> Sun X4200 Silicon Mechanics R516<br>>> 4 x 2.4GHz 12 x 3.2GHz (+ HT = 24 threads)<br>>> 16GB Ram 144GB Ram<br>>> 12 disks - SCSI 24 disks - SAS & SSD<br>>><br>>><br>>> After getting the new servers setup and our databases copied over, I ran<br>>> sysbench to get some performance benchmarks of the new servers. Surprise -<br>>> performance was nearly identical or slightly worse. I disabled HT, still no<br>>> real improvement. After a bit of searching on the web, I found the older<br>>> versions of MySQL had issues with multi-threading beyond 8 threads. I setup<br>>> an init script to hot-remove CPU's via sysfs, and voila - performance<br>>> increased substantially. There are patches from Yahoo, Google, and Percona<br>>> to correct this issue on the older MySQL versions, and the newer versions<br>>> are supposedly better at handling 32+ threads.<br>><br>> Very interesting.<br>><br>> A thought...Rather than removing your extra cores, perhaps there's<br>> some way to set CPU affinity, so MySQL is only allowed to use eight of<br>> them? That way, the other processes on your system can stay out of the<br>> way of your database server, and spend cycles on other cores.<br>><br>> If you get affinities working, you might also consider running<br>> multiple instances of mysqld, putting different databases on different<br>> sets of cores.<br><br>How about putting it in a virtual machine that only has access to 8 cores?<br><br>-- <br> Ben Rousch<br> brousch@gmail.com<br> http://clusterbleep.net/<br><br>-- <br>This message has been scanned for viruses and<br>dangerous content by MailScanner, and is<br>believed to be clean.<br><br>_______________________________________________<br>grlug mailing list<br>grlug@grlug.org<br>http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug<br></div><br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</body></html>