how to maximize mysql performance
We have a dual opteron with 2GB RAM SCSI server, a dedicated MySQL server though. I have tried tweaking my.cnf to fully utilize server resources but it didn't work.
Load max at 0.5 but often occurs too many mysql connections. Any idea what could be the problem?
