Manual talk:Job table

Jump to navigation Jump to search

Deleting duplicate entries in Job table[edit]

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?

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


This page is outdated according to last table definition: [1]. I'll try to complete the info if I have time. --Ciencia Al Poder (talk) 09:39, 24 May 2013 (UTC)