I have a 24 Core Opteron 8435 system with 48GB of RAM. However, the performance is way below that of our 6 Core Intel with 30GB of RAM. I wonder if anyone could this of why? We're running a Drupal website off this box with mysql 5.0 installed on the same box. PHP 5.6.13 and Apache 2.2.9. Every now and then the response is quicker than lightening but most times it struggles. mpstat -P ALL shows little activity but it's almost like the apache children are having problem starting up but once started are fine? Is this a CPU cache issue?
My dmesg is at http://pastebin.com/KSWxqmJe
This machine is not in production as yet and is in test and our hosting facility so no problems with making changes/reboots etc.
I have turned off BIOS Memory Interleaving which has indeed made a difference but as yet still about 100ms behind the 12 core box on ab -c 10 -n 10.
I can see the process' moving better across the cores now too.
What you need to do is produce a synthetic load in your lab on a similar machine, and compare its behaviour with another one where the problem does not occur.
If you deployed this into production without trying it in a test environment, you can expect trouble.
The idea of running MySQL on the same machine as a web server for a high performance environment troubles me slightly ... you'll get better performance with a small load but it will generally scale less. However your experience may vary.
The key is to reproduce the environment exactly and run load testing against it, this is not necessarily easy, but it's the only way to know what's going to happen before getting it into production and having it affect your users.
Did you make any tweak at all? otherwise I think you can only only expect an speed increment but not a wow change.
Can you just split the server in two smaller boxes so you have DB AND webserver ? that will do all the debugging process much more easier.
for apache, are you using forking ? if so try tweaking the child processes number, that will give you more concurrency ( the default number of 150 processes is too low, at least on centos)
I don't know much about drupal. Are the system tables InnoDB? I soo try to read a little about how to increase the buffer memory for mysql. Stick to this