snapshot on LVM: reserved volume size for changes
Hi, ALL,
I just tried to use LVM snapshot to backup my INNODB databases.
My database is about 200GB in size, and the query is really heavy.
Each of my innodb data files are of 2GB, that means there about 100 data files in total.
As mentioned, I tried to snapshot these 200GB data, and then copy them away in 2 hours.
So my question is:
As for your experience, how much volume should I reserve for the changes that would happen in the following 2 hours?
(Hope I'm clear enough on my question.)
Thanks & Regards
Joseph
|