connection pooling? To many mySQL processes

[makenoiz]

Zen Cart: 1.5.1 35K products. Auto updating of 1-20
products every 10 hours via cron.
PHP version 5.3.16
MySQL version 5.1.62-cll
Architecture i686
Operating system linux

Getting harassed by host for too many mySQL processes/connections. Could this be a connection pooling issue with ZC connection function?


Should I change
$this->link = @mysql_connect($zf_host, $zf_user, $zf_password, true);

to this:

$this->link = @mysql_connect($zf_host, $zf_user, $zf_password);

We get about 500 hits per hour, would that justify 150 connections at any 1 time ( which is what host is saying we are doing ).

Thank you for any pointer or help

[makenoiz]

Also mysql_connect is depreciated.
http://php.net/manual/en/function.mysql-connect.php

Is it inefficient? Could this be why Im having an excess of connections? Thanks for any help.

[kobra]

What php version are you using??

This extension is deprecated as of PHP 5.5.0

[makenoiz]

What php version are you using??

Sorry you are correct... depreciation of mysql_connect is irrelevant since Im using 5.3.16.

What other ideas might you have for excessive mySQL connections? Someone suggested this to help with connection pooling? :

$this->link = @mysql_connect($zf_host, $zf_user, $zf_password, true);

to this:

$this->link = @mysql_connect($zf_host, $zf_user, $zf_password);

My reference is this: http://www.zen-cart.com/showthread.p...nect-is-unused I know its regarding pconnect, but gave me the ideas about the pooling possibility?

Any advice is appreciated.