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
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@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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
John Bidder wrote:
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
[...]
Looks like someone is trying to post spam via your search box. Contact them and ask them to kindly post it via the edit box instead.
A quick hack like this should also fix the problem:
Index: SpecialSearch.php =================================================================== --- SpecialSearch.php (revision 21993) +++ SpecialSearch.php (working copy) @@ -31,6 +31,9 @@ global $wgRequest, $wgUser;
$search = $wgRequest->getText( 'search', $par ); + if ( strlen( $search ) > 200 ) { + throw new MWException( "Search query too big" ); + } $searchPage = new SpecialSearch( $wgRequest, $wgUser ); if( $wgRequest->getVal( 'fulltext' ) || !is_null( $wgRequest->getVal( 'offset' ) ) ||
On 09/05/07, Tim Starling tstarling@wikimedia.org wrote:
Looks like someone is trying to post spam via your search box. Contact them and ask them to kindly post it via the edit box instead.
You timed this for my coffee, didn't you.
- d.
mediawiki-l@lists.wikimedia.org