Home Alone
Customer
This is from my database server slow query log:
This is only happening with one user. The user only had 3 mentions and no tagged threads. Any idea what could be causing this?
Code:
use lipstick_forum;
SET timestamp=1346993407;
SELECT
user.userid,
username,
usergroupid,
membergroupids,
displaygroupid,
infractiongroupids,
user.dbtech_usertag_excluded AS excluded,
relationid,
userlist.type,
friend,
dbtech_usertag_settings,
email,
languageid,
options,
adminoptions
, mention.dateline
FROM user AS user
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.relationid = '103282')
LEFT JOIN dbtech_usertag_mention AS mention ON(mention.mentionedid = user.userid AND mention.postid = '10893141' AND mention.type = 'post')
WHERE username IN(0., 0.3, 0.32, '0.32 s', '0.32 se', '0.32 sec', '0.32 sec m', '0.32 sec ma', '0.32 sec mar', '0.32 sec mark', '0.32 sec mark[');
# Time: 120907 0:51:35
# User@Host: root[root] @ [10.0.47.23]
# Query_time: 10.743148 Lock_time: 0.000073 Rows_sent: 65513 Rows_examined: 40553179
SET timestamp=1346993495;
SELECT
user.userid,
username,
usergroupid,
membergroupids,
displaygroupid,
infractiongroupids,
user.dbtech_usertag_excluded AS excluded,
relationid,
userlist.type,
friend,
dbtech_usertag_settings,
email,
languageid,
options,
adminoptions
, mention.dateline
FROM user AS user
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.relationid = '103282')
LEFT JOIN dbtech_usertag_mention AS mention ON(mention.mentionedid = user.userid AND mention.postid = '10893141' AND mention.type = 'post')
WHERE username IN(0., 0.3, 0.32, '0.32 s', '0.32 se', '0.32 sec', '0.32 sec m', '0.32 sec ma', '0.32 sec mar', '0.32 sec mark', '0.32 sec mark[');
# Time: 120907 0:52:58
# User@Host: root[root] @ [10.0.47.23]
# Query_time: 10.815501 Lock_time: 0.000098 Rows_sent: 65513 Rows_examined: 40553179
SET timestamp=1346993578;
SELECT
user.userid,
username,
usergroupid,
membergroupids,
displaygroupid,
infractiongroupids,
user.dbtech_usertag_excluded AS excluded,
relationid,
userlist.type,
friend,
dbtech_usertag_settings,
email,
languageid,
options,
adminoptions
, mention.dateline
FROM user AS user
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.relationid = '103282')
LEFT JOIN dbtech_usertag_mention AS mention ON(mention.mentionedid = user.userid AND mention.postid = '10893141' AND mention.type = 'post')
WHERE username IN(0., 0.3, 0.32, '0.32 s', '0.32 se', '0.32 sec', '0.32 sec m', '0.32 sec ma', '0.32 sec mar', '0.32 sec mark', '0.32 sec mark[');
# Time: 120907 0:53:13
# User@Host: root[root] @ [10.0.47.23]
# Query_time: 10.342486 Lock_time: 0.000138 Rows_sent: 65513 Rows_examined: 40553179
SET timestamp=1346993593;
SELECT
user.userid,
username,
usergroupid,
membergroupids,
displaygroupid,
infractiongroupids,
user.dbtech_usertag_excluded AS excluded,
relationid,
userlist.type,
friend,
dbtech_usertag_settings,
email,
languageid,
options,
adminoptions
, mention.dateline
FROM user AS user
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.relationid = '103282')
LEFT JOIN dbtech_usertag_mention AS mention ON(mention.mentionedid = user.userid AND mention.postid = '10893141' AND mention.type = 'post')
WHERE username IN(0., 0.3, 0.32, '0.32 s', '0.32 se', '0.32 sec', '0.32 sec m', '0.32 sec ma', '0.32 sec mar', '0.32 sec mark', '0.32 sec mark[');
# Time: 120907 0:54:39
# User@Host: root[root] @ [10.0.47.23]
# Query_time: 10.668926 Lock_time: 0.000081 Rows_sent: 65513 Rows_examined: 40553179
SET timestamp=1346993679;
SELECT
user.userid,
username,
usergroupid,
membergroupids,
displaygroupid,
infractiongroupids,
user.dbtech_usertag_excluded AS excluded,
relationid,
userlist.type,
friend,
dbtech_usertag_settings,
email,
languageid,
options,
adminoptions
, mention.dateline
FROM user AS user
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.relationid = '103282')
LEFT JOIN dbtech_usertag_mention AS mention ON(mention.mentionedid = user.userid AND mention.postid = '10893141' AND mention.type = 'post')
WHERE username IN(0., 0.3, 0.32, '0.32 s', '0.32 se', '0.32 sec', '0.32 sec m', '0.32 sec ma', '0.32 sec mar', '0.32 sec mark', '0.32 sec mark[');
# Time: 120907 0:57:10
# User@Host: root[root] @ [10.0.47.23]
# Query_time: 10.327048 Lock_time: 0.000108 Rows_sent: 65513 Rows_examined: 40553179
SET timestamp=1346993830;
SELECT
user.userid,
username,
usergroupid,
membergroupids,
displaygroupid,
infractiongroupids,
user.dbtech_usertag_excluded AS excluded,
relationid,
userlist.type,
friend,
dbtech_usertag_settings,
email,
languageid,
options,
adminoptions
, mention.dateline
FROM user AS user
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.relationid = '103282')
LEFT JOIN dbtech_usertag_mention AS mention ON(mention.mentionedid = user.userid AND mention.postid = '10893141' AND mention.type = 'post')
WHERE username IN(0., 0.3, 0.32, '0.32 s', '0.32 se', '0.32 sec', '0.32 sec m', '0.32 sec ma', '0.32 sec mar', '0.32 sec mark', '0.32 sec mark[');
# Time: 120907 0:57:26
# User@Host: root[root] @ [10.0.47.23]
# Query_time: 10.497717 Lock_time: 0.000103 Rows_sent: 65513 Rows_examined: 40553179
SET timestamp=1346993846;
SELECT
user.userid,
username,
usergroupid,
membergroupids,
displaygroupid,
infractiongroupids,
user.dbtech_usertag_excluded AS excluded,
relationid,
userlist.type,
friend,
dbtech_usertag_settings,
email,
languageid,
options,
adminoptions
, mention.dateline
FROM user AS user
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.relationid = '103282')
LEFT JOIN dbtech_usertag_mention AS mention ON(mention.mentionedid = user.userid AND mention.postid = '10893141' AND mention.type = 'post')
WHERE username IN(0., 0.3, 0.32, '0.32 s', '0.32 se', '0.32 sec', '0.32 sec m', '0.32 sec ma', '0.32 sec mar', '0.32 sec mark', '0.32 sec mark[');This is only happening with one user. The user only had 3 mentions and no tagged threads. Any idea what could be causing this?
