I'm looking for some suggestions for a host where MySQL connections aren't quickly killed off like with many budget providers. I have an SMF forum and for it to run I need for a greater use of MySQL connections. I'm with Host Gator for the site at the moment, and have previously used Reseller Zoom. Cheers
You might also want to state : Whats the queries trend like? How many bandwidth usage and disk space do you require?
If you want to do that then get your own VPS or Dedicated Server. No host, no matter how serious, is going to let you use as much of a shared resource (like a database server) as YOU want to the detriment of other users. It has nothing to do with budget providers and everything to do with people wanting dedicated resources for the price of shared hosting - isn't going to happen. If you want or need more resources then get your own dedicated resource.
For Mysql intensive website hosting, get yourself a server with SSD and good amount of RAM or large RAM and normal HDDs. I/O is a very important factor determining the mysql's performance and SSD highly improve its efficiency. You can also replace the hdd requirement by a large RAM and cache all DB queries in it.
A simple answer to that is go for any service that offer a raided hdd or if you want a much better solution like anands said get a server with ssd hdd. MySQL can be hosted remotely so get you sql hosted on trusted hosting services that offer such service.
Usually shared hosting account only allow about 20-25 max mysql connection. It is to protect another customers on the same server. But if I remember correctly, my web host: medialayer.com, give about 50-100 max mysql connection. (Please contact them directly to make sure of it). If it is not enough, you may go with VPS or dedicated server.
That's not true, every single host has different settings there is no "one size fits all" for that, It's up to them, unless it's default, I have mine at 200 connections as I run high end servers and I normally don't have more then 50 users on each server, so even if they all ran it, it couldn't max it out even if they tried. Most large providers won't change the settings for one user alone, that's why small hosts are better they carter to the smaller businesses/customers.
Well...that's your host. Don't say usually shared hosts offer 20-25, because that simply isn't the case.
Help me out here guys coz I am a little confused. What kind of applications are your customers running that have that number of connections? We monitoring our MS SQL and MySQL DB servers closely and we've never seen ANY customer use that number of connections. In fact, I've never seen any customer use over 10 connections - ever, and we host thousands and thousands of web sites and databases. One customer, that we closely monitor, and who has several million page views per day, never has more than 6 connection to MS SQL 2008 at any single time yet the whole site is DB driven. Another customer whose pages view are the hundreds of thousands per day and uses MySQL never has more 4 connections open. Our max connections per user is set at 200 too. Maybe it's just a Windows thing, but these figures seem extraordinary to me. P.S. Sorry for going off-topic a little.
That's a surprise - really, it is. Although we have some customer pushing hefty numbers, the majority of our users are like everyone else, running a variety of applications, databases, some busy, some not so busy, but I've never seen massive numbers of DB connections in total...never mind for a single database. Maybe we've just been lucky or maybe it's just a function of the operating system - I'm sure I don't know - but from experience I'd be worried if our systems alerted us to 100 concurrent connections from a single user as we've never seen figures anywhere near that - and our DB connections are monitored and graphed so we can see what is happening in realtime. I guess you learn something new every day.
Normally poorly written scripts are what is causing such high usage. Even some of the popular forums out there are very poorly written.
There is a limit of usage a mysql site can consume on a shared server, so of course when your usage will be more than the one mentioned in that host's terms of services section, they can even kill (delete) your whole account. However, killing connections manually does not happen normally.
WordPress blog is designed to take one mysql database. For each wordpress blog that you are installing, it will require one single mysql database to be occupied.