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?
--220.127.116.11 10:14, 16 July 2010 (UTC)