For our production machines, we change sessions and zebraqueue tables engine to MyISAM (because they do not have any foreign key). With cleanup_database.pl set in crontab every night, those tables file size is stable. Regards, Le 28/02/2014 23:54, Paul A a écrit :
At 12:59 PM 2/28/2014 -0800, Galen Charlton wrote:
Hi,
On Fri, Feb 28, 2014 at 12:37 PM, Michael Hafen <michael.hafen@washk12.org> wrote: [snip]
-rw-rw---- 1 mysql mysql 1551892480 Feb 28 12:53 import_records.ibd [snip] -rw-rw---- 1 mysql mysql 490733568 Feb 28 13:30 zebraqueue.ibd
One thing to note is that if you use cleanup_database.pl to do things like trim the zebraqueue table or purge old staged import records,
We've found that it's the 'sessions' that accumulate. We cron it every morning at 3am, but I just ran it manually now (13.5 hours later) and get:
whoever@nelson:/usr/share/koha$ ./bin/cronjobs/cleanup_database.pl --sessions -v Session purge triggered. 55203 entries will be deleted. Done with session purge. [This is maybe [???] due to some bots that don't respect the robots.txt (baidu? I'm getting close to blocking them at router level)]
zebraqueue (same 13.5 hours) only gave me '602 records were deleted.' and
whoever@nelson:/usr/share/koha$ ./bin/cronjobs/cleanup_database.pl --import 1 -v Purging records from import tables. Done with purging import tables.
is not 'verbose' despite the -v ;={
Best - Paul _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Fridolin SOMERS Biblibre - Pôles support et système fridolin.somers@biblibre.com