Greetings,

That's why when I was running Koha 3.6.x on a machine with only 512MB RAM with no swap and 20GB disk space, I would after hours:
- restart mysql
- shut off apache
- backup
- turn on apache
This would free up some much needed RAM so that the backup would work. :)

Now we've (both Koha and the library group) grown such that I would never dream of running with less than 1GB RAM and some swap.

GPML,
Mark Tompsett

-----Original Message----- From: David Cook
Sent: Wednesday, November 18, 2015 9:55 PM
To: 'Robin Sheat' ; [email protected]
Subject: Re: [Koha-devel] incremental backup of the DB

I agree with Robin. I've seen another system that does database dumps during the middle of the day while the database server is running, and the increased server load is quite significant. I'm also guessing that locking takes place as sometimes the load will skyrocket during this time. Besides the huge lowering of performance, your data might be inaccurate or even corrupt anyway since you might be doing a backup midway through a script action.

_______________________________________________
Koha-devel mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to