My server program seems to cap out at 50% CPU usage. I'm not sure if it's a linux thing or a MySQL thing. is there any way to force it to use more of the CPU? I have two dell poweredge 6850's with four dual core xeons, and I'm seeing that no matter what I do, I can't get the CPU usage to get above 50%. Is it possible that MySQL has some sort of limit on its CPU usage? perhaps I need to change a system setting to allow a user to use more than 50% of the CPU.
this is killing performance on my production servers, so any and all help would be greatly appreciated.
thanks in advance.