News for hackers. Stuff that matters.
Re:Disaster: MySQL 5.5 Flushing by pointyhat on Sunday September 18, 2011 @05:06PM (#3011250)
The issue is x86/x64 being a turd. Throughput of just about everything drops when you go over the 36Gb boundary for some reason. I have no idea why. It can drop by as much as 30%. This is from experience operating VMware on the physically the same type of kit (except with FC SAN / NetApp).

I'd personally rather buy high end SPARC64 kit which has linear performance scalability but we all know what happened to Sun, plus it doesn't run Windows anyway :( whimpers a little

Re:Disaster: MySQL 5.5 Flushing by jeremyw on Sunday September 18, 2011 @05:57PM (#3011383)
Be careful of your NUMA boundaries. 20-30% is exactly the cross-bank access cost.
Re:Disaster: MySQL 5.5 Flushing by spudlyo on Sunday September 18, 2011 @07:12PM (#3011547)
That's what I thought too. There are a lot of weird problems that can happen due to NUMA architecture issues. Reading the numactl for me really drives home just how much I don't understand it.

http://www.linuxmanpages.com/man8/numactl.8.php

Re:Disaster: MySQL 5.5 Flushing by pointyhat on Sunday September 18, 2011 @06:05PM (#3011402)
That's what I was thinking. Need some analysis on it really. We throw money at the problem at the moment and it goes away :)
Re:Disaster: MySQL 5.5 Flushing by zwischenzug on Sunday September 18, 2011 @05:54PM (#3011375)
I've seen DBs run on 128G machines on x6 and have no experience of such problems. Do you have a link or hard evidence of this?

I have seen throughput issues on VMWare machines (and false reporting on standard linux utilities, eg "time" output and various other issues that make me distrust it for performance-sensitive software), but don't know if this is to do with 128G machines; usually it's to do with contention on one network card handling all traffic to disks.

Re:Disaster: MySQL 5.5 Flushing by trafficlight on Sunday September 18, 2011 @05:31PM (#3011320)
I haven't heard/experienced the 36 GB thing since I don't run anything that big right now. Are you aware of any websites or blog posts that talk about it?
Re:Disaster: MySQL 5.5 Flushing by pointyhat on Monday September 19, 2011 @08:47AM (#3013291)