Ive read that sometimes there can be too many connections to the database. Apart from optimizing your scripting code, how do you go about fixing this? Do you simply add new databases or upgrade to a bigger MySQL database? Thanks
no the reson for it is that there are limmits placed on your database/s that only allow so many conections at once. if you are with 1&1 then theres are very low and will get a msg saying too many connections to the database quite often if you get alot of traffic.
Thanks madkad What webhost would you recommend for a php/mysql site with 500+ unique visitors at any one time?
This is a common problem with shared hosting. Often it's not even a problem with your applications but with someone on the same server with an app running amok. There is no foolproof way to avoid this. If you can afford it, upgrade to Virtual Private Hosting with A Small Orange.
like the other member says its commen with shared hosting, so dedicated server can well will help, or see what other hosts can help you out. who are you with?
Currently im not with anyone. Up until today i was with GoDaddy ('Economic' hosting plan) until i found out that their MySQL servers only support 50 (yes 50) active connections.
its a joke as alot of hosting companies dont show these details, but they show how big a database is, crafty if you ask me
I would suggest going dedicated, or if you can't afford a dedicated server for a good price and lack OS management skills, then VPS may help (with control panel, for example based on Virtuozzo)...however, VPS may still require some level of OS management
Hi everyone, thanks for all your comments. I emailed A Small Orange, HostGator and DreamHost, asking how much active connections (technical term: 'max_connections') their MySQL servers can hold. These were the results: A Small Orange = 25 DreamHost = 25 HostGator = 500 GoDaddy has double that of Small Oranges and Dreamshosts! Anyway, these are for shared hosting (im guessin), but im gonna go with HostGator.
??? Is that shared hosting with ASO? I'm with VPS and my forum often crashed on previous shared hosting with max=500. I'm having no problems with ASO VPS at all. Be wary: How this is set up is important. If you have max=500 shared among everyone else on the server, it's not as good as it sounds, believe me.
The 25 connect for ASO mustve have been for shared. I done some further research on HostGator (reading up on their forum) and found that they DONT offer 500 connects. They only offer that for dedicated, even though they emailed me telling me it was 500. Now im looking into MediaTemple...
500 over shared hosting is alot really and if they have alot on the same server that is going to make problems I am sure :| The website you own, does it make you any revienue?
If you're getting too many connections on shared hosting then you should really check you're using the most efficient software and seriously consider upgrading to a vps or dedicated plan. You'll have more resources and be able to tweak your server and mySQL configuration to optimize it for your site. Shopping around may or may not get you a bit more reliability at the moment, but if your site is growing you'll need to upgrade at some point anyway.
No Shared hosting plan can offer you beyon 50 connection to database at a same time . Definately you have to go with VPS or Dedicated . Also if you cannt afford dedicated server then few Hosts offer Semi-Dedicated servers . It means Dedicated server is shared between few clients only. The exact figure of "few " depends on Host .