| Dave84311 |
07-23-2011 05:45 PM |
If you have a large forum, I would suggest not using this plugin. Why? Because it can be used to DDOS your forum. Apparently some smart ass spammed mentions or viewed mentions with a bot, and completely took down my forum. Not only that, but deleting mentions also makes my mysql go ape shit.
Quote:
| 11020 | forum | localhost | forum | Query | 1 | Copying to tmp table | SELECT
post.pagetext AS message,
post.title AS posttitle,
thread.title AS threadtitle,
mention.dateline,
mention.postid,
mention.type,
user.userid,
user.username,
user.usergroupid,
user.infractiongroupid,
user.displaygroupid,
mentioned.userid AS mentioneduserid,
mentioned.username AS mentionedusername,
mentioned.usergroupid AS mentionedusergroupid,
mentioned.infractiongroupid AS mentionedinfractiongroupid,
mentioned.displaygroupid AS mentioneddisplaygroupid
FROM dbtech_usertag_mention AS mention
LEFT JOIN post AS post ON (post.postid = mention.postid)
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
LEFT JOIN user AS user ON (user.userid = mention.userid)
LEFT JOIN user AS mentioned ON (mentioned.userid = mention.mentionedid)
WHERE (mention.userid = 512784
OR mention.mentionedid = 512784)
AND thread.forumid IN(55,57,56,336,339,337,340,338,342,341,1,12,7,104 ,2,195,345,72,42,88,89,117,145,90,91,315,316,67,73 ,303,48,8,380,148,38,196,379,40,86,344,68,314,192, 354,313,180,226,440,39,6,10,70,76,170,37,118,259,7 4,75,166,270,147,201,282,283,284,289,285,216,450,1 41,217,214,318,364,169,360,174,190,468,460,142,381 ,171,191,227,228,269,279,281,482,308,323,286,229,2 45,352,355,356,368,361,373,357,304,404,395,418,419 ,420,164,197,506,183,305,500,186,484,184,207,334,4 44,210,319,211,266,293,403,292,288,416,172,223,302 ,224,225,295,271,263,359,375,376,397,409,515,476,2 65,199,175,232,504,182,306,309,296,243,212,242,443 ,194,290,287,256,320,254,324,366,388,387,499,389,3 99,321,28,189,126,136,159,262,442,291,365,129,61,4 61,105,453,426,433,474,132,168,29,297,173,298,127, 299,187,300,137,301,239,513,273,119,400,431,435,43 6,456,457,458,466,471,486,493,494,495,505,507,510, 278,370,383,390,312,394,153,274,483,294,398,204,41 3,414,428,462,434,200,261,351,202,246,429,177,176, 264,208,146,116,218,219,220,222,221,258,377,98,329 ,346,514,472,347,335,421,384,439,386,411,385,422,4 17,454,120,276,488,489,452,501,267,423,396,438,437 ,455,209,139,247,35,36,59,131,46,62,358,363,371,37 2,374,391,392,401,402,412,415,448,424,425,427,432, 441,445,446,447,449,451,459,463,464,465,467,213,46 9,473,477,478,479,480,481,485,487,496,497,498,508, 509,311,178,343,249,154,43,328,331,206,215,121,330 ,325,327,158,326,152,179,307,203,406,408,407,503,2 48,14,27,31,33,161,162,19,512,106,53,160,280,32,34 ,310,378,198,250,511,268,47,3,140,251,252,253,151, 17,193,24,233,234,237,238,362,236,348,349,350,235, 255,240,241,230,367,231,4,277,322,122,275,382,125, 490,123,124,143,165,393,475,18,20,26,21,22,25,41,5 8,60,69,87,78,81,50,82,103,51,110,111,112,113,115, 13,369,244,114,83,84,133,85,130,49,272,92,94,95,96 ,260,257,93,97,0)
AND mention.type = 'post'
ORDER BY dateline DESC, userid
LIMIT 0, 20 |
|
I saw this with "SHOW FULL PROCESSLIST;" about thirty times... |
More Information