Page 1 of 1

PHPWCMS crashing server

Posted: Mon 12. Feb 2007, 19:41
by walnut
My server has been going down. The host provides the following information.

"I have checked your server and the processes running in the server and also those ones which are having high memory usage. We found that mysql is using high memory. Then we investigated on mysql processess and found that the CMS named phpwcms is causing high mysql connections and hence the memory usage on server. It is running by the user jcph. Please take necessary actions against this user in order to fix this issue."

I have some server log information available if this would be helpful.

This is a large site for me but not large in terms of web sites in general. Moving it to a new application or server could be a big task.

Anyone have any ideas?

Posted: Tue 13. Feb 2007, 00:46
by Ben
walnut,

The first thing is to check whether or not you are using persistent database connections in conf.inc.php. If you are, try changing so that you aren't using persistent connections.

Posted: Tue 13. Feb 2007, 01:54
by walnut
Are you refering to this line?

$phpwcms["db_pers"] = 1;

Should I change it to =0;

Posted: Tue 13. Feb 2007, 02:16
by Ben
Yes - changing it to "0" will not use persistent connections to the db ... and your host will probably like it better.

Posted: Tue 13. Feb 2007, 02:29
by walnut
Thanks, I have done it and now we will see if I stop the crashes.