Backup of MySQl make Apache slow

[IT_Architect]

When we backup domains with large MySQL databases, it make the machine Apache very slow. What do you guys do to prevent that?

 

[tillo]

Unfortunately on my server the largest MySQL databases are using the MyISAM engine, so it doesn't matter how many resources it does take: those databases are locked when mysqldump is running, and I can do it only at late night since it takes a few minutes.

Anyway, I've been able to tune MySQL a lot using caches and memory optimizations, this may help during a backup too. Use the software I'm talking about in this post.

 

[IT_Architect]

Unfortunately on my server the largest MySQL databases are using the MyISAM engine, so it doesn't matter how many resources it does take: those databases are locked when mysqldump is running,

For tuning we use those and mysqltuner.pl. I'm going to go back to InnoDB. Our benchmarks simulating our traffic mix show InnoDB capable of MORE transactions per second than MyISAM, not less, and LESS load for the same number of TPS. My partner wanted to try MyISAM. I don't like seeing the spikes either 6 times an hour when we get mass updates, but they didn't affect userland. I didn't know that MySQLDump locked the DB. My understanding was it's just a big selects.

Thank you for your reply

 

[IT_Architect]

I went back to InnoDB and worked on [mysqldump]. It helped a lot but was not the complete answer. I had to lower the connections iln httpd.

After compression the backup is 700 megs. I'll set it to run during the lowest traffic period.