I've got a big problem on my websites at the moment.
At peak times I get too many connection errors on my websites which prevents some people from viewing.
- Dedicated server
- Optimized tables with indexes
- non-persistent connections.
What I do is make the mysql connect at the start of each page, run the queries and let the page auto disconnect at the end of each script.
Would it be better to do numerous connect and close after each query?
Any other ideas how I can beat this crippling problem?