MYSQL Resource link

[saravanan balakrishnan]

Hi,

I know while using mysql_pconnect in php it will create persistence connection with mysql. If we try connect mysql_pconnect in some other php scripts, it will try to find out the existing connection and retunr resource id.

My question is php script1 created the pconnection and php script2 using the existing connection that is ok, but how the mysql finds the persistence connection exists or not for the request coming from the particular client?

What are the checking process done by mysql?

How it identifies the client?

Where the resource id stored (server or client) and how it is stored? (or) is mysql uses show process list which will show the list existing connection?

If mysql uses show process list command, how it identifies which connection belongs to which client machine?

Can any one of you pls. answer me? if anybody knows, it would be great. I am searching for a while for this answer.

Thanks in advance.

- Sara