--- wikitech-l-request(a)Wikipedia.org wrote:
Send Wikitech-l mailing list submissions to
wikitech-l(a)Wikipedia.org
Attached is a zip file containing the output from
SHOW PROCESSLIST.
There is one file showing "typical" output, between
the episodes, and
three showing output in the middle of an episode.
One thing stands out
like a sore thumb:
SELECT 1 FROM user_newtalk WHERE
user_ip='167.206.112.85'
SELECT 1 FROM user_newtalk WHERE
user_ip='217.244.15.107'
SELECT 1 FROM user_newtalk WHERE
user_ip='80.55.166.58'
SELECT 1 FROM user_newtalk WHERE
user_ip='66.196.90.11'
SELECT 1 FROM user_newtalk WHERE
user_ip='172.176.254.188'
SELECT 1 FROM user_newtalk WHERE
user_ip='220.54.212.24'
SELECT 1 FROM user_newtalk WHERE user_id=7580
SELECT 1 FROM user_newtalk WHERE
user_ip='194.78.48.226'
SELECT 1 FROM user_newtalk WHERE
user_ip='80.225.14.29'
SELECT 1 FROM user_newtalk WHERE
user_ip='144.32.128.73'
SELECT 1 FROM user_newtalk WHERE
user_ip='62.216.15.127'
SELECT 1 FROM user_newtalk WHERE
user_ip='134.151.225.179'
SELECT 1 FROM user_newtalk WHERE
user_ip='213.81.145.123'
SELECT 1 FROM user_newtalk WHERE
user_ip='129.137.208.159'
SELECT 1 FROM user_newtalk WHERE
user_ip='195.93.72.17'
SELECT 1 FROM user_newtalk WHERE
user_ip='218.19.141.2'
SELECT 1 FROM user_newtalk WHERE
user_ip='68.11.187.242'
SELECT 1 FROM user_newtalk WHERE
user_ip='63.34.208.93'
SELECT 1 FROM user_newtalk WHERE
user_ip='81.196.21.16'
SELECT 1 FROM user_newtalk WHERE
user_ip='202.156.2.82'
Millions of user_newtalk requests, conspicuously
absent from the typical
dump. Many of them are doing "statistics", whatever
that means, and the
rest are locked. One side of me is curious as to
what "statistics" means
and why it produces this behaviour. The other side
of me says
KILL KILL KILL
Needless to say, I have no idea what you are talking
about
But I feel the KILL KILL KILL feeling each time the
mailing list is attacked by spamers, which in turn
fills up my mailing box of rebouncing dirt.
I would be curious to know how much spam other mailing
lists receive ? Now that I know every money problem
the african business man have, that I know how to
expand my penis to incredible size, and how to get
called "lips on fire", what ?
Is it possible to add some words to an anti-spam list,
and to have any message containing "sex", "enlarge",
"lips", "money", "daemon", "free business
proposition", "free flower" (if only, sigh) and such
just be automatically sent back ? ,(or just plainly dumped)
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com