[Filipina]

Hello.. (smf default 1.1.10) server loads running higher than usual and I keep seeing this process running over and over.. any idea what this is, and is it normal?

Code: [Select]

SELECT posterTime, id_memberFROM smf_messagesWHERE posterTime > '%s' AND id_member = '0'

SELECT posterTime, id_memberFROM smf_messagesWHERE posterTime > '%s' AND id_member = '18799'
Thanks for any assistance

[JBlaze]

That query is checking what time a post was made by a guest and user-18799

I don't see anything wrong with it, but it shouldn't be running frequently.

[Filipina]

Thanks... I am seeing it again and again everytime i look at my status page... i don't remember seeing it so much before.

Code: [Select]

Sending data 2s     SELECT posterTime, id_memberFROM smf_messagesWHERE posterTime > '%s' AND id_member = '0'
Sending data 1s     SELECT posterTime, id_memberFROM smf_messagesWHERE posterTime > '%s' AND id_member = '0'
Sending data 2s     SELECT posterTime, id_memberFROM smf_messages messagesWHERE posterTime > '%s' AND id_member = '0'

EDIT - this is the other one that keeps showing up every few seconds.

Code: [Select]

INSERT IGNORE INTO smf_sessions (session_id, data, last_update)VALUES ('%s', '%s', 1257137314)

[Tristan Perry]

Does this happen throughout the day, or just at set intervals during the day?

It could be a cron job (server or user one) that is causing this server load rise, since those queries are normal and should be very quick to run?

[Filipina]

Thanks for the response... It seemed to be happening throughout the day, all day.. I have not seen it so much the last 36 hours and my server load is lower. My VPS host seems to be tweeking something... my server load is now 0.52, 0.51, 0.47. I will report back and mark this resolved if all is well tomorrow