mysql_pconnect() mysteries
| From: | Patrik Wallstrom | Date: | Tue, 15 Aug 2000 18:58:40 +0000 |
| Subject: | mysql_pconnect() mysteries | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2065@lists.php.net to get a copy of this message | ||
I'm using pconnect(), and still get a lot of connections to my mysqld:
+------+----------+------------+---------------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State |
Info |
+------+----------+------------+---------------+---------+-------+-------+------------------+
| 21 | root | localhost | sonoxlog | Query | 0 | NULL |
show processlist |
| 258 | root | localhost | sonoxorderbok | Sleep | 12520 | |
NULL |
| 2374 | external | dub.nmd.se | sonoxsession | Sleep | 44 | |
NULL |
| 2375 | external | dub.nmd.se | sonoxsession | Sleep | 44 | |
NULL |
| 2376 | external | dub.nmd.se | sonoxsession | Sleep | 13 | |
NULL |
| 2377 | external | dub.nmd.se | sonoxsession | Sleep | 12 | |
NULL |
| 2378 | external | dub.nmd.se | sonoxsession | Sleep | 10 | |
NULL |
| 2379 | forums | dub.nmd.se | sonoxforums | Sleep | 10 | |
NULL |
| 2380 | external | dub.nmd.se | sonoxsession | Sleep | 9 | |
NULL |
| 2381 | forums | dub.nmd.se | sonoxforums | Sleep | 10 | |
NULL |
| 2382 | external | dub.nmd.se | sonoxsession | Sleep | 9 | |
NULL |
| 2383 | external | dub.nmd.se | sonoxsession | Sleep | 8 | |
NULL |
| 2384 | forums | dub.nmd.se | sonoxforums | Sleep | 8 | |
NULL |
| 2385 | external | dub.nmd.se | sonoxsession | Sleep | 6 | |
NULL |
| 2386 | external | dub.nmd.se | sonoxsession | Sleep | 4 | |
NULL |
| 2387 | external | dub.nmd.se | sonoxsession | Sleep | 4 | |
NULL |
| 2388 | external | dub.nmd.se | sonoxsession | Sleep | 2 | |
NULL |
| 2389 | external | dub.nmd.se | sonoxsession | Sleep | 0 | |
NULL |
+------+----------+------------+---------------+---------+-------+-------+------------------+
I have set the wait_timeout to 120, but this won't work when I get some
volume in traffic for the web site. Why isn't the connections truly
persistent? It seems that PHP sets up a new connection for each page that
it executes. And a new connection for each db used.
Comments?
--
patrik wallstrom | f o o d f i g h t
tel: +46-8-6188428 | s t o c k h o l m
gsm: +46-708405080 | - - - - - - - - -
fax: +46-859827151 |