Stacking queries...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Taco John
    Senior Member
    • Nov 2002
    • 114

    Stacking queries...

    I received this from Rackspace Cloud support and I'm not sure what to do... ------

    Hello, During routine maintenance we noticed mysql queries stacking as a result of slow queries from your database. We limited the number of connections from your website to 5. Below, we're attaching the 10 highest entries in our MySQL Slow log from your database.

    Report for msl logs: /var/log/mysql/mysql-slow.log ?top 10
    2.21k queries total, 187 unique
    Sorted by 't_sum'
    Grand Totals: Time 62.66k s, Lock 2.13k s, Rows sent 775.96k, Rows Examined 1.99M


    ______________________________________________________________________ 001 ___
    Count : 177 (8.01%)
    Time : 6200.598219 s total, 35.031628 s avg, 10.044299 s to 155.908574 s max (9.90%)
    95% of Time : 4979.541324 s total, 29.640127 s avg, 10.044299 s to 116.18218 s max
    Lock Time (s) : 925.903 ms total, 5.231 ms avg, 45 ?s to 590.773 ms max (0.04%)
    95% of Lock : 15.661 ms total, 93 ?s avg, 45 ?s to 192 ?s max
    Rows sent : 13 avg, 0 to 17 max (0.30%)
    Rows examined : 13 avg, 0 to 17 max (0.12%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.66.103 : 19.77% (35) of query, 14.31% (316) of all users
    504157_lopez934@ 172.17.35.79 : 18.64% (33) of query, 15.39% (340) of all users
    504157_lopez934@ 172.17.34.198 : 13.56% (24) of query, 11.50% (254) of all users
    504157_lopez934@ 172.17.35.77 : 12.99% (23) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.66.133 : 12.43% (22) of query, 13.40% (296) of all users
    504157_lopez934@ 172.17.34.15 : 7.91% (14) of query, 8.74% (193) of all users
    504157_lopez934@ 172.17.34.194 : 7.91% (14) of query, 12.72% (281) of all users
    504157_lopez934@ 172.17.66.105 : 6.78% (12) of query, 9.05% (200) of all users

    Query abstract:
    SELECT * FROM datastore WHERE title IN (S18);

    Query sample:
    SELECT *
    FROM datastore
    WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smil iecache','bbcodecache','mailqueue','bookmarksitecache');

    ______________________________________________________________________ 002 ___
    Count : 135 (6.11%)
    Time : 5627.696423 s total, 41.68664 s avg, 10.16085 s to 142.048873 s max (8.98%)
    95% of Time : 4682.429387 s total, 36.58148 s avg, 10.16085 s to 120.980467 s max
    Lock Time (s) : 687.715 ms total, 5.094 ms avg, 49 ?s to 673.751 ms max (0.03%)
    95% of Lock : 12.425 ms total, 97 ?s avg, 49 ?s to 220 ?s max
    Rows sent : 11 avg, 0 to 16 max (0.19%)
    Rows examined : 11 avg, 0 to 16 max (0.07%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.66.103 : 19.26% (26) of query, 14.31% (316) of all users
    504157_lopez934@ 172.17.34.15 : 14.81% (20) of query, 8.74% (193) of all users
    504157_lopez934@ 172.17.35.77 : 14.81% (20) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.66.133 : 14.07% (19) of query, 13.40% (296) of all users
    504157_lopez934@ 172.17.34.194 : 11.11% (15) of query, 12.72% (281) of all users
    504157_lopez934@ 172.17.66.105 : 9.63% (13) of query, 9.05% (200) of all users
    504157_lopez934@ 172.17.35.79 : 8.15% (11) of query, 15.39% (340) of all users
    504157_lopez934@ 172.17.34.198 : 8.15% (11) of query, 11.50% (254) of all users

    Query abstract:
    SELECT * FROM datastore WHERE title IN (S17);

    Query sample:
    SELECT *
    FROM datastore
    WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smil iecache','bbcodecache','ranks');

    ______________________________________________________________________ 003 ___
    Count : 276 (12.49%)
    Time : 5524.380131 s total, 20.01587 s avg, 10.003548 s to 39.685883 s max (8.82%)
    95% of Time : 5002.938495 s total, 19.095185 s avg, 10.003548 s to 34.988402 s max
    Lock Time (s) : 20.376888 s total, 73.829 ms avg, 38 ?s to 2.316583 s max (0.96%)
    95% of Lock : 2.295595 s total, 8.762 ms avg, 38 ?s to 679.383 ms max
    Rows sent : 1 avg, 0 to 1 max (0.02%)
    Rows examined : 1 avg, 0 to 1 max (0.01%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.35.79 : 18.84% (52) of query, 15.39% (340) of all users
    504157_lopez934@ 172.17.66.133 : 18.12% (50) of query, 13.40% (296) of all users
    504157_lopez934@ 172.17.34.194 : 15.58% (43) of query, 12.72% (281) of all users
    504157_lopez934@ 172.17.66.103 : 14.86% (41) of query, 14.31% (316) of all users
    504157_lopez934@ 172.17.35.77 : 11.59% (32) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.34.198 : 10.51% (29) of query, 11.50% (254) of all users
    504157_lopez934@ 172.17.34.15 : 7.61% (21) of query, 8.74% (193) of all users
    504157_lopez934@ 172.17.66.105 : 2.90% (8) of query, 9.05% (200) of all users

    Query abstract:
    SELECT * FROM session WHERE sessionhash = 'S' AND lastactivity > N AND idhash = 'S';

    Query sample:
    SELECT *
    FROM session
    WHERE sessionhash = '54d9df095a86c7fc941d25ad269f830f'
    AND lastactivity > 1321616066
    AND idhash = 'e4bc1dcc9a70068bee34b03be3f6ac41';

    ______________________________________________________________________ 004 ___
    Count : 140 (6.34%)
    Time : 5148.824582 s total, 36.777318 s avg, 10.770606 s to 113.185616 s max (8.22%)
    95% of Time : 4531.644168 s total, 34.072513 s avg, 10.770606 s to 80.934581 s max
    Lock Time (s) : 706.432306 s total, 5.045945 s avg, 213 ?s to 43.013117 s max (33.23%)
    95% of Lock : 428.523738 s total, 3.221983 s avg, 213 ?s to 35.075361 s max
    Rows sent : 17 avg, 0 to 25 max (0.31%)
    Rows examined : 111 avg, 0 to 169 max (0.78%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.35.77 : 18.57% (26) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.35.79 : 17.14% (24) of query, 15.39% (340) of all users
    504157_lopez934@ 172.17.66.103 : 15.00% (21) of query, 14.31% (316) of all users
    504157_lopez934@ 172.17.34.198 : 14.29% (20) of query, 11.50% (254) of all users
    504157_lopez934@ 172.17.34.194 : 12.86% (18) of query, 12.72% (281) of all users
    504157_lopez934@ 172.17.66.105 : 9.29% (13) of query, 9.05% (200) of all users
    504157_lopez934@ 172.17.66.133 : 7.86% (11) of query, 13.40% (296) of all users
    504157_lopez934@ 172.17.34.15 : 5.00% (7) of query, 8.74% (193) of all users

    Query abstract:
    SELECT post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = N, N, N) AS isdeleted, user.*, userfield.*, usertextfield.*, icon.title AS icontitle, icon.iconpath, avatar.avatarpath, NOT isnull(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory, postparsed.pagetext_html, postparsed.hasimages, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, IF(user.displaygroupid=N, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM post AS post LEFT JOIN user AS user ON(user.userid = post.userid) LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid) LEFT JOIN icon AS icon ON(icon.iconid = post.iconid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid) LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = N AND postparsed.languageid = N) LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = N AND sigparsed.languageid = N) LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid) WHERE post.postid IN (N26) ORDER BY post.dateline;

    Query sample:
    SELECT
    post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
    user.*, userfield.*, usertextfield.*,
    icon.title as icontitle, icon.iconpath,
    avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
    editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
    editlog.reason AS edit_reason, editlog.hashistory,
    postparsed.pagetext_html, postparsed.hasimages,
    sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
    sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
    IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
    FROM post AS post
    LEFT JOIN user AS user ON(user.userid = post.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
    LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
    LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
    LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
    LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 2 AND postparsed.languageid = 1)
    LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 2 AND sigparsed.languageid = 1)
    LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
    WHERE post.postid IN (0,3378262,3378292,3378305,3378319,3378322,3378323,3378324,3378334,3378351,3378352,3378360 ,3378365,3378366,3378378,3378383,3378386,3378387,3378400,3378403,3378405,3378406,3378408,3 378433,3378447,3378451)
    ORDER BY post.dateline;

    ______________________________________________________________________ 005 ___
    Count : 81 (3.67%)
    Time : 3149.555942 s total, 38.883407 s avg, 10.206039 s to 142.344956 s max (5.03%)
    95% of Time : 2515.507806 s total, 33.098787 s avg, 10.206039 s to 94.563584 s max
    Lock Time (s) : 2.890074 s total, 35.68 ms avg, 59 ?s to 2.089619 s max (0.14%)
    95% of Lock : 8.112 ms total, 107 ?s avg, 59 ?s to 213 ?s max
    Rows sent : 11 avg, 0 to 19 max (0.12%)
    Rows examined : 11 avg, 0 to 19 max (0.05%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.66.133 : 20.99% (17) of query, 13.40% (296) of all users
    504157_lopez934@ 172.17.35.79 : 19.75% (16) of query, 15.39% (340) of all users
    504157_lopez934@ 172.17.34.194 : 14.81% (12) of query, 12.72% (281) of all users
    504157_lopez934@ 172.17.35.77 : 14.81% (12) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.66.105 : 12.35% (10) of query, 9.05% (200) of all users
    504157_lopez934@ 172.17.34.15 : 6.17% (5) of query, 8.74% (193) of all users
    504157_lopez934@ 172.17.66.103 : 6.17% (5) of query, 14.31% (316) of all users
    504157_lopez934@ 172.17.34.198 : 4.94% (4) of query, 11.50% (254) of all users

    Query abstract:
    SELECT * FROM datastore WHERE title IN (S20);

    Query sample:
    SELECT *
    FROM datastore
    WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','user stats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

    ______________________________________________________________________ 006 ___
    Count : 134 (6.07%)
    Time : 2627.180819 s total, 19.605827 s avg, 10.024368 s to 40.119595 s max (4.19%)
    95% of Time : 2361.502786 s total, 18.59451 s avg, 10.024368 s to 34.705845 s max
    Lock Time (s) : 4.586505 s total, 34.228 ms avg, 39 ?s to 2.100794 s max (0.22%)
    95% of Lock : 12.071 ms total, 95 ?s avg, 39 ?s to 352 ?s max
    Rows sent : 0 avg, 0 to 1 max (0.01%)
    Rows examined : 267 avg, 0 to 555 max (1.79%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.35.77 : 24.63% (33) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.34.194 : 11.94% (16) of query, 12.72% (281) of all users
    504157_lopez934@ 172.17.66.103 : 11.94% (16) of query, 14.31% (316) of all users
    504157_lopez934@ 172.17.34.15 : 11.19% (15) of query, 8.74% (193) of all users
    504157_lopez934@ 172.17.35.79 : 10.45% (14) of query, 15.39% (340) of all users
    504157_lopez934@ 172.17.34.198 : 10.45% (14) of query, 11.50% (254) of all users
    504157_lopez934@ 172.17.66.105 : 10.45% (14) of query, 9.05% (200) of all users
    504157_lopez934@ 172.17.66.133 : 8.96% (12) of query, 13.40% (296) of all users

    Query abstract:
    SELECT * FROM session WHERE userid = N AND host = 'S' AND idhash = 'S' LIMIT N;

    Query sample:
    SELECT *
    FROM session
    WHERE userid = 0
    AND host = '94.228.34.214'
    AND idhash = 'd496f192022e8411850e58e8d8373126'
    LIMIT 1;

    ______________________________________________________________________ 007 ___
    Count : 78 (3.53%)
    Time : 1838.06485 s total, 23.564934 s avg, 10.218594 s to 103.290054 s max (2.93%)
    95% of Time : 1568.006298 s total, 21.189274 s avg, 10.218594 s to 45.914459 s max
    Lock Time (s) : 5.829 ms total, 75 ?s avg, 33 ?s to 175 ?s max (0.00%)
    95% of Lock : 5.198 ms total, 70 ?s avg, 33 ?s to 138 ?s max
    Rows sent : 21 avg, 0 to 37 max (0.21%)
    Rows examined : 2.97k avg, 0 to 26.30k max (11.62%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.35.79 : 23.08% (18) of query, 15.39% (340) of all users
    504157_lopez934@ 172.17.66.105 : 15.38% (12) of query, 9.05% (200) of all users
    504157_lopez934@ 172.17.34.198 : 14.10% (11) of query, 11.50% (254) of all users
    504157_lopez934@ 172.17.34.194 : 12.82% (10) of query, 12.72% (281) of all users
    504157_lopez934@ 172.17.66.103 : 10.26% (8) of query, 14.31% (316) of all users
    504157_lopez934@ 172.17.34.15 : 8.97% (7) of query, 8.74% (193) of all users
    504157_lopez934@ 172.17.35.77 : 8.97% (7) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.66.133 : 6.41% (5) of query, 13.40% (296) of all users

    Query abstract:
    SELECT post.postid FROM post AS post WHERE post.threadid = N AND post.visible = N ORDER BY post.dateline LIMIT N, N;

    Query sample:
    SELECT post.postid
    FROM post AS post
    WHERE post.threadid = 21798
    AND post.visible = 1
    ORDER BY post.dateline
    LIMIT 0, 25;

    ______________________________________________________________________ 008 ___
    Count : 83 (3.76%)
    Time : 1688.017298 s total, 20.337558 s avg, 10.139656 s to 67.739233 s max (2.69%)
    95% of Time : 1441.532627 s total, 18.481188 s avg, 10.139656 s to 36.925887 s max
    Lock Time (s) : 952.754 ms total, 11.479 ms avg, 23 ?s to 948.336 ms max (0.04%)
    95% of Lock : 3.994 ms total, 51 ?s avg, 23 ?s to 76 ?s max
    Rows sent : 0 avg, 0 to 0 max (0.00%)
    Rows examined : 0 avg, 0 to 0 max (0.00%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.34.198 : 19.28% (16) of query, 11.50% (254) of all users
    504157_lopez934@ 172.17.35.79 : 14.46% (12) of query, 15.39% (340) of all users
    504157_lopez934@ 172.17.35.77 : 14.46% (12) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.34.15 : 13.25% (11) of query, 8.74% (193) of all users
    504157_lopez934@ 172.17.34.194 : 13.25% (11) of query, 12.72% (281) of all users
    504157_lopez934@ 172.17.66.133 : 12.05% (10) of query, 13.40% (296) of all users
    504157_lopez934@ 172.17.66.105 : 8.43% (7) of query, 9.05% (200) of all users
    504157_lopez934@ 172.17.66.103 : 4.82% (4) of query, 14.31% (316) of all users

    Query abstract:
    INSERT INTO threadviews (threadid) VALUES (N)1;

    Query sample:
    INSERT INTO threadviews (threadid)
    VALUES (99251);

    ______________________________________________________________________ 009 ___
    Count : 51 (2.31%)
    Time : 1684.769423 s total, 33.034695 s avg, 10.180156 s to 101.914933 s max (2.69%)
    95% of Time : 1416.071869 s total, 29.501497 s avg, 10.180156 s to 67.116884 s max
    Lock Time (s) : 3.954 ms total, 78 ?s avg, 47 ?s to 195 ?s max (0.00%)
    95% of Lock : 3.46 ms total, 72 ?s avg, 47 ?s to 126 ?s max
    Rows sent : 37 avg, 0 to 46 max (0.24%)
    Rows examined : 37 avg, 0 to 46 max (0.09%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.35.77 : 25.49% (13) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.66.133 : 21.57% (11) of query, 13.40% (296) of all users
    504157_lopez934@ 172.17.34.15 : 11.76% (6) of query, 8.74% (193) of all users
    504157_lopez934@ 172.17.34.194 : 11.76% (6) of query, 12.72% (281) of all users
    504157_lopez934@ 172.17.34.198 : 9.80% (5) of query, 11.50% (254) of all users
    504157_lopez934@ 172.17.66.103 : 9.80% (5) of query, 14.31% (316) of all users
    504157_lopez934@ 172.17.66.105 : 5.88% (3) of query, 9.05% (200) of all users
    504157_lopez934@ 172.17.35.79 : 3.92% (2) of query, 15.39% (340) of all users

    Query abstract:
    SELECT subscribeforumid, forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid FROM forum AS forum LEFT JOIN subscribeforum AS subscribeforum ON (subscribeforum.forumid = forum.forumid AND subscribeforum.userid = N);

    Query sample:
    SELECT subscribeforumid, forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid
    FROM forum AS forum
    LEFT JOIN subscribeforum AS subscribeforum ON (subscribeforum.forumid = forum.forumid AND subscribeforum.userid = 27604);

    ______________________________________________________________________ 010 ___
    Count : 48 (2.17%)
    Time : 1643.158204 s total, 34.232463 s avg, 10.429118 s to 109.163009 s max (2.62%)
    95% of Time : 1338.764107 s total, 29.750313 s avg, 10.429118 s to 78.625093 s max
    Lock Time (s) : 76.626515 s total, 1.596386 s avg, 43 ?s to 27.045106 s max (3.60%)
    95% of Lock : 25.079208 s total, 557.316 ms avg, 43 ?s to 10.668613 s max
    Rows sent : 15 avg, 0 to 18 max (0.09%)
    Rows examined : 32 avg, 0 to 37 max (0.08%)
    Database : 504157_vbulletin
    Users :
    504157_lopez934@ 172.17.35.79 : 29.17% (14) of query, 15.39% (340) of all users
    504157_lopez934@ 172.17.66.103 : 16.67% (8) of query, 14.31% (316) of all users
    504157_lopez934@ 172.17.35.77 : 12.50% (6) of query, 14.85% (328) of all users
    504157_lopez934@ 172.17.34.15 : 10.42% (5) of query, 8.74% (193) of all users
    504157_lopez934@ 172.17.66.133 : 8.33% (4) of query, 13.40% (296) of all users
    504157_lopez934@ 172.17.34.198 : 8.33% (4) of query, 11.50% (254) of all users
    504157_lopez934@ 172.17.66.105 : 8.33% (4) of query, 9.05% (200) of all users
    504157_lopez934@ 172.17.34.194 : 6.25% (3) of query, 12.72% (281) of all users

    Query abstract:
    SELECT moderator.*, user.username, IF(user.displaygroupid = N, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM moderator AS moderator INNER JOIN user AS user USING(userid);

    Query sample:
    SELECT moderator.*, user.username,
    IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
    FROM moderator AS moderator
    INNER JOIN user AS user USING(userid);
  • Taco John
    Senior Member
    • Nov 2002
    • 114

    #2
    any advice?

    Comment

    • Taco John
      Senior Member
      • Nov 2002
      • 114

      #3
      Is the staff out on vacation this week or something?

      Comment

      • dilbert
        Senior Member
        • Oct 2004
        • 887

        #4
        You better off to submit a ticket, I've always received a fast response to a ticket.
        Cliff
        PathLabTalk
        Square Wheels Cycling

        Comment

        • IBxAnders
          Senior Member
          • Aug 2001
          • 1172
          • 4.0.x

          #5
          Do you use global ignore fetures or "Tachy Goes to Coventry" ?
          anders | vbulletin team | check out the new vbulletin facebook app
          Proudly vBulletin'ing since 2001
          Please be my friend!
          http://www.twitter.com/inetskunkworks
          vBulletin Performance Articles:
          Click here to read

          Comment

          • Taco John
            Senior Member
            • Nov 2002
            • 114

            #6
            Yes, I have a few of those in the system... I have a pretty long list of banned IP addresses. I have quite a few banned email addresses (spammers mostly). I don't have any coventry listings.

            Comment

            • IBxAnders
              Senior Member
              • Aug 2001
              • 1172
              • 4.0.x

              #7
              Originally posted by Taco John
              Yes, I have a few of those in the system... I have a pretty long list of banned IP addresses. I have quite a few banned email addresses (spammers mostly). I don't have any coventry listings.
              I have seen some session related issues related to having a bunch of blocked, censored and coventried entries. That might potentially be the cause - but suspect something else is going on.
              anders | vbulletin team | check out the new vbulletin facebook app
              Proudly vBulletin'ing since 2001
              Please be my friend!
              http://www.twitter.com/inetskunkworks
              vBulletin Performance Articles:
              Click here to read

              Comment

              • Zachery
                Former vBulletin Support
                • Jul 2002
                • 59097

                #8
                Keep your ip ban list as trimmed as possible, while it is possible to ban ips in vBulletin it is not ideal. That ENTIRE list is loaded into memory on each page view and checks agasint the persons ip in the list. IP banning should be done before vBulletin (server, firewall, webserver, etc)

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...