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@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