All seemed ok at first, until in the early hours of Monday morning my site went down for 20 minutes:
Zend_Db_Adapter_Mysqli_Exception: Too many connections - library/Zend/Db/Adapter/Mysqli.php:333 (x16 logs)
Did a bit of searching here, which suggested it was a problem with my server, spoke to Nimbus who I host with and they altered a setting.
This morning from around 2AM (problems started around the same time?) the same error (too many connections) happened again, this time however it took the site offline for 5 and half hours. The xf_session table also crashed and created hundreds of reports, which was repaired.
Again a bit of searching, and the addon Sitemap came up as a possible issue? Reported to Nimbus again who suggested I could possible need more memory, (they are not sure on the addon). So just in case I disabled the addon.
Then the following errors popped up:
Got error 28 from storage engine
Error writing file '/tmp/.......
Finally followed again by the "too many connections" error.
Now I am reasonably certain that my site is just not handling the amount of traffic to cause these issues. So I can only assume that something in the installation is causing these issues. Is there anyway to pinpoint what it may be?