Re: Extreme high load and low throughput using MySQL & Hybris on an HP DL380G5, quad-core Intel, 4GB RAM

[Timothy Karl]

Rick James Wrote:
-------------------------------------------------------
> High CPU + no I/O + no swapping ->
> * Tunables are ok (for now)
> * Data is smaller than can be cached (so far!)
> * You have slow queries -- Let's fix them!
>
> Look in the slowlog for which queries to focus on.
> Then provide the info Aftab asked for.

While we're going through the slow queries, I'm beginning to wonder why MySQL seems not to be scaling to the hardware which it is running. We had the same application running on the same database, but with the database running on a machine with half the cores (2 cores instead of the 4 that we are currently running) providing approximately the same throughput and with lower load. There is no noticeable improvement on the four-core processor compared to the two-core processor system (both HP DL380 servers).

Has anyone experienced this before or have and answer why this occurs?