http://www.databasejournal.com/featu...0897_1402311_4
One of the primary errors when the system gets busy is Too many connections. It's generally no problem to increase the number. You can see how close you're running to max by comparing max_connections with the extended-status variable threads_connected. If you regularly come close, the time for some improvements is drawing near.
One improvement you can make on a code level is to use persistent connections rather than ordinary connections (e.g. using pconnect() rather than connect() in PHP), In this case, you may have a scenario with something like:
max_connections - 200
threads_connected - 155
threads_running - 1
where would I put the macconections etc?? my server has 512 megs of ram getting ready to buy a 3rd server if canidid ever writes me back,