On Internet-Encyclopedia, for example at
http://www.internet-encyclopedia.info/wiki/history
if there is a table all links (whether an article exits or not) are in blue.
Any clue as to what is happening?
Fred
But I can ssh there.
First line in top:
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
25451 mysql 17 0 989M 948M 670M R 99.9 47.1 110:55 mysqld
Someone uploaded the image Beethoven_wiki.jpg from the English Wikipedia
to the Dutch one under the name Beethoven.jpg; however, the image does not
show; instead there is just a bit of text being the internal URL of the
image (http://nl.wikipedia.org/upload/6/6f/Beethoven.jpg). Thinking
something had gone wrong, I re-uploaded the image, but without any change.
What is going on, and how can this be avoided?
Andre Engels
Hi everyone.
I just subscribed, but read the previous threads, specially the one on Wikipedia Dead Again.
All my apologies, i'm the one who killed the server by doing a bad query.
I don't ask for forgiveness, but i just want to explain what i did, because 1) i think it's the right thing to do 2) i wonder about something
(working on the fr database, btw)
So here's what i did:
* first i did a query to try to find articles with a link to a redirect (and thus fix those links). It was around 11:30 (french hour).
iirc the query was:
select l.cur_title, r.cur_title from cur l inner join links lnk on l.cur_title = lnk.l_from inner join cur r on r.cur_title = lnk.l_to where r.cur_text like '%#redirect%'
Note that it's the same as the killing one, without the 'binary'.
It took a few minutes, server down during that time (already bad), around 5 i think, then i got some answers. Many duplicates, as string comparison seems case-insensitive.
But the server WAS responding after it, of that I'm quite sure.
So i checked MySQL docs, and found the 'binary' trick to force case-sensitivity for comparisons. Now before doing the query again, i wanted to check how many records there are in 'links' table.
So here comes the easy query:
select count( * ) from links
Here is what is weird: after that one, the server didn't reply. I don't remember doing the query with the 'binary', though i probably did it since it's in the logs ^_-
I think i have recollection troubles, probably due to the shame of having killed the server -.-
Learned lessons:
1) learn the database format before doing big queries
2) use the 'explain' keyword (thanks Brian for that one)
3) install the database to my local comp to play with queries without killing everything !
Ryo who will take extra care with requests...
The German server statistics on
http://de.wikipedia.org/stats/
are having problems with our umlauts. Article titles seem to be cut off
at umlauts. Can this be fixed somehow? (After the more serious problems
we're facing at the moment ...)
BTW, there are only 30 referrers shown (which is the most interresting
part for me). They are mostly search engines, so it would be nice to
have, say, the top 100 referrers. Is this possible?
Kurt
I think I've found a help for the Internet Explorer reload problem!
I finally dug up a network dump tool and looked at the actual
communication between IE and the server. What I found was that things
went roughly like this:
First request of page: 200 return code, all text, has last-modified date
and cache-control which requires revalidation on every load.
HTTP/1.1 200 OK
Date: Sat, 22 Mar 2003 05:40:36 GMT
Server: Apache/1.3.26 (Unix) PHP/4.2.3
X-Powered-By: PHP/4.2.3
X-Accelerated-By: PHPA/1.3.3r2
-> Expires: Mon, 15 Jan 2001 00:00:00 GMT
-> Cache-Control: private, must-revalidate, max-age=0
-> Last-Modified: Fri, 21 Mar 2003 16:34:52 GMT
Content-language: en
Keep-Alive: timeout=15, max=99
Connection: Keep-Alive
Transfer-Encoding: chunked
Content-Type: text/html; charset=iso-8859-1
Second request of page: 304 return code (not modified) -- but!
HTTP/1.1 304 Not Modified
Date: Sat, 22 Mar 2003 05:40:53 GMT
Server: Apache/1.3.26 (Unix) PHP/4.2.3
X-Powered-By: PHP/4.2.3
X-Accelerated-By: PHPA/1.3.3r2
-> Expires: Sat, 22 Mar 2003 08:40:53 GMT
-> Cache-Control: public, max-age=10800
-> Last-Modified: Mon, 10 Feb 2003 14:03:33 GMT
Keep-Alive: timeout=15, max=98
Connection: Keep-Alive
Content-Type: text/html
Third request of page: didn't even bother to touch the network, because
the 304 return accidentally let apache and/or php fill in generic
settings for the last-modified and cache-control headers which claim it
was modified when the PHP script was last updated and that it doesn't
need to be revalidated for 24 hours!
I've patched OutputPage.php to include the cache-control and
last-modified when sending 304s, and it's now rechecking the page on
subsequent visits. (A 304 returns very quickly, so it's fast even on my
modem.)
This may or may not help with the "reload doesn't actually reload"
problem. Hopefully so. ;)
Next step is to add a last-touched field for pages and users to
invalidate caches when links & preferences change -- see
http://meta.wikipedia.org/wiki/Cache_control
-- brion vibber (brion @ pobox.com)
When were they re-enabled for en.wiki? Have they been fixed to generate more
meaningful data and minimize server load? They don't appear to tick for each
page reload so something is different.
--mav
Brion Vibber <brion(a)pobox.com> wrote in
news:1047662753.8710.12.camel@frank.vibber.org:
> On Fri, 2003-03-14 at 03:23, Pedro M.V. wrote:
>> What about include a counter to see when the peak hours happen ????.
>
> http://www.wikipedia.org/stats
> http://fr.wikipedia.org/stats
> etc
>
> -- brion vibber (brion @ pobox.com)
Or http://nl.wikipedia.org/stats
Thanks Brion! I am very happy to get some real stats.
But the stop at 20 janauary...
--
Contact: giskart AT wikipedia.be
Ook een artikeltje schrijven? WikipediaNL, de vrije GNU/FDL encyclopedie
http://www.wikipedia.be
About Skins and HTML Templates (as that is what you seem to propose)
I had a few of my webpages running using Fast Template
http://www.google.com/search?q=fast+template (a few tutorial +
modifications can be seen on google)
I don't really like it anymore, but it may be worth a look.
The way you handle it is, making an external template file which is
basically html-code with {SPECIAL_TAGS} in curly brackets which you can
replace from your code.
But for REAL php-programmers (and I am not one of them) this might be to
simple/redundant so feel free to ignore this.
Cheers
Leo
