Hi,
I've been looking around a lot on phpbuilder.com, google.com, mysql.com and php.net to understand what's going on with my MySQL connection from PHP. Here is my "problem":
+----+-------+-----------+-----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+-----+---------+------+-------+------------------+
| 3 | xxxxx | localhost | yyy | Query | 0 | NULL | SHOW PROCESSLIST |
| 4 | xxxxx | localhost | yyy | Sleep | 255 | | NULL |
| 5 | xxxxx | localhost | yyy | Sleep | 72 | | NULL |
| 6 | xxxxx | localhost | yyy | Sleep | 180 | | NULL |
| 7 | xxxxx | localhost | yyy | Sleep | 92 | | NULL |
+----+-------+-----------+-----+---------+------+-------+------------------+
As you can see, I've got 4 process sleeping with no State and NULL info. Is it because there is a probleme with my queries in PHP or is it just plain normal? I just can't find any reference on the net giving me a definitive answer to that question.
Sometime, one of those threads is reused, but rarely. On top of that, I know I'm the only one making requests (it's in my local network at home) so why would it need more than one process for PHP connections if I use only on mysql_connect?
I'm using MySQL 3.23.23-beta and php 4.0.3.
Thanks in advance for your comments.
La_Maudite.
I've been looking around a lot on phpbuilder.com, google.com, mysql.com and php.net to understand what's going on with my MySQL connection from PHP. Here is my "problem":
+----+-------+-----------+-----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------+-----------+-----+---------+------+-------+------------------+
| 3 | xxxxx | localhost | yyy | Query | 0 | NULL | SHOW PROCESSLIST |
| 4 | xxxxx | localhost | yyy | Sleep | 255 | | NULL |
| 5 | xxxxx | localhost | yyy | Sleep | 72 | | NULL |
| 6 | xxxxx | localhost | yyy | Sleep | 180 | | NULL |
| 7 | xxxxx | localhost | yyy | Sleep | 92 | | NULL |
+----+-------+-----------+-----+---------+------+-------+------------------+
As you can see, I've got 4 process sleeping with no State and NULL info. Is it because there is a probleme with my queries in PHP or is it just plain normal? I just can't find any reference on the net giving me a definitive answer to that question.
Sometime, one of those threads is reused, but rarely. On top of that, I know I'm the only one making requests (it's in my local network at home) so why would it need more than one process for PHP connections if I use only on mysql_connect?
I'm using MySQL 3.23.23-beta and php 4.0.3.
Thanks in advance for your comments.
La_Maudite.