Slow Mysql query identification...

[kontrabass]

I noticed a server load spike today (10+), caused by a couple stubborn mysql queries - I'm wondering if someone can tell me what these queries are the result of (what action?), and if anything can be done to remedy. Here are the processes, taken from the phpMyAdmin processlist:

SELECT threadid
FROM thread AS thread
LEFT JOIN deletionlog AS delthread ON ( delthread.primary

SELECT COUNT( * ) AS posts
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON ( deletionlo


These processes hung around and locked up tables, causing the spike, which didn't last long but is a concern...

TIA!

[kontrabass]

<bump>

This just happened again - same sort of locked processes. Load jumped to 15+ and forums slowed to a stop

[Nombie Wan]

You might try "not" updating thread views immedietly. A lot of updates on the thread table will queue up write locks and kill all your reads, hence bogging the server.