Hi Stephen, sorry if your e-mail went by unnoticed (or unanswered). Please see my comment on the ticket, you can (to my knowledge) remove the job data at any given time. Just make sure to only remove those that have been completed (which you are doing according to the query you posted).
Tobias On 14.08.2012, at 09:17, Stephen Marquard <[email protected]> wrote: > Hi all, > > I didn't hear back from anyone as to why this should be the case, so > have filed it as a bug: > > https://opencast.jira.com/browse/MH-9031 > > Also is there any reason why completed jobs could not be removed > manually from the table? e.g. > > delete from job where date_completed is not null; > delete from job_arguments where id not in (select id from job); > > Regards > Stephen > > Stephen Marquard, Learning Technologies Co-ordinator > Centre for Educational Technology, University of Cape Town > http://www.cet.uct.ac.za > Email/IM/XMPP: [email protected] > Phone: +27-21-650-5037 Cell: +27-83-500-5290 > > >>>> Stephen Marquard <[email protected]> 8/13/2012 9:12 AM >>>> > Hi all, > > In our production db (running for about 9 months), the job and > job_arguments tables seem to grow continuously: > > mysql> select count(*) from job; > +----------+ > | count(*) | > +----------+ > | 62371 | > +----------+ > 1 row in set (0.16 sec) > > mysql> select count(*) from job_arguments; > +----------+ > | count(*) | > +----------+ > | 109887 | > +----------+ > 1 row in set (2.87 sec) > > Should some maintenance task be taking clear of cleaning out old > records? Should we run SQL daily to delete old records? > > Regards > Stephen > > > Stephen Marquard, Learning Technologies Co-ordinator > Centre for Educational Technology, University of Cape Town > http://www.cet.uct.ac.za > Email/IM/XMPP: [email protected] > Phone: +27-21-650-5037 Cell: +27-83-500-5290 > > > > > > ### > > UNIVERSITY OF CAPE TOWN > > This e-mail is subject to the UCT ICT policies and e-mail disclaimer > published on our website at > http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable > from > +27 21 650 9111. This e-mail is intended only for the person(s) to > whom > it is addressed. If the e-mail has reached you in error, please notify > the author. If you are not the intended recipient of the e-mail you > may > not use, disclose, copy, redirect or print the content. If this e-mail > is not related to the business of UCT it is sent by the sender in the > sender's individual capacity. > > ### > > > _______________________________________________ > Matterhorn mailing list > [email protected] > http://lists.opencastproject.org/mailman/listinfo/matterhorn > > > To unsubscribe please email > [email protected] > _______________________________________________ > > > > > > ### > > UNIVERSITY OF CAPE TOWN > > This e-mail is subject to the UCT ICT policies and e-mail disclaimer > published on our website at > http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from > +27 21 650 9111. This e-mail is intended only for the person(s) to whom > it is addressed. If the e-mail has reached you in error, please notify > the author. If you are not the intended recipient of the e-mail you may > not use, disclose, copy, redirect or print the content. If this e-mail > is not related to the business of UCT it is sent by the sender in the > sender's individual capacity. > > ### > > > _______________________________________________ > Matterhorn mailing list > [email protected] > http://lists.opencastproject.org/mailman/listinfo/matterhorn > > > To unsubscribe please email > [email protected] > _______________________________________________ _______________________________________________ Matterhorn mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email [email protected] _______________________________________________
