Bug Slow MYsql Query

[Mick]

Found these in my slow query Log:

Not sure if this is vbulletin Tags or the advanced tags????

Feel free to delete if nothing to do with this modification

# Time: 140225  9:23:19
# User@Host: ****** @  [127.0.0.1]
# Thread_id: 317407  Schema: vb44  QC_hit: No
# Query_time: 10.502251  Lock_time: 0.000116  Rows_sent: 1270  Rows_examined: 5723295
SET timestamp=1393320199;
SELECT
				tag.tagid,
				tag.tagtext AS tag,
				COUNT(*) AS numthreads,
				MAX(lastpost) AS lastupdate
			FROM theforumprefix__thread AS thread
			INNER JOIN theforumprefix__tagcontent AS tagcontent ON (tagcontent.contentid = thread.threadid)
			INNER JOIN theforumprefix__tag AS tag ON (tag.tagid = tagcontent.tagid)
			WHERE thread.forumid IN(3,509,437,258,14,15,343,560,474,8,559,81,536,526,510,537,284,378,473,475,466,424,476,464,534,492,494,493,495,46,511,233,115,278,234,235,35,563,565,562,564,566,567,568,411,583,585,600,603,602,609,599,462,606,604,605,607,601,612,614,610,615,611,616,648,649,650,19,242,32,213,480,43,482,77,229,654,56,289,18,479,428,538,469,31,71,319,320,321,325,323,322,324,523,477,364,608,363,461,397,398,587,465,399,481,315,5,470,471,472,413,372,373,374,375,652,447,145,528,446,439,444,441,440,442,445,443,418,420,423,419,422,421,148,149,275,539,386,132,580,590,500,498,499,501,30,351,429,555,570,569,571,572,645,646,647,451,294,637,452,639,638,636,635,453,454,455,456,389,620,621,512,513,517,518,619,514,618,515,516,390,391,457,627,531,625,622,448,626,628,629,630,631,632,380,240,573,591,623,387,579,574,576,575,388,577,578,432,593,633,597,634,596,598,594,653,581,582,640,641,642,643,644,450,458,384,430,550,558,490,524,270,267,265,266,544,353,354,545,547,369,548,358,361,356,392,357,359,360,4,370,9,13,16,540,306,136,245,651,551,554,133,40,42,60,368,541,552,288,347,533,156,37,542,553,263,57,543,285,414,417,415,416,617,261,7,78)
				AND tagcontent.contenttypeid = 2
				AND thread.postuserid NOT IN (69873)
				AND thread.visible = 1
				AND thread.open <> 10
				AND tag.tagid >= 59795
			GROUP BY tag.tagid
			ORDER BY tag.tagid ASC
			LIMIT 35001;
# Time: 140225 21:53:27
# User@Host: ****** @  [127.0.0.1]
# Thread_id: 689020  Schema: vb44  QC_hit: No
# Query_time: 13.959362  Lock_time: 0.000124  Rows_sent: 1510  Rows_examined: 7348756
SET timestamp=1393365207;
SELECT
				tag.tagid,
				tag.tagtext AS tag,
				COUNT(*) AS numthreads,
				MAX(lastpost) AS lastupdate
			FROM theforumprefix__thread AS thread
			INNER JOIN theforumprefix__tagcontent AS tagcontent ON (tagcontent.contentid = thread.threadid)
			INNER JOIN theforumprefix__tag AS tag ON (tag.tagid = tagcontent.tagid)
			WHERE thread.forumid IN(3,509,437,258,14,15,343,560,474,8,559,81,536,526,510,537,284,378,473,475,466,424,476,464,534,492,494,493,495,46,511,233,115,278,234,235,35,563,565,562,564,566,567,568,411,583,585,600,603,602,609,599,462,606,604,605,607,601,612,614,610,615,611,616,648,649,650,19,242,32,213,480,43,482,77,229,654,56,289,18,479,428,538,469,31,71,319,320,321,325,323,322,324,523,477,364,608,363,461,397,398,587,465,399,481,315,5,470,471,472,413,372,373,374,375,652,447,145,528,446,439,444,441,440,442,445,443,418,420,423,419,422,421,148,149,275,539,386,132,580,590,500,498,499,501,30,351,429,555,570,569,571,572,645,646,647,451,294,637,452,639,638,636,635,453,454,455,456,389,620,621,512,513,517,518,619,514,618,515,516,390,391,457,627,531,625,622,448,626,628,629,630,631,632,380,240,573,591,623,387,579,574,576,575,388,577,578,432,593,633,597,634,596,598,594,653,581,582,640,641,642,643,644,450,458,384,430,550,558,490,524,270,267,265,266,544,353,354,545,547,369,548,358,361,356,392,357,359,360,4,370,9,13,16,540,306,136,245,651,551,554,133,40,42,60,368,541,552,288,347,533,156,37,542,553,263,57,543,285,414,417,415,416,617,261,7,78)
				AND tagcontent.contenttypeid = 2
				AND thread.postuserid NOT IN (69873)
				AND thread.visible = 1
				AND thread.open <> 10
				AND tag.tagid >= 0
			GROUP BY tag.tagid
			ORDER BY tag.tagid ASC
			LIMIT 35001;

Thanks all

 

[Fillip H.]

That is vBulletin, nothing we have control over unfortunately