[Koha-devel] File sizes

[Fridolin SOMERS]

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 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
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at 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 at biblibre.com