Hi,

i've just tried to recreate the index (Links SQL 2.02) via browser: after a while there where no reaction back from nph-index.cgi - so i tried to start this via telnet.

Here's what i saw:

server% /usr/local/bin/virtual /www/htdocs/cgi-bin/admin/nph-index.cgi
GT::SQL (95150): OBJECT CREATED at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL.pm line 139.
Started at Thu Mar 1 00:54:56 2001.

Reindexing Links SQL Database ...

GT::SQL::Table (95150): Loading state for Links at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 161.
GT::SQL::Table (95150): State loaded for Links at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 165.
GT::SQL::Table (95150): Table 'Links' object created. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 86.
Links::Link (95150): Table 'Links' object created. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Table.pm line 86.
GT::SQL (95150): CREATING Links::Link OBJECT at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Base.pm line 66.
GT::SQL::Driver::MYSQL (95150): New driver object loaded from table: Links. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver.pm line 53.
GT::SQL::Driver::MYSQL (95150): Connecting to database with: 'DBI:mysql:ea_links:localhost', 'root', '******' at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver.pm line 77.
GT::SQL::Driver::MYSQL (95150): Connected successfully to database. at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver.pm line 82.
Links::Link (95150): Query: SELECT COUNT(*) FROM Links WHERE isValidated = 'Yes'
GT::SQL::Driver::MYSQL (95150): Preparing query: SELECT COUNT(*) FROM Links WHERE isValidated = 'Yes' at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 35.
GT::SQL::Driver::MYSQL (95150): Creating GT::SQL::Driver::MYSQL::sth object at /usr/local/etc/httpd/htdocs/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 38.

And tons more of this ... cpu-load was about 95% while running this ... on a second installation on the same server everything is working fine ...

What's wrong?

Thanks for hints.

Do you have debugging on?

Paul Wilson.
Installations:
http://www.wiredon.net/gt/

Paul,

that's it - thanks!

I've set debugging to 0 and everything works fine ... the server load returns to normal ... never thought that debugging creates such a load!

Thanks!

No problem......

Debugging is really useful though for finding errors.

Paul Wilson.
Installations:
http://www.wiredon.net/gt/

Hi,

As you found out, you should not run a production site with debugging on. You should only turn it on to help debug a problem, and then set it back to 0 when done.

Debug produces a lot of extra messages to your error log, plus adds considerable overhead (espically at debug levels 2 or 3).

Cheers,

Alex

--
Gossamer Threads Inc.