My forum is around a month old, has around 100 odd members and a maximum of 5 to 15 members online at any given time. Member registration is around 2 to 3 members a week. I also have a wordpress blog running in the root.
Even though the site has such low traffic, I keep getting the 'Too Many Connections' error. Have recorded 4 such errors in one week. When the error occurs, the site goes down for around 5 odd minutes and then comes back up.
I have a reseller account on hostgator and mailed them about this issue asking them if there was a way to increase concurrent MYSQL connections. They replied as follows:
"I am afraid the amount of concurrent connections on a shared environment cannot be increased. Most times, the best thing to do for the database to reduce connections is to index the database so the queries run and complete faster.
This tutorial site should assist in making an index for your databases:http://use-the-index-luke.com/"
I checked out the tutorial but it sounds a bit too complex for a beginner.
I mailed them again asking if shifting to VPS would help deal with the issue and this was their reply:
"On a VPS you would have the option of increasing the mysql connection limit, but upgrading would really only delay the inevitable need to index the database."
My question is as follows: Is indexing the best possible solution to deal with this issue? If so, how do you get started with this as a beginner? Is there a simpler guide available for Xenforo?
Also, how is indexing different from caching systems like Memcache and will installing Memcache over VPS help deal with the issue in a better manner?
Thank you in advance to anyone who replies and apologies for sounding like a complete noob.