[Koha-devel] Koha sessions table is ridiculously huge

[Clay Fouts]

Definitely. Even though the session table may in many cases be much smaller
than other tables in terms of bytes or rows, the frequency at which it is
written to causes it to be heavily fragmented on the disk, which greatly
reduces the average throughput during a mysqldump, increasing the backup
time.


On Wed, Feb 17, 2010 at 12:10 PM, Frederic Demians <frederic at tamil.fr>wrote:

> And since you must backup daily your Koha DB, you should truncate
> sessions table just before mysqldump-ing in order to backup as few
> sessions data as possible.
> --
> Frédéric
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20100217/b7330601/attachment-0003.htm>