View Full Version : Host with Max Concurrent SQL Connections
kduke 04-23-2008, 07:17 AM Iam currently on godaddy on shared hosting but my site with php and mysql is very slow on queries and get a lot of timeouts:(
So far i have contacted the below providers and asked them how many concurrent connections on mysql database they support
hostgator - 25 connections
powweb - 20 connections
hostmonster - 30 connections
Servage - 20 connections
anhosting - 50 connections
How is most reliable and i can count on ? I want to tranfer my domain.
Thanks
~ServerPoint~ 04-23-2008, 09:08 AM I think that you need to take that easy: understand how many you need and chose web hosting provider which will be able to offer you such.
ldcdc 04-23-2008, 11:13 AM Iam currently on godaddy on shared hosting but my site with php and mysql is very slow on queries and get a lot of timeoutsAre you sure this is due to the maximum connections limitation? The slowness would rather point to an overloaded server, which would then also be prone to timeouts.
The maximum connections are not a guarantee of anything really. Your CPU usage could be too high regardless of the number of connections you're using, and could get you into trouble. Generally, when it comes to computing capabilities, your expectations should be in line with your budget. You pay $10 per month, expect to share the server with some 200 accounts, and possibly quite a bit more.
I want to tranfer my domain.You can keep your domain with Godaddy and just change hosts. It's probably the wiser thing to do, as you'd not have all your eggs in one basket then. :)
ephasenetworks 04-23-2008, 09:26 PM I usually suggest potential clients to register the accounts on their own when picking a host. you just never know when some might disappear.
kduke 04-24-2008, 02:46 AM thanks
i'll keep my domain with godaddy but i must change hosts.
i was looking at glitterhost and floppynet.co.uk
anyone can help ?
iHubNet-Matt 04-24-2008, 10:52 AM Did your application create issues on your current host's server and you thought of a new host or you are moving specifically because the other hosts provide more sql connections?
kduke 05-08-2008, 09:10 AM i would prefer a europe hosting cause godaddy hosting is slow
dvduval 05-08-2008, 09:14 AM If you were reaching max connections, you would get an error message most of the time. It sounds like you need to tune up the database queries. They probably are taking too long.
daejuanj 05-08-2008, 09:57 AM Unless you're getting max connections error from MySQL, than that isn't your problem and shouldn't concern you. If your site is slow, it's can be that the servers are overloaded and/or you need to optimize your code because either it's not efficient, or your site is getting popular.
ImageLeet 05-08-2008, 08:33 PM your script might be doing heavy queries or the server is overloaded which is resulting in slowness. If you have maxed out mysql connections then you would have got the error messages instead of timeout.
Jedito 05-08-2008, 10:05 PM If your main concern is the speed, why are you searching for ridiculous large packages? are you aware that most of the time you paid that with speed, reliability and uptime?.
I suggest to search for a host fitting your needs (don't get a package offering 400 GB of space if you use only 2 GB), and then research about them here using the search function.
iJemuel 05-08-2008, 10:13 PM Hello
Try --> http://www.3rdrockhosting.com/
I have been with them for my site (moviegalaxy.org) and I have from 40-60 visitors online in my Wordpress Blog and sometimes over 100 and it loaded fast but I had to move to offshore because of Warez-Linking. Uptime is great and Support too.
kduke 05-09-2008, 04:18 AM i've read about rapidvps and it seems to be the best choice
anyone knows if it has good speed in europe ?
thanks
Iam currently on godaddy on shared hosting but my site with php and mysql is very slow on queries and get a lot of timeouts:(
So far i have contacted the below providers and asked them how many concurrent connections on mysql database they support
hostgator - 25 connections
powweb - 20 connections
hostmonster - 30 connections
Servage - 20 connections
anhosting - 50 connections
How is most reliable and i can count on ? I want to tranfer my domain.
Thanks
It is good that you ask hosting company before taking decision where to go.
I have learn in past that it is always better to build static websites than dynamic (thus not MySql extensive if it is possible) because of static sites are more SEO friendly websites and it is always better if you would like to stay for a long time on shared hosting. If you have static site then usually you do not need to be scared that your sites once it grow above 100.000 - 130.000 unique monthly will make any trouble to the server.
However limiting of connection on shared hosting tell for me personally a lot about power of hosting company and possible overselling.
With dynamic MySql website where limiting is very low (20) you can start to except trouble with 50.000 - 70.000 unique monthly and probably with lower number of visitors.
But you may know that hosting with 50 or more concurrent connections will give you 2x times more visitors without any error.
Generally i look probably somewhere else when i see that MySQL concurrent connections is set too low (under 25 because 25 is usually standard on 70% of hosting companies).
Right now i'm very happy with downtownhost that have set 50 limit what tell a lot about power of their server and company self.
But i would like also to add that RIP sister from Defenderhosting.com Power360Hosting. com did excellent job as hosting company and their limit was set to 0. Thus not any limit.
gate2vn 05-09-2008, 09:01 AM Iam currently on godaddy on shared hosting but my site with php and mysql is very slow on queries and get a lot of timeouts
What kind of script are you using? Your own script or ...? Have you optimized it yet? Just for reference, we allow 50 connections, and find it's more than enough for most accounts, even with vBulletin forums with around 150 members online at the same time
|