I have a problem. I recently purchased a new server (dual opteron), to replace my pentium 4, which has been struggling. To my surprise, the new servers's load is about 10x of what I was getting on the p4.
Mysql being the cpu/memory hog. I noticed that there are only 2 mysql threads going. On my old box I usually had 400-500.
How can I turn off this 2 thread cap? my.cnf files on both servers are identical.
newer versions of mysql run in threated version so that is 100% normal.
Steven Ciaburri | Industry's Best Server Management- Rack911.com
Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance
Check your /etc/my.cnf and eventualy replace with the big version.
try to skip innodb if you don't need them
Check php scripts and try to turn off persistent connections. In my experience that helps a lot.
If is dedicate only for mysql that could be from network connection.