--- wikitech-l-request@Wikipedia.org wrote:
Send Wikitech-l mailing list submissions to wikitech-l@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