Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2017-11-08, 02:07:51

Author Topic: High Load wen make MySql backup  (Read 1570 times)

0 Members and 1 Guest are viewing this topic.

Offline I<3Kloxo

  • Senior Member
  • *
  • Posts: 188
  • Karma: +0/-0
    • View Profile
High Load wen make MySql backup
« on: 2014-05-19, 21:59:59 »
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?

Offline chrisf

  • Senior Master
  • **
  • Posts: 883
  • Karma: +11/-1
  • Gender: Male
  • Be the change that you wish to see in the world.
    • View Profile
    • Conviction's Hosting
Re: High Load wen make MySql backup
« Reply #1 on: 2014-05-19, 22:52:03 »
Look into ulimit or ionice.  One of them maybe helpful
Christopher

Knowledge in: PHP, Perl, MySQL, Javascript, Actionscript, FLASH, HTML, CSS
Server Administrator / Developer: https://convictionshosting.com

Offline I<3Kloxo

  • Senior Member
  • *
  • Posts: 188
  • Karma: +0/-0
    • View Profile
Re: High Load wen make MySql backup
« Reply #2 on: 2014-05-20, 14:57:15 »
Look into ulimit or ionice.  One of them maybe helpful

I do not understand your answer.

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.044 seconds with 18 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM