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)