I have one problem. When I doing MySQL backup collapses whole VPS server. Load grows up to 12 and RAM memory is full. I own KVM VPS, 4 Core, 1 GB Ram, 2GB Swap. Web pages are in this moment offline until the server responds to ping.
I wonder if it is possible limit mysql when I doing msql backup? Let's say I give a limit when doing backup the maximum that can be consumes 256MB Ram and over that can not? Is there some trick or something to no collapses VPS server while doing backup?