[PHP-DB] mysql_pconnect() mysteries From: Patrik Wallstrom (pawal <email protected>)
Date: 08/15/00

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   |

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>