[Mediawiki-l] Stopping MySQL with a BIG query

John Bidder john at highlanddrive.wanadoo.co.uk
Wed May 9 15:26:22 UTC 2007


Update to this issue. The full query was in fact:

The query was:-
                 14874 Query       SELECT page_id, page_namespace,
page_title FROM `mw_page`,`mw_searchindex` WHERE page_id=si_page AND (
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('free-teen-porn')) AND (MATCH
(si_title) AGAINST ('Free')) AND (MATCH (si_title) AGAINST ('teen')) AND
(MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('interracial-porn')) AND (MATCH (si_title) AGAINST ('Interracial'))
AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST
('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title)
AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH
(si_title) AGAINST ('ebony-porn')) AND (MATCH (si_title) AGAINST ('Ebony'))
AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST
('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title)
AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH
(si_title) AGAINST ('sex-toy')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('anal-porn')) AND (MATCH (si_title) AGAINST ('Anal')) AND (MATCH (si_title)
AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH
(si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND
(MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('free-porn-video-clip')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('video')) AND
(MATCH (si_title) AGAINST ('clip')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('indian-porn')) AND (MATCH (si_title) AGAINST ('Indian')) AND
(MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('free-sex-clip')) AND (MATCH (si_title) AGAINST ('Free')) AND
(MATCH (si_title) AGAINST ('clip')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('lesbian-porn')) AND (MATCH (si_title) AGAINST ('Lesbian')) AND
(MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('midget-porn')) AND (MATCH (si_title) AGAINST ('Midget')) AND
(MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('live-sex')) AND (MATCH (si_title) AGAINST ('Live')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('gay-sex')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('homemade-porn')) AND (MATCH (si_title) AGAINST
('Homemade')) AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('hardcore-porn')) AND (MATCH (si_title) AGAINST
('Hardcore')) AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('paris-hilton')) AND (MATCH (si_title) AGAINST
('Paris')) AND (MATCH (si_title) AGAINST ('Hilton')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('virgin-teens')) AND (MATCH (si_title) AGAINST
('Virgin')) AND (MATCH (si_title) AGAINST ('Teens')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('sildenafil-citrate')) AND (MATCH (si_title)
AGAINST ('Sildenafil')) AND (MATCH (si_title) AGAINST ('Citrate')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('lesbian-sex')) AND (MATCH
(si_title) AGAINST ('Lesbian')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('zenegra')) AND (MATCH (si_title) AGAINST ('Zenegra')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('cyber-sex')) AND (MATCH
(si_title) AGAINST ('Cyber')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('free-movie-xxx')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
(si_title) AGAINST ('movie')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('cartoon-porn')) AND (MATCH (si_title) AGAINST ('Cartoon')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('world-sex')) AND (MATCH (si_title) AGAINST ('World')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('live-porn')) AND (MATCH
(si_title) AGAINST ('Live')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('black-sex')) AND (MATCH
(si_title) AGAINST ('Black')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('porn-star-finder')) AND (MATCH (si_title) AGAINST ('Porn')) AND (MATCH
(si_title) AGAINST ('star')) AND (MATCH (si_title) AGAINST ('finder')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('free-xxx')) AND (MATCH
(si_title) AGAINST ('Free')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('sex-position')) AND (MATCH (si_title) AGAINST ('position')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('porn-cam')) AND (MATCH
(si_title) AGAINST ('Porn')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('asian-porn-star')) AND (MATCH (si_title) AGAINST ('Asian')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('star')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('sex-woman')) AND (MATCH
(si_title) AGAINST ('woman')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('shemale')) AND (MATCH (si_title) AGAINST ('Shemale')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('porn-movie')) AND (MATCH
(si_title) AGAINST ('Porn')) AND (MATCH (si_title) AGAINST ('movie')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('vibrator')) AND (MATCH
(si_title) AGAINST ('Vibrator')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('double-penetration')) AND (MATCH (si_title) AGAINST ('Double')) AND (MATCH
(si_title) AGAINST ('Penetration')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('latina-porn')) AND (MATCH (si_title) AGAINST ('Latina')) AND
(MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('free-porn-gallery')) AND (MATCH (si_title) AGAINST ('Free')) AND
(MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST
('gallery')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title)
AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH
(si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST ('sex-game'))
AND (MATCH (si_title) AGAINST ('game')) AND (MATCH (si_title) AGAINST
('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title)
AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH
(si_title) AGAINST ('sex-dating')) AND (MATCH (si_title) AGAINST ('dating'))
AND (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST
('http')) AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title)
AGAINST ('myddns')) AND (MATCH (si_title) AGAINST ('vintage-porn')) AND
(MATCH (si_title) AGAINST ('Vintage')) AND (MATCH (si_title) AGAINST
('porn')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title)
AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH
(si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('porno-casting')) AND (MATCH (si_title) AGAINST ('Porno')) AND (MATCH
(si_title) AGAINST ('Casting')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('free-porn-movie')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('movie')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('porn-sex')) AND (MATCH
(si_title) AGAINST ('Porn')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('sex-chat')) AND (MATCH (si_title) AGAINST ('chat')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('free-sex-video')) AND (MATCH (si_title) AGAINST
('Free')) AND (MATCH (si_title) AGAINST ('video')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('sex-video')) AND (MATCH (si_title) AGAINST
('video')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title)
AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH
(si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('japanese-porn')) AND (MATCH (si_title) AGAINST ('Japanese')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('adult-sex')) AND (MATCH (si_title) AGAINST ('Adult')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('man-porn')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('twins-sex')) AND (MATCH (si_title) AGAINST ('Twins')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('toon-porn')) AND (MATCH
(si_title) AGAINST ('Toon')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('hot-porn')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('levitra')) AND (MATCH (si_title) AGAINST ('Levitra')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('video-porn-gratis')) AND (MATCH
(si_title) AGAINST ('Video')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('gratis')) AND (MATCH (si_title) AGAINST
('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title)
AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH
(si_title) AGAINST ('pokemon-porn')) AND (MATCH (si_title) AGAINST
('Pokemon')) AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('classic-porn')) AND (MATCH (si_title) AGAINST
('Classic')) AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('reality-porn')) AND (MATCH (si_title) AGAINST
('Reality')) AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('hdtv')) AND (MATCH (si_title) AGAINST ('HDTV'))
AND (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST
('http')) AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title)
AGAINST ('myddns')) AND (MATCH (si_title) AGAINST ('teen-sex')) AND (MATCH
(si_title) AGAINST ('Teen')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('mature-sex')) AND (MATCH (si_title) AGAINST ('Mature')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('viagra')) AND (MATCH (si_title)
AGAINST ('Viagra')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH
(si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND
(MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('transsexuals')) AND (MATCH (si_title) AGAINST ('Transsexuals')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('amateur-porn')) AND (MATCH
(si_title) AGAINST ('Amateur')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('anime-porn')) AND (MATCH
(si_title) AGAINST ('Anime')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('porn-game')) AND (MATCH
(si_title) AGAINST ('Porn')) AND (MATCH (si_title) AGAINST ('game')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('free-gay-porn')) AND (MATCH
(si_title) AGAINST ('Free')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('black-porn-star')) AND (MATCH
(si_title) AGAINST ('Black')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('star')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('gay-porn')) AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('hot-sex')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('cialis-soft-tabs')) AND (MATCH (si_title)
AGAINST ('Cialis')) AND (MATCH (si_title) AGAINST ('Soft')) AND (MATCH
(si_title) AGAINST ('Tabs')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('free-picture-xxx')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
(si_title) AGAINST ('picture')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('sex-offender')) AND (MATCH (si_title) AGAINST ('offender')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('pink-porn-star')) AND (MATCH
(si_title) AGAINST ('Pink')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('star')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('my-first-sex-teacher')) AND (MATCH (si_title) AGAINST ('teacher'))
AND (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST
('http')) AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title)
AGAINST ('myddns')) AND (MATCH (si_title) AGAINST ('porn-clip')) AND (MATCH
(si_title) AGAINST ('Porn')) AND (MATCH (si_title) AGAINST ('clip')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('arabian-sex')) AND (MATCH
(si_title) AGAINST ('Arabian')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('hardcore-sex')) AND (MATCH (si_title) AGAINST ('Hardcore')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('download-sex-movie')) AND (MATCH
(si_title) AGAINST ('Download')) AND (MATCH (si_title) AGAINST ('movie'))
AND (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST
('http')) AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title)
AGAINST ('myddns')) AND (MATCH (si_title) AGAINST ('free-hardcore-porn'))
AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH (si_title) AGAINST
('hardcore')) AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('incest-sex')) AND (MATCH (si_title) AGAINST
('Incest')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title)
AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH
(si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('porn-trailer')) AND (MATCH (si_title) AGAINST ('Porn')) AND (MATCH
(si_title) AGAINST ('trailer')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('fisting')) AND (MATCH (si_title) AGAINST ('Fisting')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('clitoris')) AND (MATCH
(si_title) AGAINST ('Clitoris')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('free-lesbian-porn')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
(si_title) AGAINST ('lesbian')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('free-porn-vids')) AND (MATCH
(si_title) AGAINST ('Free')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('vids')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('porn-picture')) AND (MATCH (si_title) AGAINST ('Porn')) AND (MATCH
(si_title) AGAINST ('picture')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('porn-star')) AND (MATCH (si_title) AGAINST ('Porn')) AND (MATCH (si_title)
AGAINST ('star')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH
(si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND
(MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('anal-sex')) AND (MATCH (si_title) AGAINST ('Anal')) AND (MATCH (si_title)
AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH
(si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND
(MATCH (si_title) AGAINST ('free-black-porn')) AND (MATCH (si_title) AGAINST
('Free')) AND (MATCH (si_title) AGAINST ('black')) AND (MATCH (si_title)
AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH
(si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND
(MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('live-sex-cam')) AND (MATCH (si_title) AGAINST ('Live')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('porn-site')) AND (MATCH
(si_title) AGAINST ('Porn')) AND (MATCH (si_title) AGAINST ('site')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('clip-free-xxx')) AND (MATCH
(si_title) AGAINST ('Clip')) AND (MATCH (si_title) AGAINST ('free')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('free-sex-pic')) AND (MATCH
(si_title) AGAINST ('Free')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('young-porn')) AND (MATCH (si_title) AGAINST ('Young')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('free-video-xxx')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
(si_title) AGAINST ('video')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('adult-sex-movie')) AND (MATCH (si_title) AGAINST ('Adult')) AND (MATCH
(si_title) AGAINST ('movie')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('asian-sex')) AND (MATCH (si_title) AGAINST ('Asian')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('viagra-soft-tabs')) AND (MATCH
(si_title) AGAINST ('Viagra')) AND (MATCH (si_title) AGAINST ('Soft')) AND
(MATCH (si_title) AGAINST ('Tabs')) AND (MATCH (si_title) AGAINST ('href'))
AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST
('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title)
AGAINST ('free-password-xxx')) AND (MATCH (si_title) AGAINST ('Free')) AND
(MATCH (si_title) AGAINST ('password')) AND (MATCH (si_title) AGAINST
('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title)
AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH
(si_title) AGAINST ('amateur-sex')) AND (MATCH (si_title) AGAINST
('Amateur')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title)
AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH
(si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('free-porn-site')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('site')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('adult-porn')) AND (MATCH
(si_title) AGAINST ('Adult')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('free-xxx-porn')) AND (MATCH
(si_title) AGAINST ('Free')) AND (MATCH (si_title) AGAINST ('porn')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('group-sex')) AND (MATCH
(si_title) AGAINST ('Group')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('free-sex-story')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
(si_title) AGAINST ('story')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('porn-video')) AND (MATCH (si_title) AGAINST ('Porn')) AND (MATCH
(si_title) AGAINST ('video')) AND (MATCH (si_title) AGAINST ('href')) AND
(MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult'))
AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('free-porn-trailer')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
(si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST ('trailer')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('free-porn-downloads')) AND
(MATCH (si_title) AGAINST ('Free')) AND (MATCH (si_title) AGAINST ('porn'))
AND (MATCH (si_title) AGAINST ('downloads')) AND (MATCH (si_title) AGAINST
('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title)
AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH
(si_title) AGAINST ('teen-porn')) AND (MATCH (si_title) AGAINST ('Teen'))
AND (MATCH (si_title) AGAINST ('porn')) AND (MATCH (si_title) AGAINST
('href')) AND (MATCH (si_title) AGAINST ('http')) AND (MATCH (si_title)
AGAINST ('adult')) AND (MATCH (si_title) AGAINST ('myddns')) AND (MATCH
(si_title) AGAINST ('oral-sex')) AND (MATCH (si_title) AGAINST ('Oral')) AND
(MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
AND (MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('viagra-professional')) AND
(MATCH (si_title) AGAINST ('Viagra')) AND (MATCH (si_title) AGAINST
('Professional')) AND (MATCH (si_title) AGAINST ('href')) AND (MATCH
(si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND
(MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
('russian-sex')) AND (MATCH (si_title) AGAINST ('Russian')) AND (MATCH
(si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http')) AND
(MATCH (si_title) AGAINST ('adult')) AND (MATCH (si_title) AGAINST
('myddns')) AND (MATCH (si_title) AGAINST ('asian-porn')) AND (MATCH
(si_title) AGAINST ('Asian')) AND (MATCH (si_title) AGAINST ('porn')) ) AND
page_is_redirect=0 AND page_namespace IN (0)   LIMIT 0,20





On 9/5/07 16:18, "John Bidder" <john at highlanddrive.wanadoo.co.uk> wrote:

> Hi All
> 
> Does anyone have any clues as to what might be causing MySQL to stop on the
> server that hosts my Wiki Project?
> 
> Its happened 3 times now over as many weeks so I asked the ISP to monitored
> it this time and this is the query being run around the time it popped.
> 
> SELECT page_id, page_namespace, page_title FROM `mw_page`,`mw_searchindex`
> WHERE page_id=si_page AND ( (MATCH (si_title) AGAINST ('href')) AND (MATCH
> (si_title) AGAINST ('http')) AND (MATCH (si_title) AGAINST ('adult')) AND
> (MATCH (si_title) AGAINST ('myddns')) AND (MATCH (si_title) AGAINST
> ('free-teen-porn')) AND (MATCH (si_title) AGAINST ('Free')) AND (MATCH
> (si_title) AGAINST ('teen')) AND (MATCH (si_title) AGAINST ('porn')) AND
> (MATCH (si_title) AGAINST ('href')) AND (MATCH (si_title) AGAINST ('http'))
> AND (MATCH (si_title) AGAINST ('adult'))
> 
> Help/tips advice appreciated
> 
> Thanks
> 
> John
> 
> 
> 
> 
> 
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> 






More information about the MediaWiki-l mailing list