[Mediawiki-l] Stopping MySQL with a BIG query

[John Bidder]

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