mysql_pconnect() mysteries

From: 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 |

« previous php.db (#2065) next »