cpu throttling log

[farsgsm]

Dear friends,

my host fell in cpu throttling many times daily...
i cheked mysqlslow queris log and i see this info

# Sat Sep 12 05:33:52 2009
# Query_time: 10 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use ****mc_vb2;
SELECT postid, wordid,
CASE intitle
WHEN 0 THEN score
WHEN 1 THEN score + 5
WHEN 2 THEN score + 5 + 5
ELSE score
END AS score
FROM postindex
WHERE wordid IN (0,546,1842,7101,168,207,26040,535,209,580)

# Sat Sep 12 05:51:39 2009
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use ****mc_vb2;
SELECT postid
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
WHERE post.userid = 4163
AND post.post_thanks_amount != 0
AND thread.forumid IN(1,45,123,47,46,2,3,5,8,14,6,11,4,13,9,10,12,7,1 5,16,94,87,90,132,18,149,22,17 ,19,110,126,20,111,127,21,112,128,75,113,129,108,1 14,130,23,30,95,190,26,164,78, 125,88,80,97,28,29,27,82,124,109,76,25,92,79,83,10 7,91,89,99,24,85,74,81,96,157, 158,166,167,168,181,182,183,184,159,60,63,64,176,1 77,160,172,173,174,175,178,179 ,69,70,72,180,185,186,187,188,115,131,116,101,100, 102,150,151,156,103,152,155,10 6,105,153,154,104,35,77,191,36,37,38,39,40,41,86,4 2,133,52,84,134,135,141,136,13 9,140,143,142,138,144,137,145,148,165,48,44,49,73, 147,146,50,51)
ORDER BY post.dateline DESC
LIMIT 1000

what does it mean
what plugins or something esle i have to disable to make cpu ok

[James Birkett]

Looks like some sort of thanks mod..
WHERE post.userid = 4163
AND post.post_thanks_amount != 0

[farsgsm]

thanks for your reply.
but u mean a thanks plugin can use cpu this much to make my cpu throtle?

--------------- Added 1252765590 at 1252765590 ---------------

here is the latest log
and i have to tell than i'm using 2-3 sql database on my host

# Sat Sep 12 07:41:22 2009
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use f****_shop;
SELECT image_path, image_type, alt, image_x, image_y FROM c****_product_images
WHERE image_id='1585'



i don't know what exactly cause my cpu throttle

[James Birkett]

You have any image modifications installed?

SELECT image_path, image_type, alt, image_x, image_y FROM c****_product_images
WHERE image_id='1585'


Looks like some form of image modification/retrieval.

[farsgsm]

thanks friend,
i disabled some of my unused plugins and now cpu feel better

:)

[James Birkett]

You're welcome :)

[farsgsm]

i disabled many of my installed plugins and problem almost solved on yesterday,
but today i again face problem, cpu throttling at much high value
i talked to host supporter and he told me to disable PHP5 (FastCGI)
and use PHP5 (Single php.ini) instead.

what's your opinion?
do vbulleting not works well on PHP5 (FastCGI)?

and one of my latest mysqlslow queris log is below:

# Mon Sep 14 09:44:26 2009
# Query_time: 9 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use ******c_vb2;
SELECT postid, wordid,
CASE intitle
WHEN 0 THEN score
WHEN 1 THEN score + 5
WHEN 2 THEN score + 5 + 5
ELSE score
END AS score
FROM postindex
WHERE wordid IN (0,42,20663,2457)


maybe i'm under attack :(

[James Birkett]

I can't seem to decipher that latest log. I can't think of anything it will reference to.
Hopefully a more expert in vBulletin can help you out there (or post over at vBulletin.com).
Do you know which file is causing this? (showthread? forumdisplay?)