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

Product	Versions

MediaWiki	1.21alpha (35f559d)

PHP	       5.3.17 (apache2handler)

MySQL	       5.1.50-MariaDB-log

Wiki: elinux.org

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