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, 01:54:09

Author Topic: High Load wen make MySql backup  (Read 1569 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 4 Global Search Engines:    Google    Bing    Baidu    Yahoo

Page created in 0.048 seconds with 18 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM