Jump to content

Manual talk:Job table

Add topic
From mediawiki.org
Latest comment: 11 years ago by Ciencia Al Poder in topic Outdated

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?

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

Outdated

[edit]

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)Reply