I have one problem that keep on bugging me. This particular server Ubuntu Server 8.04, installed with Pligg, will hang itself :) after a few days. Processes error messages "Segmentation fault" are shown at the terminal.
It's only happen when MySQL start. It's hard to assume because the load to the Apache increase gradualy and each load will only takes one or two MySQL processes.
You can view it from MySQL prompt.
show processlist;
I don't blame MySQL because starting MySQL will start all the processses for Pligg, request to httpd then PHP then MySQL. One of them making the server hang when hit certain things.
This pligg is the version 0.9.5. The latest is version 1.0 just come out a few days ago.
I'm suspecting Pligg when been attack by cracker under old version 0.9.5 somehow crack under preasure. Pligg is using PHP and I will install version Pligg version 1.0 and I hope it will resolved the problem and may not Pligg bug but Apache mod PHP bugs.
and RedHat just release bug fix for Apache, Among them
* PHP's "pdo" extension would crash with a segmentation fault due to a flaw in the error-handling code.
* PHP's "pdo_mysql" extension was not able to detect stale database connections. Attempting to connect to a MySQL database when persistent connections were turned on would fail with the following error message: "General error: [year] MySQL server has gone away".
* certain OCI8 extension tests caused PHP to crash during end-of-request
shutdown.
* PHP scripts did not properly restore the process umask after a request.
I hope Ubuntu Server patch for PHP will resolved that php bugs.