Maximum SQL Connections

PhilDPhoto · February 24th, 2007, 11:22 AM

I was just revising my site, to ensure that it doesn't break the resource allocations of a shared server.

However, my whole site runs from an SQL Database (content etc) like a small cms, However, I'm a little confused as to the 15 maximum MySQL User Connections, does this mean if there is 16 users on my site at any one time, then there will be 16 user connections to my MySQL database? and therefore "abusing the resources"?

Or have I got myself a little mixed up?

**lonelydreamer** · February 24th, 2007, 12:10 PM

It means 15 connections at one time, your CMS will open a connection for usually less than a second to pull its information out of the DB and then close the connection, so, if you have more than 15 people on your site at one time, you shouldn't be "abusing resources" until you have many more than 15 people on at a time.

PhilDPhoto · February 24th, 2007, 12:14 PM

ok, thanks for that, I was getting a little worried

My CMS is self written, will I manually need to write in with a bit of PHP to close the connection once it's retrieved it's data or is this an automatic function?

**lonelydreamer** · February 24th, 2007, 12:20 PM

I believe (someone please correct me if i'm wrong) that if you open your connection with mysql_connect(), it will create a non-persistent connection which simply means it closes after your code is executed. So you shouldn't have anything to worry about.

**DewKnight** · February 24th, 2007, 2:42 PM

Quote:

Originally Posted by lonelydreamer

I believe (someone please correct me if i'm wrong) that if you open your connection with mysql_connect(), it will create a non-persistent connection which simply means it closes after your code is executed. So you shouldn't have anything to worry about.

I'm pretty sure that I've seen it somewhere that it will close itself, but I still like to put mysql_close(); at the end of a page just to be safe.

PhilDPhoto · February 24th, 2007, 8:21 PM

Thanks, i've been reading a few threads about suspended accounts, i would rather take precautionary measures than complain needlessly later

**lonelydreamer** · February 24th, 2007, 11:05 PM

Quote:

Originally Posted by PhilDPhoto

Thanks, i've been reading a few threads about suspended accounts, i would rather take precautionary measures than complain needlessly later

I like the way you think

But on a side note, you might want to put your server's name, and one of those nifty SL average images in your signature. Instructions on how to do both are in the announcement forums, I believe.

**Kayla** · February 24th, 2007, 11:19 PM

I *love* the way Phil thinks! Thank you for being so responsible!

February 24th, 2007, 11:22 AM	#1 (permalink)
PhilDPhoto Registered User Fresh Surpasser Joined in Feb 2007 Lives in England, UK 11 posts Gave thanks: 1 Thanked 1 Time in 1 Post	Maximum SQL Connections I was just revising my site, to ensure that it doesn't break the resource allocations of a shared server. However, my whole site runs from an SQL Database (content etc) like a small cms, However, I'm a little confused as to the 15 maximum MySQL User Connections, does this mean if there is 16 users on my site at any one time, then there will be 16 user connections to my MySQL database? and therefore "abusing the resources"? Or have I got myself a little mixed up?

February 24th, 2007, 12:10 PM	#2 (permalink)
lonelydreamer Surpass Fan Comfy Contributor Joined in Dec 2004 224 posts Gave thanks: 6 Thanked 19 times	It means 15 connections at one time, your CMS will open a connection for usually less than a second to pull its information out of the DB and then close the connection, so, if you have more than 15 people on your site at one time, you shouldn't be "abusing resources" until you have many more than 15 people on at a time. __________________ SH106 - out-burst.org

February 24th, 2007, 12:20 PM	#4 (permalink)
lonelydreamer Surpass Fan Comfy Contributor Joined in Dec 2004 224 posts Gave thanks: 6 Thanked 19 times	I believe (someone please correct me if i'm wrong) that if you open your connection with mysql_connect(), it will create a non-persistent connection which simply means it closes after your code is executed. So you shouldn't have anything to worry about. __________________ SH106 - out-burst.org

February 24th, 2007, 11:19 PM	#8 (permalink)
Kayla Senior Member Surpass Staff Joined in May 2003 Lives in Orlando 25,189 posts Gave thanks: 982 Thanked 879 times Total Awards: 1	I love the way Phil thinks! Thank you for being so responsible! __________________ Add Surpass on Twitter and Facebook for great deals and contests FIRST!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

February 24th, 2007, 12:14 PM	#3 (permalink)
PhilDPhoto Registered User Fresh Surpasser Joined in Feb 2007 Lives in England, UK 11 posts Gave thanks: 1 Thanked 1 Time in 1 Post	ok, thanks for that, I was getting a little worried My CMS is self written, will I manually need to write in with a bit of PHP to close the connection once it's retrieved it's data or is this an automatic function?

February 24th, 2007, 8:21 PM	#6 (permalink)
PhilDPhoto Registered User Fresh Surpasser Joined in Feb 2007 Lives in England, UK 11 posts Gave thanks: 1 Thanked 1 Time in 1 Post	Thanks, i've been reading a few threads about suspended accounts, i would rather take precautionary measures than complain needlessly later

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)