[Koha] Cleaning out Sessions table?
ohiocore at gmail.com
Wed May 20 05:50:13 NZST 2009
Yes it is safe to purge sessions at some regular interval. It *may* be safe
to perform a total purge via TRUNCATE, but that is dicier. Obviously, any
open sessions would be eliminated, and it might hurt performance.
For an InnoDB table before version 5.0.3, InnoDB processes TRUNCATE
rows one by one.
(from http://dev.mysql.com/doc/refman/5.0/en/truncate.html )
I imagine if you don't care about killing open sessions, then performance at
that moment probably doesn't matter either.
LibLime - Open Source Library Solutions
On Tue, May 19, 2009 at 8:17 AM, <carpentercarselibrary at gmavt.net> wrote:
> In reviewing the size of our Koha 3 db, I've noticed that our sessions
> table is huge! Is it safe to truncate this table periodically? What
> would I lose by doing so?
> Thanks for any input!
> Richard Pritsky, Assistant Director
> Carpenter-Carse Library
> PO BOX 127
> Hinesburg, VT 05461
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Koha