Mailing List Archive

On Mon, 25 Nov 2002, Poor, Edmund W wrote:
> Would restarting any of the servers periodically help?
>
> Suppose it takes X minutes to restart a server, and that the "lag" problem puts Wikipedia out of operation for Y minutes -- where X << Y. Maybe then this would be a good "band-aid" for the problem.

It takes all of a couple seconds to restart apache; I've set it to do a
"graceful" restart every half hour during US daytime, which more or less
coincides with our peak hours.

-- brion vibber (brion @ pobox.com)

On Mon, Nov 25, 2002 at 03:11:44PM -0800, Brion Vibber wrote:
> On Mon, 25 Nov 2002, Poor, Edmund W wrote:
> > Would restarting any of the servers periodically help?
> >
> > Suppose it takes X minutes to restart a server, and that the "lag" problem puts Wikipedia out of operation for Y minutes -- where X << Y. Maybe then this would be a good "band-aid" for the problem.
>
> It takes all of a couple seconds to restart apache; I've set it to do a
> "graceful" restart every half hour during US daytime, which more or less
> coincides with our peak hours.
>
Will "graceful" be sufficient? When messing around with oracle I'm
usually forced to do a "restart" instead.

Regards,

JeLuF

> > Would restarting any of the servers periodically help?
> >
> > Suppose it takes X minutes to restart a server, and
> > that the "lag" problem puts Wikipedia out of operation
> > for Y minutes -- where X << Y. Maybe then this would
> > be a good "band-aid" for the problem.
>
> It takes all of a couple seconds to restart apache; I've set it to do a
> "graceful" restart every half hour during US daytime, which more or less
> coincides with our peak hours.
>
> -- brion vibber (brion @ pobox.com)

Does restarting apache also untangle the gridlock of database queries?

Ed Poor

"Poor, Edmund W" <Edmund.W.Poor@abc.com> writes:

> The English Wikipedia slowed down again today.

The German, too.

> Until we figure out what's causing the slowdown, what kind of First Aid
> measures can we apply?

Switching off all these nice little functions which are not absolutely
necessary for editing? for example "this page was accessed xx times",
"what links here"...

There is really a need for first Aid measures. The english wikipedia may
not have this problem, but the other language wikipedias are in desperate
need of every editor and with every lag we run the risk of loosing
valuable contributors.

For later (since I don't understand anything of programming I just throw
my ideas in and leave it to the experts to judge them as rubbish or think
about them - there is a common saying in German about blind chickens ;-)):
recently I found an article about database replication in a
German PHP-magazine (two mysql databases, one working as master, one as
slave). Maybe we could use such a slave database for reading access to
wikipedia and the main for editing.

greetings,
elian
My obedit (obligatory edit) for this posting:
http://de.wikipedia.org/wiki/Urban_II.
--
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs, and the Universe trying
to produce bigger and better idiots. So far, the Universe is winning."
(Rich Cook)