Bug #54407 My SQL frequent errors# 144, 2006
Submitted: 10 Jun 2010 19:45 Modified: 10 Jun 2010 20:43
Reporter: fareed Quraishi Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Errors Severity:S1 (Critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[10 Jun 2010 19:45] fareed Quraishi
Description:
Here are some of the database queries that are slow and consume a lot of server resources:

LIST OF QUERIES
       Executed 14 min ago for 6 sec on Database --> ezcool_abc.
       SELECT data.tagid, data.tagtext, SUM(data.searchcount) AS searchcount FROM ( SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount FROM tagcontent AS tagcontent INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid) INNER JOIN thread AS thread ON (tagcontent.contentid = thread.threadid) WHERE tagcontent.contenttypeid IN (2) AND tagcontent.dateline > 1244611169 AND thread.open <> 10 AND thread.visible = 1 AND thread.forumid IN (1,2,4,5,6,7,8,9,11,12,13,15,14,16,17,18,19,20,21,22,23,45,46,41,42,43,44,37,38,39,40,24,25,26,27,28,29,30,33,34,35,36,31) GROUP BY tagcontent.tagid, tag.tagtext ) AS data GROUP BY data.tagid, data.tagtext ORDER BY searchcount DESC LIMIT 150
      

How to repeat:
       Executed 10 min ago for 3 sec on Database --> ezcool_abc.
       SELECT thread.threadid, thread.title, thread.lastpost, thread.lastpostid, thread.forumid, thread.lastposter, thread.dateline, thread.views, thread.replycount, thread.visible, thread.open, thread.prefixid, user.username, user.userid, user.usergroupid, user.displaygroupid FROM thread AS thread LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(32) ORDER BY lastpost DESC LIMIT 0, 10
       
Executed 10 min ago for 6 sec on Database --> ezcool_abc.
       INSERT INTO searchcore (username, contenttypeid, primaryid, groupcontenttypeid, groupid, ipaddress, userid, dateline, searchgroupid) VALUES ( '', 3, 23, 3, 23, 0, 0, 1276147212, 33 ) ON DUPLICATE KEY UPDATE username = VALUES(username), contenttypeid = VALUES(contenttypeid), primaryid = VALUES(primaryid), groupcontenttypeid = VALUES(groupcontenttypeid), groupid = VALUES(groupid), ipaddress = VALUES(ipaddress), userid = VALUES(userid), dateline = VALUES(dateline), searchgroupid = VALUES(searchgroupid
[10 Jun 2010 20:43] Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

From your report is not clear where is bug in MySQL code.