Hello :-)

After the installation of Links SQL, I've noticed that MySQL response time slowed down - even for other scripts which are using it. I've contacted my hosting provider and he sent me this:

------------------------------------
I noted in the processlist a couple of connections from your account set to sleep:
| 873267 | a0006331 | localhost | a0006331 | Sleep | 71 | | |
| 873268 | a0006331 | localhost | a0006331 | Sleep | 65 | |
If this is due to a persistent connection (mysql_pconnect(); ) command, it needs to be made into a normal connection.
------------------------------------

I found several of these commands in Links SQL directory. I wonder if I can change this to normal connection, or if it would be dangerous?

Thank you very much for letting me know :-)

Robo
webmaster of frigorista.com

Hi,

Are you using the PHP front end? If so, have a look at:

http://www.php.net/...n.mysql-pconnect.php

the trade offs for not using persistent connections. However, having connections in Sleep mode is perfectly normal, and should not slow down mysql at all. It is a little faster to use persistent connections as then you don't need to connect/disconnect to mysql for each request.

Cheers,

Alex
--
Gossamer Threads Inc.

Thank you for clearing this up Alex :-)