Therefore, I emailed my service provider and they responded basically that all the requests to mysql while students take the quiz is above a 50,000 limit per hour. I was wondering if this could be true. Basically, if approximately 10 students were taking a 20 question quiz per hour, how many requests could they be making to mysql.
My service provider's proposed solution was to pay them more money for a better account. I don't really have the money (From $5/month to $30/month), so I was considering other possibilities before I payup. Thanks in advance for any thoughts related to this.
I attached their message below:
You may need to upgrade your account to a vps accout. The bottom line is you are on a shared account with alot of other users. Each user has a limit of 5 databases, and each user has a set quota. When your students access the database to take these quizzes, they are using up alot of that users quota. Each hour you are allowed 50000 queries, now after an hour it will reset it self. The fact that you remake the user with a new password is basically starting that user new. Now we could move you to newer server that is less full, but eventually you will have to repeat this process. If you were to have a vps account, you will not run into these types of problems. Your server, will only have you and a couple other people on it, much quicker, much more reliable. Plus the fix for this is to restart mysql and apache. You will have access to the backend to do so without having to go through us.