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 <frede...@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@lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
>
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel

Reply via email to