Maximum concurrent connections to mySQL

[Billy]

How many can I have? Could I have 50 concurrent connections to mySQL?

[clio]

Dude, don't try to go to the max. If you do and you crash the server (which is likely) you'll be kicked off. Either Aletia will warn you or angry customers on the same server will get mad at you.

[Billy]

My questions is, is how many mySQL concurrent connections can I have without causing a problem in the 10 GB bandwidth per month plan.

[Zacrifice]

Connecting to a database Doesnt Cost bandwidth!!!!

But then again it can if you have outside people connecting to it.. But
thankfully you cant have that.. and Damn dont try connecting to it any more times then you need becouse there are other people out there using the server too so be consideret!

[Billy]

I said 10 GB plan because I thought differant plans might have differant limits. Look, I'm not connecting from outside, nothing bad. It's just that my site is completely database driven and my message board uses the database too. How many connections is too much? I just want to make sure that when I sign up, I see that I have 20 concurrent connections and I get kicked off because of that, or something.

[Zacrifice]

Oh connections for a Forum.. you should have said so from the start..
only one connection per user is started and then Maintained for that user untill they leave the site..
You would have to have quite a few uesrs on your site at one time to couse any significant problems for the server and other users ..

But dont worry about connection limits if its with a forum i had a forum and got all my friends to come and post (at once) there where 100+ People signing up and posting in 30 Hour and there where no problems.. (Unfortanatly i too the forum down becouse i didnt want nore need it anymore)

[Billy]

So can I have 30, maybe 50 at max times, concurrent connections and not have problems. Because the way I have my site set-up every time a page is generated it creates a connection and disconnects. I could get quite a bit of concurrent users on and considering every page needs a db connections I may need a lot of concurrent connections.

[Dogma]

I would email Aletia ( support@aletia.com ) for the best, most authoritive reply on this...

yes i know i can't spell...

[alexodin]

Billy, if you dont mind may I ask you ?

50 connections is a HUGE number!
I cant belive that a web site (i'm not talking about sites like microsoft.com) requires such a big number of connection.

The connection should be a "share" thing, it should be open and close when it needed. You dont have to have each db connection per user - it is wrong way.

There are a lot of thing that can help you to reduce this number.

There is a real example:neowin.net

Check it out, those guys found good way to solve the problem.

If you are interested, we can talk about it

[Billy]

I know. I try to connect, query the db and disconnect ASAP, but still every page view requires a query to the database wich requires to connect to it. The site could very well at max times have around 100 concurrent users over a 15 minute time period on the site and the forum. I know that they wont all be connected at the same time...but I could need quite a few concurrent connections.

[Zacrifice]

Hey Billy, This site of yours is it already built and up? or is it going to be a new site?