The stack table iirc is used to avoid scheduling the same tracks close to each other. You should be good to just prune it when it hits, say, 8000 rows (enough for a month of fully automated play scheduled by rdlogmanger not to repeat). I don't think that Rivendell contains any logic to automatically do this for you, though. Might be worth filing a bug report in Mantis so this can get fixed, as it's clearly an issue.
Cheers, James Harrison On 11/11/2011 03:51, Gavin Stephens wrote: > The only purge options I can see for logs are purge logs after xx days > and purge ELR data after xx days via RDAdmin-->Manage Users---> xx Edit. > > But that's in 1.7.2. > > RDLogManager even in 1.7.2 just has Purge Data for Reports. > > > On 2011-11-11 07:00, Jorge Soto wrote: >> don't know about v1.6.0, but newer versions have a purge old logs >> checkbox, can't remember where right now. Don't even know if it's >> what you are looking for, but it's there. >> >> ------------------------------------------------------------------------ >> *From:* Boris Wagner <[email protected]> >> *To:* [email protected] >> *Sent:* Thursday, November 10, 2011 4:42 AM >> *Subject:* [RDD] rdlogmanager - slow log-generation >> >> Hi, >> >> we are still using Rivendell v1.6.0 at our german campus radio station >> because it runs perfectly. But after almost two years of stable >> operation rdlogmanager started to get very slow. Generation of a log >> would take up to almost an hour. >> After reading mysql-slow.log I found out that the <servicename>_STACK >> table which is somehow used for log-generation had grown to a table of >> ca. 200 000 rows and was therefore causing the delay. After dropping >> this table rdlogmanager went through log-generation as fast as usual. >> Is this a bug? Or did I miss to check some kind of "purge temporary log >> data" option somewhere in RDAdmin? >> I couldn't find anything about this issue in the most recent Changelog >> so it may also exist in later versions of Rivendell. >> >> Regards, >> Boris >> >> -- >> Hochschulradio-Aachen e.V. >> Wüllnerstraße 5 >> 52056 Aachen >> >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> <mailto:[email protected]> >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >> >> >> >> >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev > > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
