Try the following:
1. Open sql.c in your editor
2. Add a line "#define DEBUG_SQL 1"
3. recompile and reinstall indexer
4. Run it and check it's STDERR output. You'll see the query being
executed and how much time it takes.
5. Either try to execute the same query in "mysql" tool or just
send a piece of output.
> Warren Grant wrote:
>
> I just installed version 3.0.23 a few days ago on my Solaris system,
> and I have to say it is running very strangely. Indexer had a
> catastrophic failure a few days ago which shutdown mysql entirely
> (with a "too many connections, error 1040' error), which necessitated
> my running iamchk on all of the tables to fix it and running an
> "unlock tables" command on several databases. Now when I run it it
> runs *very* slowly - it can take 5 minutes or more before it will look
> at the next page in the database. It has taken over 3 days to index
> 27,000 pages (and its still not done actually examining all of those
> pages).
>
> Perhaps this is related to my version of mysql (version 3.22.32)? I am
> using crc/multi mode as I expected it to be the fastest form for both
> indexer and search.cgi, but judging by the performance of indexer I
> must be mistaken. search.cgi is actually reading the old version of
> the database I originally created in crc mode - and doing so quite
> quickly in fact. Indexer, however is so slow as to be virtually
> useless.
>
> So, how do the various versions of the database for use with mysql
> measure up? I presume crc/multi to be the fastest, but what is next?
> crc or multi? I have over 100,000 webpages to index and I want to
> ensure that the database performs fastest for returning search results
> primarily, but not at the sacrifice of being unable to actually spider
> the sites I want to index inside of a month or so of running indexer.
> As it stands now I am ready to return to crc mode since it is
> performing better with over 100,000 records than crc/multi with less
> than 27000 records complete.
--
Alexander Barkov
IZHCOM, Izhevsk
email: [EMAIL PROTECTED] | http://www.izhcom.ru
Phone: +7 (3412) 51-32-11 | Fax: +7 (3412) 51-20-80
ICQ: 7748759
______________
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]
