note 70105 added to function.mysql-free-result
| From: | wes at powerhousestudios dot ca | Date: | Tue, 03 Oct 2006 16:23:24 +0000 |
| Subject: | note 70105 added to function.mysql-free-result | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-117983@lists.php.net to get a copy of this message | ||
this function is awesome. as far as i can tell, the "Open Tables" field from the
mysql_stat() function updates faster than without it.
i was having problems with too many connections to a database, so i duplicated that db across
different servers. i then made a php page that, judging by the "Open Tables" field,
decides which server to connect to using a tiered system. sometimes the "Open Tables"
would get super high, and i'd have to get it to delay connecting to any db at all to give the
servers some time to recupe, and once the dbs' "Open Tables" dropped below my set
max, it would carry on with the connection delegations.
ever since i added mysql_free_result() in, it has been noticeably faster at recovering from high
"Open Tables".
im sure i'll be putting this function alongside my mysql_close()'s, cuz why the heck not?
----
Server IP: 66.207.199.35
Probable Submitter: 24.79.77.79
----
Manual Page -- http://www.php.net/manual/en/function.mysql-free-result.php
Edit -- https://master.php.net/note/edit/70105
Del: integrated -- https://master.php.net/note/delete/70105/integrated
Del: useless -- https://master.php.net/note/delete/70105/useless
Del: bad code -- https://master.php.net/note/delete/70105/bad+code
Del: spam -- https://master.php.net/note/delete/70105/spam
Del: non-english -- https://master.php.net/note/delete/70105/non-english
Del: in docs -- https://master.php.net/note/delete/70105/in+docs
Del: other reasons-- https://master.php.net/note/delete/70105
Reject -- https://master.php.net/note/reject/70105
Search -- https://master.php.net/manage/user-notes.php