Mailing List Archive

Re: Link update script
I've switched to the CVS version and corrected a few bugs. But the
site is sluggish again, and load is creeping upward. I wonder if
getOtherNamespaces is the issue again?

Magnus Manske wrote:

> When you've fixed the current version, please run the link update script. I
> just fixed the database so it will work properly (I hope;)
>
> The script is in the CVS, run it with
> php updateLinks.php
> (or whatever it is actually called)
>
> Attention: This will take several minutes to complete! You might consider
> taking the site offline for the time being.
>
> Magnus
>
Re: Re: Link update script [ In reply to ]
Things seem more or less o.k. now. I'm running rebuildLinks.php -- it will be running
for several more hours, it seems.

Magnus Manske wrote:

> > -----Original Message-----
> > From: wikitech-l-admin@nupedia.com
> > [mailto:wikitech-l-admin@nupedia.com]On Behalf Of Jimmy Wales
> > Sent: Tuesday, May 14, 2002 7:23 PM
> > To: wikitech-l@nupedia.com
> > Subject: [Wikitech-l] Re: Link update script
> >
> >
> > I've switched to the CVS version and corrected a few bugs. But the
> > site is sluggish again, and load is creeping upward. I wonder if
> > getOtherNamespaces is the issue again?
>
> I don't think so - it should be fixed so it only checks for a single article
> (talk or the original topic) now. In fact, I cut the time for page rendering
> down by 20% compared to the patched version (without the talk links) of
> yours.
>
> Anyway, currently the 'pedia seems to run fast and stable. What does the top
> command say? Is the "really big process" bug back??
>
> Magnus
>
Re: Link update script [ In reply to ]
Tisdag, 14 Maj 2002, Jimmy Wales skribte:
> I've switched to the CVS version and corrected a few bugs. But the
> site is sluggish again, and load is creeping upward. I wonder if
> getOtherNamespaces is the issue again?

It could be the temporary workaround I had put in place for the
certain-common-words-cause-searches-to-fail-completely bug, which falls
back to a slow but reliable LIKE search when the MATCH fails.

I've disabled the fallback in CVS; update special_dosearch.php and see if
performance (if not search results) improves.

The search system needs some major work, alas...

-- brion vibber (brion @ pobox.com)
Re: Re: Link update script [ In reply to ]
On Tue, May 14, 2002 at 07:06:26PM -0700, Brion Vibber wrote:
> Tisdag, 14 Maj 2002, Jimmy Wales skribte:
> > I've switched to the CVS version and corrected a few bugs. But the
> > site is sluggish again, and load is creeping upward. I wonder if
> > getOtherNamespaces is the issue again?
>
> It could be the temporary workaround I had put in place for the
> certain-common-words-cause-searches-to-fail-completely bug, which falls
> back to a slow but reliable LIKE search when the MATCH fails.

Hi, remember me? :-) Has it been considered to recompile MySQL? That way you
could also remove the annoying 4-character limit for search words. See:

http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html

Even better would be a switch to MySQL4.0, in which case the extra code for
boolean searches can be omitted.

-- Jan Hidders