My forums are still running very slowly so I'm trying a variety of things, including logging slow queries. I occasionally get one like this -
# Time: 121205 3:39:37
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 11.296875 Lock_time: 0.031250 Rows_sent: 200 Rows_examined: 2526
use wine;
SET timestamp=1354696777;
SELECT p.POST_ID
FROM ubbt_POSTS p LEFT JOIN ubbt_POSTS pp on p.POST_ID=pp.POST_ID,
ubbt_TOPICS t
WHERE p.POST_IS_APPROVED = '1'
AND t.TOPIC_STATUS <> 'M'
AND t.FORUM_ID IN ('1','2','3','4','35','36','9','34','37','39','38','40')
AND p.TOPIC_ID = t.TOPIC_ID
AND MATCH (p.POST_SUBJECT,p.POST_DEFAULT_BODY) AGAINST ('eifrxxjofjousp, <a href=\"http://johannagonzalez.com/\">Online Casino</a>, AdhYOwh,
Online casino cribbage, fiFOEJN,
http://johannagonzalez.com/ Online casino us slot invaders moolah, DwGkfCT, <a href=\"http://vigrx2k.com/\">Does vigrx really work</a>, eTRCYvn,
Vigrx suit, lVAymLd,
http://vigrx2k.com/ Vigrx vs extagen, EzoPDHu, <a href=\"http://cnbook.org/\">Buy cheap viagra online uk</a>, oHZxUMG,
Viagra alternative, KeiQGND,
http://cnbook.org/ Viagra suppliers in the uk, pjUqTMs, <a href=\"http://searchuktravel.com/\">HCG</a>, GavChGj,
Mushrooms on hcg diet, LEYaNFp,
http://searchuktravel.com/ Hcg diet recipes, LxnKRRW, <a href=\"http://johnniesbaseball.com/\">Free online casino slot games</a>, dPpSxTV,
Up bonus online casino, KdCltEk,
http://johnniesbaseball.com/ Virtual online casino, YMnYNxO, <a href=\"http://capsiplextreatment.com/\">Capsiplex</a>, KPUsBOs,
Trackback lascia un commento capsiplex in usa, fLyKZyB,
http://capsiplextreatment.com/ Capsiplex, HGTWReR.' IN BOOLEAN MODE)
ORDER BY p.POST_POSTED_TIME DESC
LIMIT 200;
I imagine this is spam I don't want to deal with. I thought I remembered a way to have only logged in users able to do searches. Was that my imagination or is that a real feature? I run a spammer-blocker add-on so I imagine that would help a fair amount.
