You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi
I have been told by my host company that my CCP4 CGI scripts are causing problems due to high server load
i have 600+ plus products in database - total db size is over 400k
Note: i have purchased CCP5 but have not completed the install
will using CCP5 in mysql mode resolve the issue?
GREG
here is additional info from my host
Here is the entry from the process list of our web server
that shows how the script is taking up a large amount of
the resources on it.
%CPU %MEM PID TIME USER COMMAND
68.0 46.7 28212 00:20:48 techno perl /home/sites/site195/web/cgi-bin/cp-app.cgi
The entry above shows that the script was using up 68%
of the CPU time, 46.7% of the web servers memory, and
had been running for 20 minutes and 48 seconds.
There is something wrong with the script that is causing
it to use up all of the available resources and not stop
running.
This causes our server to reboot so that it does not
completely run out of resources. Since we have a few
hundred sites hosted on this server, we can not have
one site that affects the performance all of the other
sites on the server.
This problem has already occurred 3-4 times in the
past and and we have warned you each time that the
script needs to be fixed. Since it has happened again,
we have no choice but to either remove the script or
remove the site from our server.
Version 5 should cure this problem as it uses different means to access the data. Using MySQL with version 5 will greatly help as well. As far as running for 20 minutes - you had a process that did not die - only an infinite loop in the program (which there were none when I coded it) could do that.
___________________________
Nick Hendler
Webmaster, Kryptronic, Inc.
Offline