Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Excessive Resource Usage -how to stop nph-verify.cgi

Quote Reply
Excessive Resource Usage -how to stop nph-verify.cgi
Hi, I have GLinks installed on a dedicated server that's not running any other sites, but was testing it on a db of about 40,000 links. Tried to run the verify links process and since that time I keep getting excessive resource useage notices, and noting this line in the message as being problematic.



/usr/local/bin/perl /home/test/public_html/cgi-bin/admin/nph-verify.cgi --child /home/test/public_html/cgi-bin/admin/tmp/GTTemp56402288

How does one "turn off" the verify process in GLinks so that this is not putting a strain on the server?

Note: the server has plenty of RAM, is new, and is hosted at a very reputable company so it is not my hardware that I need to troubleshoot. Guess I would really appreciate any comments from the more experienced folks here about how to "turn" off the verify process once you've started it, and perhaps how to preven this from happening in the future. Thanks very much for your comments if you have any suggestions.
Quote Reply
Re: [webones] Excessive Resource Usage -how to stop nph-verify.cgi In reply to
Hi,

Not 100% sure - but could be worth finding this in nph-verify.cgi:

Code:
$OPTIONS = {
# keep this number small to maximize the number of children working at the
# end of the verification process:
chunk => 10,
# You may have lower this value if you get errors spawning children (max user
# processes ulimit), or if your database server limits the number of concurrent
# connections.
max_children => 10,
spawn_delay => 2,
font => 'font face="Tahoma,Arial,Helvetica" size="2"',
};

..and change to a lower "child" number, i.e

Code:
$OPTIONS = {
# keep this number small to maximize the number of children working at the
# end of the verification process:
chunk => 10,
# You may have lower this value if you get errors spawning children (max user
# processes ulimit), or if your database server limits the number of concurrent
# connections.
max_children => 5,
spawn_delay => 2,
font => 'font face="Tahoma,Arial,Helvetica" size="2"',
};

Bit of a stab in the dark - as I can't recall ever having that problem- but at least worth a try Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Excessive Resource Usage -how to stop nph-verify.cgi In reply to
Yes, lowering the max_children should help out with keeping the load average down. The processes aren't usually very cpu intensive (all it's doing is making sure it can connect to the links), but your 'server monitor' software doesn't seem to be very intelligent as it seems like it's only looking at server load (which is only one component of server utilisation). Note that in the next version, those values will be moved into the Config/Data.pm.

Adrian
Quote Reply
Re: [brewt] Excessive Resource Usage -how to stop nph-verify.cgi In reply to
Quote:
Note that in the next version, those values will be moved into the Config/Data.pm.

Ooh cool - a new versions in the pipeline Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [brewt] Excessive Resource Usage -how to stop nph-verify.cgi In reply to
Hi Adrian and Andy,

Thanks for the help with this.

Adrian, anyway I can "stop" this process from running at all, short of simply deleting the entire directory and db and starting over? It's been running for over a week like this and I just want to stop it and not use the checking links feature at all any more, but I don't know how to stop it once it's started.

If you have any ideas like I said, short of just deleting everything and starting over with a new install, I'd really appreciate it.

Thanks
Quote Reply
Re: [webones] Excessive Resource Usage -how to stop nph-verify.cgi In reply to
If it's already running you can kill it through shell using the 'kill' command.

Adrian
Quote Reply
Re: [webones] Excessive Resource Usage -how to stop nph-verify.cgi In reply to
A quick way, would be to just restart mysql =) Then, all connections would fail, so it would stop running.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Excessive Resource Usage -how to stop nph-verify.cgi In reply to
It's not the best idea to restart MySQL just to get rid of a process.
Quote Reply
Re: [Wychwood] Excessive Resource Usage -how to stop nph-verify.cgi In reply to
Wychwood wrote:
It's not the best idea to restart MySQL just to get rid of a process.

I know its not the best option - but the only other option would be to kill off the process - which is what I would do (via kill -9 xxxx), but that will would require checking up ALL the process ids of th emain process, and the children - and restarting MySQL was a LOT easier than that ;)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Excessive Resource Usage -how to stop nph-verify.cgi In reply to
Killing the parent kills the children too.

Last edited by:

Wychwood: Jun 2, 2008, 4:32 PM