[Automysqlbackup-users] Mysqlbackup fails an brings the server down
Automatic MySQL Backup
Brought to you by:
wipe_out
From: Ward L. <wa...@lo...> - 2011-06-02 07:44:47
|
Hello, I currently use automysqlbackup to backup 10databases. There is one big database that contains a table with +- 780.000records. When mysqlbackup executes it fails (on that table) and brings my websites down (maybe the load is so high that apache processes can't answer in time). Looks like there are a lot of query's executed at the moment of backup and maybe the query's are locking each other. I also get the following by email: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `video` at row: 745740 I think this are 2seperate problems: - Mysql backup script failing - Website's are down (because the use of too many resources?) Do you guys have any ideas how to fix this? Can you let the script run in low priority mode, so that it doesn't eat the resources and does not lock any tables ? Thanks! Ward |