[Koha-devel] File sizes

Paul A paul.a at navalmarinearchive.com
Fri Feb 28 23:54:21 CET 2014


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 at 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 at 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 at 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 



More information about the Koha-devel mailing list