Manual talk:Job table

Deleting duplicate entries in Job table

My Jobs table has grown to over 100 MB. I run some queries and I found out that some jobs have more than 1000 duplicates (I made group by on everything except job_id):

SELECT job_namespace, job_title, job_cmd, count(*) 
FROM job
GROUP BY job_namespace, job_title, job_cmd

.

How do I delete those extra rows?

Is there an extension that does this?

--93.143.37.187 10:14, 16 July 2010 (UTC)