Database Memory Issue

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Locked
Mudders

Database Memory Issue

Post by Mudders »

Hi All,

My webhosting provider has come to me and said that my site is not closing its DB handles - or something to that effect.
They say it keeps on creating new DB sessions which seems to be crashing my site.
Has anyone else experienced this?
I'm on the 0.13 Canary Version.

Any idea's how to stop this?

Thanks,

Mudders.
User avatar
Elijah Lofgren
Power Poster
Power Poster
Posts: 811
Joined: Mon Apr 24, 2006 1:01 am

Re: Database Memory Issue

Post by Elijah Lofgren »

Mudders wrote: Hi All,

My webhosting provider has come to me and said that my site is not closing its DB handles - or something to that effect.
They say it keeps on creating new DB sessions which seems to be crashing my site.
Has anyone else experienced this?
I'm on the 0.13 Canary Version.

Any idea's how to stop this?
I've never run into this problem on any of my sites. Maybe you could try using (or disabling if their already disabled) persistant connections.

In config.php
find:

Code: Select all

$config['persistent_db_conn'] = false;
try changing to:

Code: Select all

$config['persistent_db_conn'] = true;
or if it already is at:

Code: Select all

$config['persistent_db_conn'] = true;
try changing to:

Code: Select all

$config['persistent_db_conn'] = false;
I don't know if this will actually help, worth a try though, I think. :)
Note: I don't have time to take on any more projects. I'm quite busy. I may be too busy to reply to emails or messages. Thanks for your understanding. :)
Locked

Return to “CMSMS Core”