Thread:Project:Support desk/SQL statements that were taking 10,000 to 26,000 milliseconds

Occasionally, I see a massive slow down of my wiki due to SQL queries such as:

-- 3049.511 s     Time:26,600 ms  Call count:1379

SELECT /­* Job­Queue­DB­:­:claim­Random Wmat */­ * FROM `job` WHERE job_­cmd = ? AND job_­token = ? AND ­(job_­random >= ?­)­ ORDER BY job_­random ASC LIMIT ? --- 3468.882 s     Time:10,100 ms  Call count:618

UPDATE /­* Job­Queue­DB­:­:claim­Random Wmat */­ `job` SET job_­token = ?,­ job_­token_­timestamp = ?,­ job_­attempts = job_­attempts+? WHERE job_­cmd = ? AND job_­id = ? AND job_­token = ?

I can't seem to find any references to this anywhere. Any thoughts on how to fix this?

Thanks Bill