Maximum connections and OSC server crashing

[Guest]

Hi,

 

We're having a major issue at the moment with the maximum number of mySQL connections beings exceeded on our website which is in turn crashing it (and even crashing the server). We're running osCommerce MS2. The server is Linux/Apache running PHP5/mySQL5.

 

It appears that connections are being opened but are then not closed, which means that the total number of connections present keeps going up until the site crashes.

 

Obviously this is a general site issue and not something that can be fixed by editing a few files, however for operational reasons we can't revert the site to a PHP4/mySQL4 server (where it was much more stable), and the company can't afford to pay for the development and configuration time for upgrading osCommerce to a more recent version. (And this might not solve the issue in any case)

 

So we need to find a workaround or fix for this. Has anyone come across this issue before? Any solutions? (I haven't been able to find any as yet)

 

Thanks

[Guest]

Truff,

 

This is not an OSC issue, I would suggest you contact your hosting provider to increase the number of concurrent connectors you are allowed. If your site is pulling that much traffic then perhaps it is time for a dedicated server.

 

The number of 'users' online refreshes depending on the server settings. This may also be something to discuss with your hosting provider to perhaps change the refresh time.

 

 

 

Chris

[Guest]

Truff,

 

This is not an OSC issue, I would suggest you contact your hosting provider to increase the number of concurrent connectors you are allowed. If your site is pulling that much traffic then perhaps it is time for a dedicated server.

 

The number of 'users' online refreshes depending on the server settings. This may also be something to discuss with your hosting provider to perhaps change the refresh time.

 

 

 

Chris

Thanks Chris, we've already spoken with the hosting provider- he has said that the number of concurrent connections can't be increased any further. Also do you know which server setting would change the refresh time in order to accurately report the correct number of "real" users?

[Guest]

Truff,

 

If you change your hosting to dedicated then the number of concurrent connections will increase. I know Godaddy grid hosting has 4500 concurrent connections on a dedicated server. (I only know that because I use them)

 

The refresh rate is set by your hosting provider, you would have to speak to them. However if they gave you the answer above, chances are they will not change the refresh rate either as it taxes their resources further.

 

 

Chris

[BryceJr]

Hi,

 

We're having a major issue at the moment with the maximum number of mySQL connections beings exceeded on our website which is in turn crashing it (and even crashing the server). We're running osCommerce MS2. The server is Linux/Apache running PHP5/mySQL5.

 

It appears that connections are being opened but are then not closed, which means that the total number of connections present keeps going up until the site crashes.

 

Obviously this is a general site issue and not something that can be fixed by editing a few files, however for operational reasons we can't revert the site to a PHP4/mySQL4 server (where it was much more stable), and the company can't afford to pay for the development and configuration time for upgrading osCommerce to a more recent version. (And this might not solve the issue in any case)

 

So we need to find a workaround or fix for this. Has anyone come across this issue before? Any solutions? (I haven't been able to find any as yet)

 

Thanks

Make sure this is set in your configure.php files

define('USE_PCONNECT', 'false');

[Guest]

Make sure this is set in your configure.php files

define('USE_PCONNECT', 'false');

Thanks Bryce- have checked and it's set FALSE in both httpdocs/catalog/includes and httpsdocs/catalog/includes.

 

Guess there's nothing else to do except try and get the hosts to sort? :(

[BryceJr]

Thanks Bryce- have checked and it's set FALSE in both httpdocs/catalog/includes and httpsdocs/catalog/includes.

 

Guess there's nothing else to do except try and get the hosts to sort? :(

What about the catalog/admin/includes/ configure.php?

[Guest]

What about the catalog/admin/includes/ configure.php?

Checked this too and it's set FALSE: define('USE_PCONNECT', 'false');