Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Server Overload - search.cgi

Quote Reply
Server Overload - search.cgi
Hi!


The site has 10.000 visiters per day. Almost 7.000 visitors use Links SQL search script. Our dedicated server is very overloaded with it. Could we somehow make search process faster? Are there any other ways to save server from search-overloads? Thanks.

Best regards,
Dave
Quote Reply
Re: [Apeiron] Server Overload - search.cgi In reply to
Are you using mod_perl?
Quote Reply
Re: [Apeiron] Server Overload - search.cgi In reply to
What indexing scheme do you use?

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Quote Reply
Re: [webmaster33] Server Overload - search.cgi In reply to
Currently "NONINDEX".
I tryed to change that method to MySQL but i get the following mistake all the time:

"There are far too many records in table lsql_Links for create/destroy of this indexing scheme from the web. Please use alternative method."

Thanks,
Dave

Last edited by:

Apeiron: May 18, 2003, 10:27 PM
Quote Reply
Re: [Paul] Server Overload - search.cgi In reply to
No we dont use that yet. Will that help much if we setup mod_perl?

Thanks,
Dave
Quote Reply
Re: [Apeiron] Server Overload - search.cgi In reply to
Yes it should help
Quote Reply
Re: [Apeiron] Server Overload - search.cgi In reply to
You have to change the indexing method from the command line, not the admin console, if you have a large database. I believe the syntax is:

> perl nph-index.cgi --change-driver={DRIVER}

for example:

> perl nph-index.cgi --change-driver=MYSQL
or
> perl nph-index.cgi --change-driver=INTERNAL


This will take a while to run depending on the size of your database. It's also a good idea to repair and reindex your database from the command line as well using:

to repair:
> perl nph-build.cgi --repair

to reindex:
> perl nph-index.cgi --reindex


Sean
Quote Reply
Re: [SeanP] Server Overload - search.cgi In reply to
And where in admin console I can view/change indexing method?
Quote Reply
Re: [Danilov] Server Overload - search.cgi In reply to
In the database section of admin, select the table and then 'properties' in the select boxes. Then you should see the indexing method that is currently being used at the bottom of the page.
Quote Reply
Re: [afinlr] Server Overload - search.cgi In reply to
which of these indexing schemes provides the fastest results from search.cgi?

internal or MYSQL?
Colin Thompson
Quote Reply
Re: [colintho] Server Overload - search.cgi In reply to
Internal.

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] Server Overload - search.cgi In reply to
thanks

I changed the indexing to "Internal" in Links: Table Editor

started a SSH session, to run "re-index" with nph-index.cgi --reindex

appeared to start with this...

GT::SQL::Driver::MYSQL::sth (7207): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE isValidated = 'Yes' from main::reindex at ./nph-index.cgi line 133

Q: is this ok?

OK - its now working through.....scrolling.......accepted words / rejected words etc......
Colin Thompson

Last edited by:

colintho: Dec 28, 2003, 4:44 AM
Quote Reply
Re: [colintho] Server Overload - search.cgi In reply to
I think you need to turn Setup > Misc > debug to 0 (looks like its set to either 1 or 2 currently). This will get rid of all the garbage debug info that you don't really need.

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] Server Overload - search.cgi In reply to
Thanks again
Colin Thompson