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. <br>
<br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">For an <code class="literal">InnoDB</code> table before version 5.0.3,
<code class="literal">InnoDB</code> processes
<a href="http://dev.mysql.com/doc/refman/5.0/en/truncate.html" title="12.2.10. TRUNCATE Syntax"><code class="literal">TRUNCATE TABLE</code></a>
by deleting rows one by one.<br></blockquote><div><br>(from <a href="http://dev.mysql.com/doc/refman/5.0/en/truncate.html">http://dev.mysql.com/doc/refman/5.0/en/truncate.html</a> )<br> </div>I imagine if you don't care about killing open sessions, then performance at that moment probably doesn't matter either.<br>
-- <br>Joe Atzberger<br>LibLime - Open Source Library Solutions<br>
<br><br><div class="gmail_quote">On Tue, May 19, 2009 at 8:17 AM, <span dir="ltr"><<a href="mailto:carpentercarselibrary@gmavt.net">carpentercarselibrary@gmavt.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
In reviewing the size of our Koha 3 db, I've noticed that our sessions<br>
table is huge! Is it safe to truncate this table periodically? What<br>
would I lose by doing so?<br>
<br>
Thanks for any input!<br>
<br>
Richard Pritsky, Assistant Director<br>
Carpenter-Carse Library<br>
PO BOX 127<br>
Hinesburg, VT 05461<br>
802-482-2878<br>
<a href="http://www.carpentercarse.org" target="_blank">www.carpentercarse.org</a><br></blockquote></div><br><br>