PHPWCMS crashing server

walnut · Post by **walnut** » Mon 12. Feb 2007, 19:41

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?

Ben · Post by **Ben** » Tue 13. Feb 2007, 00:46

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.

walnut · Post by **walnut** » Tue 13. Feb 2007, 01:54

Are you refering to this line?

$phpwcms["db_pers"] = 1;

Should I change it to =0;

Ben · Post by **Ben** » Tue 13. Feb 2007, 02:16

Yes - changing it to "0" will not use persistent connections to the db ... and your host will probably like it better.

walnut · Post by **walnut** » Tue 13. Feb 2007, 02:29

Thanks, I have done it and now we will see if I stop the crashes.