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);
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);
Comment