Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Indexing Solution!

Quote Reply
Indexing Solution!
Actually I am not sure this is a solution, but it has my database indexing issues fixed in the short term, till I hear back from the GT staff about this.


I discovered that my search yielded no results whatsoever using the MySQL DB Index method. (I still do not know why). So went to covert my db to the INTERNAL DB Index method. This I could not due, as I have over 40,000 links and 8000+ categories, and LSQL returns an error message if I try to change Indexing methods. Not having shell/telnet access with my host, I turned to cgitelnet. This program allows you to execute shell commands without telnet. No avail. This seemed to produce a page full of html and did not actually index anything, nor change the indexing method.

Temporary Fix:

I am posting this here, just in case anyone else has a problem like this, and this may help.
  • First I backup up my database in the Admin->Database->Import/Export.
  • Then I went into MySQLMan and clicked on "empty" for all the really big tables.
  • Now, small enough tables, LSQL would allow me to change the Index format. So I did through Admin->Database-Editor and changed each table to INTERNAL.
  • I then imported my backup from step one.
  • Rebuild Table and Rebuild Search (still having probs with this at the moment - see below).

Now at least I am getting something in the results returned from a user search!Wink

As for the rebuild search, this keeps stopping at around 5000 links.... so something is still not working....

Links Plugins

Last edited by:

sooke: Apr 6, 2002, 7:18 PM
Quote Reply
Re: [sooke] Indexing Solution! In reply to
I actually just got it all to index!

Started at Sat Apr 6 22:22:11 2002.

Indexing Links Database ... 41744 links.
1000 2000 3000 4000 5000 6000 7000 8000 9000 10000
11000 12000 13000 14000 15000 16000 17000 18000 19000 20000
21000 22000 23000 24000 25000 26000 27000 28000 29000 30000
31000 32000 33000 34000 35000 36000 37000 38000 39000 40000

Reindexing Category Database ... 8247 categories.
1000 2000 3000 4000 5000 6000 7000 8000

All Done (2226.75 s)
Quote Reply
Re: [Ian] Indexing Solution! In reply to
Hi Ian,

I just found your post and wanted to ask if you did find a solution to use MYSQL as indexing scheme. I am having a similar problem and it looks that the weighted columns are not defined as INDEX in mysql.


Quote Reply
Re: [el noe] Indexing Solution! In reply to
Ok, I guess I found at least my own problem: