I think you are right. I transferred my site to Arvixe shared-hosting business class at $22 per month hoping that it will solve my problem, but a month later today, they are telling me my MYSQL usage is very high and unacceptable and my account will be suspended if I did not do some thing. My daily traffic is about 2000/day now. Their suggestion is to turn off extra plugins/modules/additions to your sites that may be out-dated or are being used excessively by my visitors.JAY6390 wrote:I host myself, that way I have full control over the server - without a vps/dedicated you are going to struggle with this kind of thing I'm afraid. If you're getting that kind of traffic, you should think of the bigger picture, over time most people's server demand grows from customers, and at 1000 hits a day, you should have a vps at the least. Shared hosting just won't cut it.
I'm using opencart 1.4.7 and am wondering if there's anything i can do to opencart if I did not want to upgrade my hosting? It gives me the impression that opencart uses a lot of mysql? Thank you.
Opencart does do quite a few queries to the database as a page is loaded, but it's still only 1 connection. With your visitor count it's not surprising that you have times where your mysql usage is high, although unless they specify how much high is it's hard to know whether they have a low expectancy for the connection count, and that high isn't really all that much
When a host says 15, 25 or 30 connections what they actually mean is each user is allocated 15, 25 or 30 requests to the DB. Im guessing if you have addons or extra code which queries the DB then you will gte this error. Like I am now! Im not sure of the link to this error and actual visitors as Im experiencing it on a site with low traffic. Im guessing it has to do with some dodgy coding from a plugin or mod thats racking up the DB requests. So it doesnt matter if there is only one user if the requests got to 35 kaboom, slow as hell.
Who is online
Users browsing this forum: No registered users and 16 guests