persistent MySQL connections etc

willh

I have a banner script showing 250,000+ banners a month. I was thinking it would be a good idea to start using mysql_pconnect() now I have php running as a module.

But when I look at the active mysql processes I seem to be getting several for this user (as used in the banner script). It seems to level off around 7. I notice that the time of some of the processes seems to drop backdown to 0 when the script is called again - does this mean that this connection is being reused? Why do I have so many - why not just 1 seeing as they all the the same user and from localhost? Do I need to change some configurations?

Thanks in advance

Will

[deleted]

"does this mean that this connection is being reused?"

yes

"Why do I have so many "

7 is not many, 454 is many.
You have 7 because apparently your system requires 7 open connections.

Database connections can only be used by one script at a time. So if your site runs 7 scripts at the same time, it needs 7 database connections at the same time.

Many people think that using pconnect will magically reduce the number of open connections, but in fact the number stays the same, they just last longer and are therefor faster to 'connect' to.

willh

Okay thanks very helpful - when I make it live I'd say I will be getting many more connections then.

Thanks

Will