MYSQL Empty State normal using PHP?

wxdqz

New Member
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.
 
Back
Top