Too Many Connection

Anon

Hi,

Currently I am writing a php page (let's call it content page) that will auto-refresh itself every 20 secs. The page will connect to database, retrieve a list of records.

Previously I put mysql_connect straight in each of the page (admin section, change password and other pages that require some db interaction). Then I got around near 200 users viewing the content page for around 10 hours everyday. After that errors start popping out --> Too many connection to mysql.

Then I put mysql_free_result and mysql_close at the end of each page. But it didn't solve the problem. So from here I am puzzled whether mysql_close is any useful or not.

I would like some suggestion on this case. Is there a way to reduce connection in this sense? Please advice me. Thanks. 🙂

[deleted]

The only thing you can do to reduce the number of connections is exactly that; reduce the number of connections.
If you have 200 users viewing the page at the same time, you will need 200 mysql connections, there's nothing you can do about that, not with proper closing of connections and not with pconnect.

You'll have to increase the max number of connections that mysql can handle.

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

Anon

Vincent, thanks for your reply.

I just started php for around two weeks and consider myself a newbie I will like to ask few questions.

Will mysql free the connection once the script ended?
I try to put all the db function into a db.inc page, to be included into my content page. I tend to write functions like this in the db.inc:

$link_id = mysql_connect($host, $usr, $pass);

function db_query($sql) {
GLOBAL $link_id;

$rs = mysql_query($sql, $link_id);
return $rs;
}

Will this be any help to reduce my connection? This is script is taught by a friend of mine who says the $link_id can be reused so that it is like only one connection openned at one time.

But for me I percept it as the same as mine one (which has no include and all the db call is in one page), cause I think the include is actually going to run the mysql_connect again. Or did I percept it wrong here?
I got an idea after I hear my friend saying reusing. Can I just put this $link_id into a session and when the page refresh and I just use it again and again?

Thanks for helping out. Thanks a lot.